Home » Blog » How to create a Dexsql.log file to troubleshoot error messages in Microsoft Dynamics GP

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:
    C:\Program Files\Microsoft Dynamics\GP\Data
  2. Locate the following statements in the Dex.ini file:
    SQLLogSQLStmt=FALSE
    SQLLogODBCMessages=FALSE
    SQLLogAllODBCMessages=FALSE
  3. If the statements are currently set to FALSE, change the statements to TRUE, as follows:
    SQLLogSQLStmt=TRUE
    SQLLogODBCMessages=TRUE
    SQLLogAllODBCMessages=TRUE
  4. Start Microsoft Dynamics GP. If Microsoft Dynamics GP is already started, exit Microsoft Dynamics GP, and then restart it.
  5. Re-create the scenario in which you received the error message. Stop before you receive the error message.
  6. In Windows Explorer, open the Microsoft Dynamics GP application folder that you opened in step 1. Locate the Dexsql.log file. Delete or rename this file.
  7. If you do not see the Dexsql.log file, click View, and then click Refresh so that you can see the new file.
  8. In Microsoft Dynamics GP, complete the final steps to re-create the error message. You now have a new Dexsql.log file in the Microsoft Dynamics GP application folder.
  9. Open the Dex.ini file, and then reset the statements to FALSE or to the original settings.

OAG International is an experienced Microsoft Competency Partner with offices in San Francisco, CA specializing in affordable Microsoft Dynamics GP consulting, development and deployment on premise or in the Azure Cloud..
Contact us for a complimentary needs analysis and to learn how you can benefit from our lower prices, faster service and the strongest commitment to customer satisfaction around.

Schedule Analysis

Microsoft Dynamics GP Resources Library

Have you considered a cloud-based Microsoft Dynamics GP solution?

Microsoft Dynamic GP Cloud Hosting

Want to hear how we've helped other customers like you?

helped other customers like you

Moving from a legacy system?

moving from legacy system

Questions?

Contact Oag
 
 

Copyright © 2015 OAGint.com - All Rights Reserved