Welcome to MSDN Blogs Sign in | Join | Help
How to Debug the Data Warehouse

Some of you might wonder, how do I debug the Data  Warehouse Import Tasks?  There are two options:

  1. Perform a Sql Trace against the Data Warehouse database.
  2. Run the Data Warehouse debug server.  The debug server is a utility which allows you to see trace output from the OLE DB provider for Commerce Server. 
    1. To run the debug server, open the command prompt window and navigate to "C:\Program Files\Common Files\Microsoft Shared\Enterprise Servers\Commerce Server\" and execute: "CSDWDbgSrv.exe -f traceoutput".  This will create a text file name with "traceoutput" as a prefix and a time stamp as the suffix. 

Hope this helps!

-Alan

Posted: Wednesday, September 20, 2006 3:34 PM by akfaulkner

Comments

Leia said:

When should I run the debug server?  With the DTS task running?

Thanks,

Leia

# March 28, 2007 4:58 PM

akfaulkner said:

Yes, Start the debug server before executing the DTS tasks and stop the debug server after all the DTS tasks are complete.

Hope this helps.

Alan

# March 28, 2007 5:15 PM

Derrick Lau said:

Thanks!  This blog helped alot!

# May 30, 2008 3:59 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker