Freigeben über

Support Debugging Tool for Microsoft Dynamics GP

  • Artikel

David MeegoYou may have heard about the Support Debugging Tool for Microsoft Dynamics GP.  A sneak preview of the tool was shown at the Microsoft Dynamics GP Technical Airlift 2008 in May and it was extremely well received.  The demo was a little premature as the tool's release to the partner community was still in the planning stage, but the opportunity to show what it can do to the partners at the conference could not be missed.

This posting is just to let you know that progress towards the release to partners has been steady and we are getting closer to posting it on PartnerSource Secure Link.

 

What is the Support Debugging Tool?  

The Support Debugging Tool is a Dexterity built application which contains a collection of utilities and tools to make the task of supporting, developing and debugging Microsoft Dynamics GP easier and faster.  

I originally developed the tool when Microsoft Dynamics Support in the Asia Pacific region was assisting a customer with a situation that produced invalid data in a table, but no cause could be replicated.  Looking at the customer’s data it was verified that there was an incorrect value in the table.  No one was able to identify when the previously correct value in the table was being changed to the incorrect value. 

Using Dexterity triggers and the ability to programmatically control Dexterity and SQL logging, the Support Debugging Tool was built and used to monitor the table field in question and log the steps which led up to the field changing to the incorrect value.  It was able to identify the situation and provide the exact scripts being executed up to the point the error occurred. This information allowed the code issue to be identified and fixed.

Since then the features of the tool have been expanded and will continue to expand as feedback and needs demand.

 

What can it do for me?

The tool currently contains the following Standard Mode features (that do not require system administrator or database owner (dbo) privileges):

  • Manual Logging Mode
    Turn on SQL logging, Dexterity script logging, and Dexterity script profiling with a single mouse click without needing to edit the dex.ini file or exit the application. Start logging just before an error or performance problem and stop logging immediately afterwards.

  • Individual Logging Mode
    Control SQL logging, Dexterity script logging, and Dexterity script profiling individually.

  • Dex.ini Settings
    Provides an user interface to a number of Debugging Tool, application and debugging related dex.ini file settings.

  • Resource Information
    Identifies display names, technical names, physical names and resource IDs for dictionary resources (forms, windows, reports, tables and fields) from any one known value. Great for entering obscure SQL column names (physical names) and getting the field's technical name.

  • Security Profiler
    Monitors all application level security requests. This is a great tool for identifying the cause of privilege errors caused by hidden windows.

  • Configuration Export/Import
    Allows Support Debugging Tool settings to be exported and imported using XML files. You can create settings on your system and send them to the customer to use.

The tool currently contains the following Advanced Mode features (that do require system administrator or database owner (dbo) privileges. Dexterity and SQL skills are also necessary):

  • Automatic Debugger Mode
    This is the mode where you can create a Dexterity trigger to execute off almost any event. It can then run a sanScript script (which can include SQL queries) to check for some sort of error condition. While this mode is active, the system will be logging all Dexterity and SQL activity and so when the error condition occurs the complete logs of the events leading up to the condition have been captured.

  • Dictionary Control
    This window allows the application dictionaries in the system to be control without manually editing the Dynamics.set launch file. You can disable triggers and use of alternate windows and these changes can be remembered for next login. Great for "removing" 3rd party add-ons when testing. You can also re-order products in the Dynamics.set launch file to resolve potential clashes between 3rd party add-ons.

  • XML Table Export
    You can select any number of tables from any product in the system and export them as a single XML file. This can be used to backup demo or test data, or can be used to obtain specific data from the customer without sending a backup of the entire database.

  • XML Table Import
    You can import back any table(s) previously exported using the XML Table Export tool.

  • Runtime Execute
    This is a Dexterity sanScript editor which can be used to execute any script in the context of any dictionary. It includes a number of helper functions to make working across dictionaries easier. Sometimes fixing data is much easier in a procedural language environment rather than a SQL query.

  • SQL Execute
    This is a mini SQL Query Analyzer which can be used to execute almost any Transact-SQL script. It includes the ability to automatically translate Dexterity technical names for tables and fields into their physical name equivalents used by SQL. No need to install the SQL Administration tools just to run a quick query.

  • Configuration Maintenance
    This option just allows the settings in the tool to be cleared if they are no longer needed.

NOTE: While in Standard Mode, the Automatic Debugger Mode can be active, it just cannot have any settings changed.

 

Where can I see more?

As part of the Microsoft Dynamics GP Technical Airlift 2008, the Troubleshooting Your Developed Solution session had a demonstration of the Support Debugging Tool.  As a partner you should be able to view the Live Meeting recording of this session using the link below.  The demo of the tool starts at slide 20 (Time 00:40:33).

