Support Debugging Tool Portal
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (https://winthropdc.com/GPPT)
This is the portal page for the Support Debugging Tool for Microsoft Dynamics GP. Find this page using the shortened URL: https://aka.ms/SDT
For GP 2010 (v11.0) & GP 2013 (v12.0): Current release is Build 19 (Last Modified: 06-Sep-2014).
For v10.0: Final release is Build 19 (Last Modified: 06-Sep-2014).
For v9.0: Final release is Build 14 (Last Modified: 25-Nov-2010).
For v8.0: Final release is Build 12 (Last Modified: 09-Mar-2010).
Overview
The Support Debugging Tool is a free 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.
The tool currently contains two modes of operation; Standard Mode and Advanced Mode. Advanced Mode features require system administrator or database owner (dbo) privileges and require expertise in Dexterity and/or SQL Server administration.
Standard Mode includes the following features; Manual Logging Mode, Individual Logging Mode, Dex.ini Settings, Resource Information, Security Profiler, Security Information, Configuration Export/Import , ScreenShot and Send Email.
Advanced Mode features include; Automatic Debugger Mode, Dictionary Control, XML Table Export, XML Table Import, Runtime Execute, SQL Execute, Configuration Maintenance, Administrator Settings and Dex.ini Configuration.
Release Announcements
Below are the links for the various release announcement blog posts, please review these posts to see the features added and fixes made for each build:
30-Jul-2008: Support Debugging Tool for Microsoft Dynamics GP
03-Sep-2008: Support Debugging Tool - The wait is over
18-Dec-2008: Support Debugging Tool Build 10 released
05-Jun-2009: Support Debugging Tool Build 11 released
17-Feb-2010: Support Debugging Tool Build 12 released
01-Mar-2010: Support Debugging Tool for Microsoft Dynamics GP 2010 Beta
10-Mar-2010: Update to Support Debugging Tool For Build 12
13-May-2010: Support Debugging Tool Build 13 released
02-Dec-2010: Support Debugging Tool Build 14 released
30-Jun-2011: Support Debugging Tool Build 15 released
26-Jul-2011: Support Debugging Tool Build 15 update released
06-Jan-2012: Support Debugging Tool Build 16 released
13-Jul-2012: Support Debugging Tool Build 16 Hotfix released
21-Dec-2012: Support Debugging Tool Build 17 released
25-Jan-2013: Support Debugging Tool Build 17 hotfix released
12-Apr-2013: Support Debugging Tool Build 17 hotfix 2 released
26-Feb-2014: Support Debugging Tool Build 18 released
05-Jun-2014: Support Debugging Tool Build 18 hotfix released
19-Sep-2014: Support Debugging Tool Build 19 released
Support Debugging Tool Feedback Survey
The Support Debugging Tool now has a Feedback Survey so we can obtain some real data on the number of users, what features they use and their satisfaction with the tool. This information will help justify the continued development of the tool. Please show your support and respond to the survey:
Frequently Asked Questions
These blog posts provide lots of additional information (including an extensive FAQ list) for the Support Debugging Tool:
- Installing the Support Debugging Tool for Microsoft Dynamics GP FAQ
- Common Support Debugging Tool Myths - Fact or Fiction?
- The Creation of the Support Debugging Tool
- 21 Reasons why every workstation should have the Support Debugging Tool installed
- How to configure SQL Profile Tracing using the Support Debugging Tool
- Understanding the Support Debugging Tool Series
Conference Session Materials
Below are the links to download the session materials (newest at the top), which including step by step installation instructions:
Convergence 2012: CSGP19 Administering Microsoft Dynamics GP Like a Pro with the Support Debugging Tool (6.72MB)
Convergence 2012: CSGP23 Advanced Microsoft Dynamics GP Administration with the Support Debugging Tool (6.72MB)
Convergence 2012: The Support Debugging Tool Training Workbook (2.74MB)
Convergence 2011: CSGP14 - Administering Microsoft Dynamics GP like a Pro with the Support Debugging Tool (10.7MB)
Tech Conference 2011: Development Troubleshooting with the Support Debugging Tool (5.33MB)
Convergence 2010: CSGP29 - Tools for Administering Microsoft Dynamics GP like the Pros (7.12MB)
Tech Conference 2009: Troubleshooting your Developed Solution (13.4MB)
Conference Videos
Below are the links to watch the videos from the conferences. (You might need a valid password to open these links.):
Convergence 2011: CSGP14-R1: Administering Microsoft Dynamics GP Like a Pro with the Support Debugging Tool
Convergence 2010: CSGP29 - Tools for Administering Microsoft Dynamics GP like the Pros
Downloads
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (https://winthropdc.com/GPPT)
Other Articles and Posts
For other related articles and posts have a look at the Support Debugging Tool Tag page.
The Support Debugging Tool also has its own Twitter Hash Tag: #MSDYNGPSDT.
Comments and Feedback
Please provide comments, feedback and suggestions for the Support Debugging Tool to help us understand how you use the tool and how we can improve it.
04-May-2010: Added Convergence Atlanta 2010 Materials download link.
13-May-2010: Updated for Support Debugging Tool build 13 release.
02-Dec-2010: Updated for Support Debugging Tool build 14 release.
30-Mar-2011: Updated runtime update links and added new conference session materials download links.
18-Apr-2011: Updated page with Convergence 2011 related links.
20-Apr-2011: Added Link to Common Support Debugging Tool Myths - Fact or Fiction? post.
30-Jun-2011: Updated for Support Debugging Tool build 15 release.
26-Jul-2011: Updated for Support Debugging Tool build 15 update release.
05-Sep-2011: Added links from recent Support Debugging Tool posts.
08-Oct-2011: Adjusted page to show unsupported versions.
06-Jan-2012: Updated for Support Debugging Tool build 16 release.
16-Jan-2012: Added link to How to configure SQL Profile Tracing using the Support Debugging Tool post.
19-Jan-2012: Added Details of Support Debugging Tool Twitter Hash Tag: #MSDYNGPSDT.
30-Mar-2012: Added Convergence 2012 Session Materials links.
26-Jun-2012: Added link to Understanding the Support Debugging Tool Series.
13-Jul-2012: Updated for Support Debugging Tool build 16 hotfix release.
21-Dec-2012: Updated for Support Debugging Tool build 17 release.
25-Jan-2013: Updated for Support Debugging Tool build 17 hotfix release.
12-Apr-2013: Updated for Support Debugging Tool build 17 hotfix 2 release.
16-Jan-2014: Updated links for New PartnerSource.
28-Jan-2014: Updated links for New CustomerSource.
26-Feb-2014: Updated for Support Debugging Tool build 18 release.
05-Jun-2014: Updated for Support Debugging Tool build 18 hotfix release.
31-Jul-2014: Updated Direct Links to new File Exchange links.
19-Sep-2014: Updated for Support Debugging Tool Build 19 release.
22-Mar-2015: Updated with links to Winthrop Development Consultants.
Comments
Anonymous
March 04, 2010
Posting from DynamicAccounting.net http://msdynamicsgp.blogspot.com/2010/03/support-debugging-tool-portal.htmlAnonymous
March 07, 2010
The comment has been removedAnonymous
April 27, 2010
Posting from Andy Nifong http://andynifong.com/archive/2010/04/dynamics-gp-support-debugging-tool/Anonymous
April 27, 2010
Dave: I got the PowerPoint slides from the Support Debugging Tool session. The session you and Mariano presented was great! I am in the process of installing it. I had a problem occur while I was gone. Thanks again for all the information. Brenda HaynesAnonymous
April 28, 2010
I've sent a request to my Dynamics GP Partner for the V10 version of the supreme ultra debbuging tool. Again thanks for the conferences, thanks for the great tools and thanks for giving me the chance to meet you guys in person! P.S. Nice picture with Bono! Jason (the spiky dark haired geek that asked for you and Mariano's autographs!)Anonymous
April 28, 2010
Dave, Thanks for a great session! Mariano and you did great. It was great finally meeting you in person. Hope your LONG trip back to Perth went well. I am waiting on my partner to receive the Support Debugging Tool. I have an open case with Dynamics GP Support, and I think we may finally figure out what the issues are using the fantastic tool you've created. Thanks again, Bryan SampsonAnonymous
April 30, 2010
Would it be possible to have an upgrade portal for the latest release of SDT so current end users could retrieve the latest version without having to bug their reseller for it? I understand the reasoning for getting SDT through your partner the first time, but it would be nice to have an easy way to get updates. I have v11 but want to install v12 for all my GP users as suggested in your Convergence session. Thanks, DavidF.Anonymous
May 03, 2010
My partner downloaded the tool for me and I am in the process of setting it up, but it is a little harder than it seemed in the presentation. trying to follow the manual... but I guess I'll have to wait for the virtualization of your session so I can connect what I saw to the actual tool.Anonymous
May 03, 2010
Karlie, Everything seems easy in a quick demo - if you've been doing it for yours (or are the person that wrote it). I'm not sure what you mean by "virtualization of your session" however David has links to the session materials on todays post.Anonymous
May 03, 2010
Hi Karlie The session materials on http://blogs.msdn.com/developingfordynamicsgp/archive/2010/05/03/microsoft-dynamics-convergence-atlanta-2010-wrap-up.aspx have the step by step instructions with screenshots for the recommended installation configuration. DavidAnonymous
May 06, 2010
Ever see the error "An open operation on table 'MBS_ScreenShot_Forms' has caused an unknown error (46)" We have had issues with error 46's on a 'IV_cost_Variance_TEMP' table before we downloaded the Support debugging tool and now I get both error 46's one right after the other.Anonymous
May 06, 2010
Hi Jenelle Please see the following posts on how to clean up your local temp folder which is where the temporary tables are being stored. http://blogs.msdn.com/developingfordynamicsgp/archive/2009/08/10/an-open-operation-on-table-temp-table-errors.aspx http://blogs.msdn.com/developingfordynamicsgp/archive/2010/04/21/unexplained-temp-table-errors.aspx This issue is not related to the Support Debugging Tool, but to the use of temporary tables. DavidAnonymous
July 29, 2010
Posting from Mark Polino at DynamicAccounting.net msdynamicsgp.blogspot.com/.../finding-tables-in-dynamics-gp.htmlAnonymous
September 12, 2010
Posting by Mark Polino of DynamicAccounting.net msdynamicsgp.blogspot.com/.../gp-partner-connections-conference.htmlAnonymous
December 06, 2010
The comment has been removedAnonymous
December 16, 2010
Post from Mark Polino at DynamicAccounting.net msdynamicsgp.blogspot.com/.../using-debugger-setup-mode-with-support.htmlAnonymous
February 14, 2011
Posting from Mark Polino at DynamicAccounting.net msdynamicsgp.blogspot.com/.../in-touch-with-dynamics-gp-new-support.htmlAnonymous
February 14, 2011
Posting from Mariano Gomez, The Dynamics GP Blogster: dynamicsgpblogster.blogspot.com/.../changing-and-copying-home-page-role_18.htmlAnonymous
March 16, 2011
How can I get support and ask questions about the color changing part of this tool? It works great on a terminal server, but not on any of the workstations at a company.Anonymous
March 16, 2011
The download pages on PartnerSource and this blog page mention using the forums to obtain support for the Support Debugging Tool. Based on your description, I would say that you are not using a shared debugger,xml setup file as described at the start if the debugger.pdf user guide. This means that each workstation will need the company colors turned on individually.... not the desired approach. Please set up a shared location and make it Administrator controlled (as per the user guide), this will then automatically change all workstations with the SDT installed to use the shared location, which should activate the company colors for all workstations with the SDT installed. DavidAnonymous
April 20, 2011
Posting from Terry Blaser at Dynamics GP Support and Services Blog blogs.msdn.com/.../administering-gp-security.aspxAnonymous
April 22, 2011
Posting from Terry Blaser at Dynamics GP Support and Services Blog blogs.msdn.com/.../how-to-move-your-security-settings-from-test-into-production.aspxAnonymous
May 15, 2011
In your session you showed many new features from build 15. You also stated that build 15 would be released shortly after your return home. Any news on the release date? Thanks for all that you do. EricAnonymous
May 15, 2011
Hi Eric Build 15 is still being worked on. The Release Candidate code is completed, but I am yet to complete updating the user guide manual to match the 60 plus changes made in the code. Working on it. DavidAnonymous
May 30, 2011
Posting from Mark Polino at DynamicAccounting.net msdynamicsgp.blogspot.com/.../friday-fun-practical-jokes-you-can-play.htmlAnonymous
July 26, 2011
Posting from Mark Polino at DynamicAccounting.net msdynamicsgp.blogspot.com/.../weekly-dynamic-troubleshooting-security.htmlAnonymous
September 30, 2011
David, I ran into an issue with build 17. In previous builds when one enables color coding in the company, settings would be stored in SY90000 table in the company DB. With build 17, I do not see this anymore in SY90000. Do you know why? Where is it stored now?Anonymous
October 02, 2011
Hi Andrei I assume you mean build 15 as we have no build 17. Build 16 is currently being worked on. The change you are talking about is shown in the debugger.txt file in change log for build 14. "Shift Company Color data storage from DUOS to coUserDefaults table, with automatic backwards compatibility." The change was made because using the DUOS did not work all the time. When switching companies, the colors were being set BEFORE the DUOS was changed to point to the new table in the new company. This meant that the colors shown were not correct. They are now stored in the coUserDefaults (SY01401 ) table: select * from SY01401 where USERID = ' DEBUGGER' Note: there is a space before DEBUGGER which ensures that the data will never clash... even if you have a user called DEBUGGER. DavidAnonymous
November 09, 2011
David ... I am performing an upgrade from GP 10 to GP 2010 and they have Support Debugging Tool installed on the one GP client. Does Support Debugger Tool upgrade? DenniAnonymous
November 10, 2011
Hi Denni You would need to download the GP 2010 Support Debugging Tool and install that over the top. If you don't, you will get a warning message that the version of the tool does not match your system. To get the best from the tool, it should be installed on ALL workstations with a centralized setup folder as per the FAQ and recommended installation instructions in the User Guide manual. DavidAnonymous
February 02, 2012
Hi David , I am a big fan of your tool and thanks for all the hard work. I ran onto a recent problem though when i tried to install it (v11 at the time) on 2010 SP2 it said it was the wrong version and refused to install. I today just downloaded V16 and am getting the same error message. Any ideas? I really love and miss your tool so any help would be greatly appreciated.Anonymous
February 02, 2012
Hi Matthew Delete the Debugger.DIC file and then install the GP 2010 Debugger.CNK. Launch Dynamics GP using Run as Administrator. The chunk file should then extract correctly. DavidAnonymous
February 08, 2012
Are users will be accessing the GP application from their desktops through Citrix so they will not have client versions on their PCs. In this setup, where would SDT be installed?Anonymous
February 08, 2012
It should be installed wherever Dynamics is - the SDT isn't any different in that regards to any other Dexterity based solution.Anonymous
April 16, 2012
Posting by Adam MacIntosh from Websan Solutions www.websan.com/.../microsoft-dynamics-support-debugging-toolAnonymous
May 16, 2012
Posting from Vaidy Mohan at Dynamics GP - Learn & Discuss vaidymohan.com/.../adding-customer-item-user-defined-fields-to-sop-invoice-marianoAnonymous
December 06, 2012
Posting from Mariano Gomez, The Dynamics GP Blogster dynamicsgpblogster.blogspot.com/.../resizing-smartlist-panes-with-support.htmlAnonymous
February 18, 2013
Posting from Mark Polino at DynamicAccounting.net msdynamicsgp.blogspot.com/.../viewing-your-gp-security-in-smartlist.htmlAnonymous
March 21, 2013
Hi, First, thanks for the Support Debugging Tool. It's very helpful indeed. One of the comments related to the tool that I've seen in a number of places relates to its ability to remove "winspool" references from the Dex.ini file; it's even noted in the Debugger.pdf file. Are you able to elaborate as to why those winspool lines are written to the Dex.ini in the first place? And, related to that, is there currently a way to suppress those entries from being written to the file? If not, could that suppression ability be considered for a future release of the SDT, assuming it's not a stupid amount of work? Thanks, jcAnonymous
March 24, 2013
Hi John The Dex.ini settings store the last used settings for each printer. These settings can be seen and altered if you remove the following Dex.ini setting NoPrintDialogs=TRUE Most users hide this extra dialog (either via Named Printers or manually changing the Dex.ini) and so the winspool settings are usually just the default values. As it is the Dexterity runtime creating the Dex.ini settings this is not something that can be stopped by the Support Debugging Tool. The best we can do is use the Dex.ini Configuration window to "clean up" the settings after login. DavidAnonymous
April 18, 2013
Posting from Vaidy Mohan at Dynamics GP - Learn & Discuss vaidymohan.com/.../refresh-application-navigation-support-debugging-tool-sdtAnonymous
May 12, 2013
Posting by Belinda Allen saci.com/.../Microsoft-Dynamics-GP-Change-your-ColorsAnonymous
July 21, 2013
Posting from Sheldon Gitzel from Etelligent Solutions Inc. www.esicanada.com/.../dynamics-gp-2013-upgrade-are-you-still-using-converted-security-roles-in-your-gp-securityAnonymous
July 21, 2013
Posting from Sheldon Gitzel from Etelligent Solutions Inc. www.esicanada.com/.../dynamics-gp-2013-faq-how-to-modify-a-security-roleAnonymous
August 26, 2013
Posting from Sheldon Gitzel at Etelligent Solutions www.esicanada.com/.../options-for-handling-multiple-companies-in-dynamics-gpAnonymous
October 21, 2013
I posted this at GPUG, but this might be a good fit for your tool if it could be done. I have seen some creative coders stretch and fix the behavior of the SmartList window in GP 2010. Now I have a challenge for anyone to do the same for the GP logon window. Or give me some ideas to get me started myself. It might be a good fix for the Support Debugger Tool, maybe? We have some fairly long names for our GP companies. Well, when logging onto GP, the second "Company Login" screen cuts off the company names too short for us. The entry field for companies allow for longer strings (65 Characters) but only displays 31 characters on the pull-down list. There is plenty of real estate on this window going unused. Can anyone think of a way to enhance/fix this to display more of the company name?
Company: 1234567890123456789012345678901 o Remember this company Server: User ID: xxxxxxxxx Current Users: ## Users Allowed: ##
Anonymous
January 12, 2014
Hi David, It appears that with the update of Partnersource/CustomerSource, the links to the Support Debugging page is broken. Thanks, WilliamAnonymous
January 13, 2014
Hi William The Direct Link hyperlinks to the download files still works. I am following up internally to see what has happened to the pages in PartnerSource. [Edit]: The portal has been updated with the new links for PartnerSource. Thanks DavidAnonymous
April 02, 2014
Posting from Mark Polino at DynamicAccounting.net mpolino.com/.../weekly-dynamic-smartlistAnonymous
May 12, 2014
Hi David, I just installed the latest build 18 on my GP 2013 VM that I used for my sessions @ the GPUG Summit last year in Largo, but realized soon after it replaced my b17, that the title shortcut [sa/TWO] that you can enable in the administrative settings doesn't show up anymore on the main GP window in the title bar... was that on purpose or missing in the last build ? The other thing I haven't fixed yet on my GP2010 Test bed system are those weird location coordinates for the main SDT screen which saves numbers like 31773,31883 and therefore throws the screen completely off my display and I can't open the SDT main panel anymore without closing GP, opening the DEX.ini and resetting those 'impossible' values to 0,0 ... Thanks in advance for your input. @GP_BeatAnonymous
May 12, 2014
Hi Beat The placing of the Company ID and User ID into the application title bar and window titles still works for build 18 of the Support Debugging Tool. As for the weird positioning of the SDT window, it works by looking at the desktop resolution and subtracting the window size so that the window appears in the bottom right corner. It does this behaviour on the first time the window is opened. It can tell it is the first time as the co-ordinates are 0,0. I suggest if you reset the window position via the dex.ini, do not set it back to 0,0. Also what are the video settings for your desktop that the Windows API calls appear to be returning values of 32768 for both height and width. DavidAnonymous
May 13, 2014
Thanks David, As for the Company ID & User ID in the title bar, it is somehow strange, because it works with some clients, and not with others... could this have something to do the order in which the various modules are loaded when the GP client starts ? I'm not sure, but this will need some investigation.. I'll send you some screen captures by e-mail as a proof. As for the screen resolution, I'm still puzzled, because it's not even on my desktop with my dual-display configuration, but with a remote desktop / remote control session that this happens on my server.. that's why this is so weird. This is windows 2008 R2 STD server.. and the screen res is 1152x864... very standard. I'd understand if this would happen on my laptop, which is sometimes docked and sometimes uses the internal display... but not on my server.. :-) Beat PS: the strange coordinate are even more bizarre since they don't fit with any usual binary multiple number..Anonymous
May 13, 2014
OK David, The mystery of the missing Company ID & User ID in the title bar is no longer a mystery... I realized that the 2 actually show up briefly during the logon process, but then get replaced by the full company name once the Rockton Software Toolbox has finished to load in GP... :-( and there is a default settings in the RSTB system parameters that says : "Company in Title Bar" ... how good is that :-) ? Now remains the issue with the mysterious screen coordinates that affects the SDT only... nothing else.Anonymous
May 13, 2014
Hi Beat When the main SDT window opens, If there is already a valid position stored in the Dex.ini, it will use that position. Otherwise, it reads the desktop size from a windows API. It then subtracts the size of the SDT window from desktop size, so it can open in the bottom right corner. It then looks at the main application window's position on the desktop and calculates the relative values it needs to open in the bottom right corner. I believe that you are getting something 32000, 32000 returned as your desktop size and then the SDT opens the window in the incorrect position. Use the trick in the following blog article to move the window to a good location blogs.msdn.com/.../where-has-my-microsoft-dynamics-gp-window-gone.aspx It should then save the good location and re-use that. You can also use Dex.ini Configuration to reset the window position on login if needed. DavidAnonymous
November 12, 2014
I somehow set the Debugging Tool window to automatically pop-up when users log on. I cannot find where to turn it off. I haven't set any triggers. Can you guide me, we are on version 10.00.0012Anonymous
November 13, 2014
Hi Martin Please upgrade to the latest build for your version, build 12 is very old now. The option is under Dex.ini Settings on the bottom half of the first tab. DavidAnonymous
December 26, 2014
Will Support Debugger be available for GP 2015?Anonymous
January 19, 2015
When will Support Debugging Tool be available for GP 2015?Anonymous
March 10, 2015
For all those worrying about the future of SDT, read on the news about 2015 on David's other blog : winthropdc.wordpress.com/.../update-where-is-the-support-debugging-tool-for-microsoft-dynamics-gp-2015