MORE INFORMATION

Review the blog article here:

https://community.dynamics.com/gp/b/dynamicsgp/archive/2019/04/30/dealing-with-timeout-errors-during-year-end-closing-procedures

 

ISSUE

After clicking Close year in the year-end closing window (for step 11 of KB 888003) for General Ledger in Microsoft Dynamics GP, the progress bar starts to fill up, but then you suddenly get this error message:

Query timeout expired

 

 

CAUSE:

The "Query timeout expired" message is indicating that GP did not receive a response from a SQL query within the time allotted by GP. By default, GP will wait 300 seconds (5 minutes). That limit is implemented so that GP is not hung up indefinitely when waiting for a response to a SQL query (for example if there is damaged data preventing the action from completing or a SQL query that creates a continuous loop). 300 seconds is normally plenty of time to complete a single query, but in some cases the data being queried can branch out and cause the query to run much longer than expected. This is especially the case during Step 3 of the Year-End Closing routine, which is when currency translation occurs. That process is very data intensive and often requires more than 5 minutes to complete.

RESOLUTION:

There is a quick fix to add a tag ro your Dex.ini file:

1.  Path out to the Dex.ini file in the Data folder in the Microsoft Dynamics GP code folder and right-click on it and open it with Notepad.  The default location is usually:  

C:\Program Files (x86)\Microsoft Dynamics\GP\Data\


2.  Add this tag line to the end of the file: and then close the file and save your changes.  Restart GP. 

SQLQueryTimeout=0

Note: There are two other settings that may also be useful to add as well that can help with simliar errors with reports, etc: 

SQLRprtsTimeout=0
SQLProcsTimeout=0

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×