Troubleshooting issues with a DexSQL.log file
When trying to troubleshoot issues, a common request from Microsoft support and from Partners is to run a DexSQL.log file. A DexSQL.log is a file that logs commands made from Dynamics GP to the database to help understand performance issues. After creation, this file is sent to the company's partner or to Microsoft for assistance in troubleshooting.
When creating a
DexSQL.log file, the key is to capture only the amount of data related to the problem. In this recipe, we will look at creating a DexSQL.log file to provide more information to Microsoft support.
For our example, we will assume that the problem relates to creating a financial batch, so that is the process that will get captured in the DexSQL.log file.
How to do it…
To create a DexSQL.log file, follow these steps:
- Ensure that Microsoft Dynamics GP is closed.
- Open the Notepad utility in Windows.
- Select File | Open in Notepad and navigate to the location where the
Dex.inifile...