https://training.partner.microsoft.com/plc/details.aspx?publisher=12&delivery=248798 Secure Link

Click Registration, then click Attend Web Seminar. This should get you to the link below.  Use this direct link if the link above does not work for you.

https://www106.livemeeting.com/cc/partners1/view?id=C4NRFJ&role=attend&pw=d33c0a

Then enter your name and click View Recording. Then enter your email address and company name and click View Recording. Finally, click on the Live Meeting or Windows Media Player icon to choose your desired format.  Advance the presentation to slide 20 or time 00:40:33.

 

Downloads

For downloads, please see the Support Debugging Tool Portal Page:

Support Debugging Tool Portal

 

Support Information 

The Support Debugging Tool is a custom built tool to provide additional capabilities to troubleshoot issues and is not part of the standard Microsoft Dynamics GP released application. Technical support for this tool is not handled via the standard support systems and instead is provided via the public Microsoft Dynamics GP Community Forum. You can use the link below to access the forum:

https://community.dynamics.com/forums/32.aspx

To assist the partners and Microsoft employees who monitor the forum for these questions, please prefix any subject lines with the initials "SDT: ".

 

More Information

For more information, please see the Support Debugging Tool Portal Page:

Support Debugging Tool Portal

 

The decision to only post it on PartnerSource was made because it is a very powerful tool and we wanted the partners to decide when and how it is used.  We did not want a customer installing it without their partner's knowledge and using an Advanced Mode feature to do something that could damage their system.

Please add your feedback as comments, will this tool be useful to you?

David

28-Aug-2008: Added link to Technical Airlift 2008 Live Meeting Demonstration.

03-Sep-2008: Added link to release announcement blog post.

06-Nov-2008: Added Are you using the Support Debugging Tool? post.

19-Nov-2008: Added instructions for the Technical Airlift 2008 Live Meeting Demonstration and direct links.

06-May-2009: Added link to the Support Debugging Tool Tag page.

12-Jun-2009: Information about why the tool was only released to PartnerSource.

29-Sep-2009: Added link for Installation FAQ post.

10-Mar-2010: Added link for Support Debugging Tool Portal page.

16-May-2013: Updated More Information and Downloads to link to Support Debugging Tool Portal page.

