StrataFrame Forum / StrataFrame Database Deployment Toolkit / Enhancement Requests / DDT Deployment - Error - Enhancement / Latest Posts

RE: DDT Deployment - Error - Enhancement

Ben Chase — Mon, 03 Dec 2007 08:36:12 GMT

When we encounter an error, we generally just list off the details of the exception, and the SqlException object doesn't tell us the name of the stored procedure. But, we do have the name of the stored procedure within the loop we are deploying from, so it would be possible to wrap the SqlException in an exception that contains the name of the stored procedure.

RE: DDT Deployment - Error - Enhancement

Bastian Töpfer — Thu, 29 Nov 2007 03:56:03 GMT

Hi Trent,

thanks for your reply. I checked the Log File and it does not show the name of the proc their either.

RE: DDT Deployment - Error - Enhancement

Trent L. Taylor — Wed, 28 Nov 2007 12:07:33 GMT

Bastian,

Does it not appear in the deployment log file? There is a more detailed log of the error and you can generally determine where it failed by looking at the log. The log file will be named the same as the package file with a Results.log after it:

MyPackageFile_Results.log

I agree that you can never have enough information when trying to work through a problem so adding as much information to the log file as we can is always a good idea. I will look into the log file and see if we can add any more information that is currently being omitted.

DDT Deployment - Error - Enhancement

Bastian Töpfer — Wed, 28 Nov 2007 09:57:18 GMT

Hi,

one of the things I have been quite annoyed over the time is the fact that the DDT does not tell me which procedure was involved when there was an error during the deployment of a stored procedure.

I can then only guess by the Sql Exception.

It would be great, if you could include that information in the "Deployment Progress" window.

Thanks a lot