O'Reilly logo

Microsoft Dynamics GP 2013 Cookbook by Mark Polino, Ian Grieve

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Troubleshooting issues with a DexSQL log

When trying to troubleshoot issues, a common request from Microsoft support and from partners is to run a DexSQL log. 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, 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 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.

How to do it... ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required