Comments

  • Anonymous
    July 30, 2008
    PingBack from http://blogs.msdn.com/developingfordynamicsgp/archive/2008/07/11/microsoft-dynamics-gp-technical-airlift-2008.aspx

  • Anonymous
    July 30, 2008
    Dave, this is superb! Thanks for the update and all the other wonderful posts! Jivtesh

  • Anonymous
    July 31, 2008
    Can not wait for this tool.  As a 'patient' partner when to expect to release the product for BETA testing?

  • Anonymous
    August 04, 2008
    Posting from Dynamics GL Blogster http://dynamicsgpblogster.blogspot.com/2008/07/microsoft-dynamics-gp-support-debugging.html

  • Anonymous
    August 24, 2008
    Sound like good I'm waiting for that tools Thank David

  • Anonymous
    August 31, 2008
    Posting from the Dynamics GP Blogster http://dynamicsgpblogster.blogspot.com/2008/08/first-look-at-support-debugging-tool.html

  • Anonymous
    August 31, 2008
    Posting from DynamicAccounting.net http://msdynamicsgp.blogspot.com/2008/08/support-debugging-tool.html

  • Anonymous
    September 02, 2008
    Fantastic news for the all the partner consultants and developers in the Dynamics GP community. The Support

  • Anonymous
    September 03, 2008
    David, this is most awaited tool. Thanks for bringing to notice.

  • Anonymous
    October 12, 2008
    I have been involved in the Great Plains world now since 1994. During that time I have become known for

  • Anonymous
    October 21, 2008
    Sorry, this is late notice, but I thought I would let you know that I am presenting a free Live Meeting

  • Anonymous
    October 28, 2008
    Sorry, I posted this too late for most people. I thought I would let you know that I presented a free

  • Anonymous
    November 05, 2008
    You might say that I am biased. As the developer of the Support Debugging Tool for Microsoft Dynamics

  • Anonymous
    November 09, 2008
    With the change from the optimistic user and class based security model in Microsoft Dynamics GP v9.0

  • Anonymous
    November 09, 2008
    For the next couple of weeks, I have decided to focus on Microsoft Dynamics GP application level security and methods for resolving security related issues.

  • Anonymous
    November 13, 2008
    From the Microsoft Dynamics GP Application Level Security Series . In the previous post, How to identify

  • Anonymous
    November 13, 2008
    From the Microsoft Dynamics GP Application Level Security Series . In the previous post, How to identify

  • Anonymous
    November 16, 2008
    From the Microsoft Dynamics GP Application Level Security Series . Microsoft Dynamics GP version 10.0

  • Anonymous
    November 16, 2008
    From the Microsoft Dynamics GP Application Level Security Series . When logging into Microsoft Dynamics

  • Anonymous
    November 18, 2008
    From the Microsoft Dynamics GP Application Level Security Series . When access is denied by the application

  • Anonymous
    November 19, 2008
    From the Microsoft Dynamics GP Application Level Security Series . When logging into Microsoft Dynamics

  • Anonymous
    November 19, 2008
    From the Microsoft Dynamics GP Application Level Security Series . When access is denied by the application

  • Anonymous
    November 27, 2008
    Alright, I admit it, this is one of my favorite subjects. I am currently working on the next build of

  • Anonymous
    December 18, 2008
    Some of you might know that I have been busy working on the next build of the Support Debugging Tool

  • Anonymous
    December 22, 2008
    By David Musgrave Some of you might know that I have been busy working on the next build of the Support

  • Anonymous
    December 23, 2008
    The Support Debugging Tool for Dynamics GP 10 has been released by Dave Musgrave. Below is a list of

  • Anonymous
    January 20, 2009
    One of the great things about Dexterity is that you can develop complex customisations without needing

  • Anonymous
    January 22, 2009
    Over the years, I have been asked many times how to call a Report Writer report to make it behave the

  • Anonymous
    January 25, 2009
    Many times on the newsgroups, I see questions from developers new to Microsoft Dynamics GP along the

  • Anonymous
    March 03, 2009
    As a developer there are often times when I need to write and maintain code which works for multiple

  • Anonymous
    April 15, 2009
    Dexterity has a long development history, dating back to the late 1980's. There were many people involved

  • Anonymous
    April 15, 2009
    Posting from Jivtesh Singh http://www.jivtesh.com/2009/04/dummys-guide-to-capturing-log-files.html

  • Anonymous
    April 29, 2009
    There have been a number of great articles posted on various Microsoft Dynamics GP Blogs in the last

  • Anonymous
    May 10, 2009
    The Support Debugging Tool for Microsoft Dynamics GP has the ability to create triggers against Functions

  • Anonymous
    May 11, 2009
    The Support Debugging Tool for Microsoft Dynamics GP has the ability to create triggers against Functions

  • Anonymous
    June 01, 2009
    Posting from the Dynamics GP Blogster http://dynamicsgpblogster.blogspot.com/2009/05/moving-data-between-microsoft-dynamics.html

  • Anonymous
    June 01, 2009
    A while back, there were several posts in the public Dynamics GP newsgroup about that HR & Payroll

  • Anonymous
    June 04, 2009
    The comment has been removed

  • Anonymous
    June 04, 2009
    This is one of my favourite examples mainly because it achieves something that most people thought was

  • Anonymous
    June 04, 2009
    I did not start this thread, but I thought I would give a bit of insight into the subject. Vaidy Mohan

  • Anonymous
    June 07, 2009
    The Support Debugging Tool for Microsoft Dynamics GP has the facility to create non-logging triggers

  • Anonymous
    June 09, 2009
    A new feature to the Support Debugging Tool for Microsoft Dynamics GP build 11 is the support for the

  • Anonymous
    June 16, 2009
    There is an issue with the Shift+F11 keyboard shortcut which is used by Visual Basic for Applications

  • Anonymous
    July 17, 2009
    Awesome Tool!  This would be valuable to have available to install on all client systems! Couple of suggestions for consideration in a future release: (1) The ability to have a client export a table to XML is amazing.  But instead of importing over the top of data on my side, it would be awesome if we had easy access to either an XML viewer or could create and delete a temporary SQL table to house the data. (2) Maybe consider expanding the options in the DEX.INI file and then store the settings in a shared location.  For example, the suppression of the print dialog, or my most recent pain -- the location of the OLEPATH (we just had to change 30 client machines because there is an outstanding issue where a UNC path suppresses the ability to attach documents).

  • Anonymous
    October 19, 2009
    This tool can be used by customers?

  • Anonymous
    October 19, 2009
    Carlos, Yes - however the download is only on partnersource.  So in order to get the app, you'd have to contact your partner for them to acquire it for you.

  • Anonymous
    July 25, 2010
    Posting from Victoria Yudin victoriayudin.com/.../new-resource-to-find-dynamics-gp-table-and-field-information

  • Anonymous
    July 25, 2010
    Posting from Vaidy Mohan at Dynamics GP - Learn & Discuss www.vaidy-dyngp.com/.../new-resource-to-find-tables-fields.html

  • Anonymous
    April 20, 2011
    Posting from Terry Blaser at Dynamics GP Support and Services Blog blogs.msdn.com/.../administering-gp-security.aspx