Forum Stats

  • 3,679,580 Users
  • 57,524 Discussions
  • 190,818 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
NetSuite Maintenance - September 25
Please note that on Saturday, September 25, 2021, at 10:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 180 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Cheers to 1️⃣0️⃣ years of #SuiteWorld! 🎉 We’re celebrating by extending the Super Saver Pass AND launching the digital On Air experience TODAY! Whether you join us in-person or digitally, we can’t wait to make even more memories with you. https://lnkd.in/dGpPpmUV
Webinar | COSTING 101: Learning the Basics of Inventory Costing webinar was a success! Please take a minute to fill out this short survey. For those who missed it - Don't worry! Here's the link to the recorded session!
NetSuite Support Assistant: A quicker way to get answers to your basic NetSuite questions
The NetSuite Support Assistant is a convenient chatbot SuiteApp that provides quick responses to your basic questions directly from your NetSuite Account.
Click NetSuite Support Assistant Now Available for more details.
Release Preview 2021.2

If you would like to receive a 2021.2 Release Preview account, please opt -in to take advantage of the Release Preview access period to prepare and become familiar with the new NetSuite capabilities. For details, see Requesting a Release Preview Account.

If you receive a Release Preview account in 2021.2, you can access it several weeks before your production account is scheduled for an upgrade to the new release of NetSuite. Notifications with details about Release Preview availability are sent to the account administrators as described in Release Preview Notifications. Release Preview availability information is also posted on the New Release portlet.

How to increase ODBC query timeout to more than 4 hours?

User_Z0HOR
User_Z0HOR Member, forum_userscommunity_users Posts: 4 Newbie

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:`

so, the question - Is it possible to increase the timeout from 3 hours to bigger value (24 hours for example)?

Thanks in advance!

Answers

  • Emilia Ironov-Oracle
    Emilia Ironov-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 703 Gold Trophy

    Hi Oleksandr,


    Welcome to NS Support Community and thank you for posting your concern here! 

    For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your preferred username so other members can address you properly moving forward. 😊

    Please allow our gurus/members to look into this and update you for any findings. 

    We will get back to you as soon as possible!  

     

    Anyone else who has an insight? Feel free to reply to this thread! 

    Kind regards,

    Emilia Ironov - Oracle | Ask a Guru

  • Mikko De La Fuente-Oracle
    Mikko De La Fuente-Oracle forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 1,146 Silver Trophy

    Hi @User_Z0HOR ,

    May we ask what application you are using for your ODBC Connection?(E.g MS Access/Excel/Etc)

    -Mikko

  • User_Z0HOR
    User_Z0HOR Member, forum_userscommunity_users Posts: 4 Newbie
    edited Sep 15, 2021 11:01AM 31.43.147.101

    Hi Mikko,

    We use our dotNet client (C#) via NetSuite ODBC driver.

  • Mikko De La Fuente-Oracle
    Mikko De La Fuente-Oracle forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 1,146 Silver Trophy

    Have you tried changing the value of commandTimeout to 0? See external reference.(Please note that this is not official documentation of NetSuite)

    Additionally, fetching large data volume will result to timeout due to custom field limitation. See SuiteAnalytics Connect Guide via Help Center for reference.

    I do suggest to breakdown the query into smaller pieces rather than longer query. Specifying the needed columns in the table could also improve performance.

    -Mikko

  • User_Z0HOR
    User_Z0HOR Member, forum_userscommunity_users Posts: 4 Newbie

    Hi Mikko,

    yes, sure, we use this code:

    _command = _connection.CreateCommand();
    _command.CommandText = _commandText;
    _command.CommandTimeout = 0;
    return await _command.ExecuteReaderAsync(CommandBehavior.SingleResult);
    

    Additionally, fetching large data volume will result to timeout due to custom field limitation. See SuiteAnalytics Connect Guide via Help Center for reference.

    can you please provide a link?

  • Mikko De La Fuente-Oracle
    Mikko De La Fuente-Oracle forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 1,146 Silver Trophy

    You can click the Help on the upper part of your NetSuite Account.

    Then search for User Guides.

    Then click on SuiteAnalytics Connect Guide.

    It means that the timeout for ODBC is a standard behavior and I would suggest to submit an enhancement request to increase it.

    -Mikko