KB 850996-How to create a Dexsql.log file to troubleshoot error messages in Microsoft Dynamics GP

INTRODUCTION
This article describes how to create a Dexsql.log file for Microsoft Dynamics GP.
More Information
When you receive an error message in Microsoft Dynamics GP, a Dexsql.log file is a helpful tool that can frequently provide more information to troubleshoot issues. If you can re-create the error message, the Dexsql.log file can capture this information.


To create a Dexsql.log file, follow these steps:

1. Open the Dex.ini file. By default, this file is in the following location:
   • Microsoft Dynamics GP 10.0 and later releases:

C:\Program Files\Microsoft Dynamics\GP\Data

2. Locate the following statements in the Dex.ini file:
3. SQLLogSQLStmt=FALSE
4. SQLLogODBCMessages=FALSE
5. SQLLogAllODBCMessages=FALSE

6. If the statements are currently set to FALSE, change the statements to TRUE, as follows:
7. SQLLogSQLStmt=TRUE
8. SQLLogODBCMessages=TRUE

SQLLogAllODBCMessages=TRUE

9. Start Microsoft Dynamics GP. If Microsoft Dynamics GP is already started, exit Microsoft Dynamics GP, and then restart it.
10. Re-create the scenario in which you received the error message. Log into the window needed, bug before you do the steps to generate the error message, you should go  clear out the dexsql.log that has ran to this point (as you only want it to capture generating the error message only, and don't need anything captured up to this point ). To do this, go to the next step.
11. In Windows Explorer, open the Microsoft Dynamics GP application folder that you opened in step 1. Locate the Dexsql.log file.  Simplly delete or rename this file, as you do not need anything it captured up to this point.
    
    (If you do not see the Dexsql.log file listed, click View, and then click Refresh so that you can see the new file.  Or check your path.)
12. Now back in Microsoft Dynamics GP, continue to perform the final steps to re-create the error message.  A new Dexsql.log file will be generated in the Microsoft Dynamics GP application folder again, that contains only the syntac of generating the error message.
13. Turn the dexsql.log off:  To do this, open the Dex.ini file, and then reset the statements to FALSE or to the original settings.  (Note: it will continue to run until the user logs out of Microsoft Dynamics GP and back in again.  It doesn't hurt to leave it run either, but may result in the log getting large and causing performance issues down the road.)