I run a query in a SQL Server job every morning at...
# suiteanalytics
p
I run a query in a SQL Server job every morning at 6am through an ODBC Linked Server that SELECTs rows from transaction_lines. Some nights it fails with the message "[NetSuite][ODBC 64bit driver][64bit Client]Network problem, connection unexpectedly closed by peer". I checked with my peers and nobody closed it. Has anyone seen this? It would be nice if there was a suiteanalytics ODBC group without Saved Search questions.
b
I have encountered that in the past though not a specific cause. It fell into the bucket of random network/connection issues. I added loops to wait and retry in order to continue with the process.