This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have a pull from SA hitting every hour and pulling over 1.3 million rows in about 6 mins - and about once a week I get “[NetSuite][SuiteAnalytics Connect JDBC Driver]TCP/IP error, connection reset by peer.”

I'd assume (and it an assumption) that your usage is so great that you're randomly getting a reset cos the server is cycling and managing connections regularly

you using 6min of every hour... so your connection is hot 10% of always

so just a law of big numbers thing i think

what happens on error? do you have retry logic or just let it pickup on the next hour?

no retry logic it just goes the next hour

it’s not a big deal, just wasn’t sure if there if was another way to solve for that

so if that's not ok for some reason, implement retry logic, which I assume is probably find and just DOES reconnect

if that's not actually a problem, just shrug and move on :smile:

not a huge problem, just making sure there wasn’t an easy fix that’s like “oh yes turn on “big data button” on your instance and it should fix it, “haha

oh sorry, I have no clue there might well be some known solution, not something I've seen before tho