Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
How to increase ODBC query timeout to more than 4 hours?
Hi,
We faced with query timeout issue.
The big query (like `SELECT ... FROM [TRANSACTION_LINES]`) failing with error 'Internal network error, session aborted, connection closed' after 3-4 hours of fetching a data.
from several sources:
https://netsuite.custhelp.com/app/answers/detail/a_id/24837
`The timeout set for a single query made via ODBC is 3 hours unless the user sets a lower time out on their application.`
https://netsuite.custhelp.com/app/answers/detail/a_id/97315
`To avoid a timeout error, the Command Timeout can be set to 0 (to let the Query run infinitely) as demonstrated in the below sample code:`