Skip to main content

[Common] Generating SST (fka DSP) Debug Logs

Ben Bauer
  • Updated

NOTE:  This article is listed in the following 'checklist' guides: [Integrate] Errors while Recording, Posting, or Importing

 

This article contains the following sections:

 

Preparing a Debug Log

 

Debug logs are often very helpful in troubleshooting issues in the following SST (fka DSP) applications: Collect, Common, Mass Maintenance (fka dspCompose), Master Data Management (fka dspConduct), Entity Validation, Integrate, & Promote.

DebugLogConfigNew.png

  1. From the SST site, go to Common > Job Monitor > Debug Logs
  2. Select the Component for the application you wish to monitor and click the 'Clear Debug Log' button at the top of the page
    • NOTE:  the 'Clear Debug Log' button may be grayed out if the log is already empty
  3. Click the 'Edit' button and set the [TRACE LEVEL] to "1 - Debug"
    • In the 7.4.7 release of SST, a [LOGGING INTERVAL] feature was added. This value must be set to at least 1, which is a setting that will turn off the Debug Log after 1 hour. This feature was added to protect the system from the additional processing overhead caused by Debug Logs.
    • WARNING: This adds processing overhead and should be set back to "0 - Disabled" after you have your debug log populated.

 

Return to top

 

Populating a Debug Log

 

Debug logs are populated with records any time an action is performed within a Component that is not set to "0 - Disabled".  Best practice is to perform the activity that you wish to analyze two or more times. This makes it easier to identify the group of records associated with your activity, especially if there are other activities being performed at the same time.

There is a separate debug log table for each of these Components of the SST (fka DSP):

  • Collect - DataGarage.dbo.ttDebugLog
  • Common - DSPCommon.dbo.ttDebugLog
  • Mass Maintenance (fka dspCompose) - cMass.dbo.ttDebugLog
  • Master Data Management (fka dspConduct) - DGE.dbo.ttDebugLog
  • Entity Validation - EntityVal.dbo.ttDebugLog
  • Integrate - Integrate.dbo.ttDebugLog
  • Promote - sstTransport.dbo.ttDebugLog
  • Track - dspTrack.dbo.ttDebugLog

 

Return to top

 

Exporting a Debug Log

 

  1. Open up SQL Server Management Studio and connect to your SQL Server
  2. Click the 'New Query' button in the top-left
  3. SELECT * FROM the appropriate ttDebugLog (they are listed in the previous section)
  4. Copy the result set and paste it into an Excel spreadsheet
    • The easiest way is to right-click on the square in the top-left of the result set and select options from there

WARNING: Check that you set the Trace Level of the Component back to "0 - Disabled" when you are done populating the debug log, so you don't add processing overhead to the application. If you're using the [LOGGING INTERVAL] feature in SST 7.4.7 and later, then you may ignore this warning.

 

Return to top

 

Related articles