SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


No error description after job failure


No error description after job failure

Author
Message
Andy Dale
Andy Dale
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 52
Hi,

I am having a scheduled job running DTS packages on my production environment.
My production server server is having Window 2003 Sp2 installed on it.

Before rebuilding the server I was getting more details error messages in case job failed
the error description is having more detailed error message.

for example:


Step 'DTSStep_DTSExecuteSQLTask_197' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Microsoft OLE DB Provider for SQL Server (80004005): Connection failure.
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100



Now I am getting error message like below:



Step 'DTSStep_DTSExecuteSQLTask_17' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The task reported failure on execution. ( (80004005): )
Step Error code: 8004043B
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

The same error message is there in Job History and DTS log.The error codes I am getting in the error messages are the generic ones which can
contain several errors.

I have checked everything and could not figure out any differences in the configuration before and after building the server.

Please can someone help me to find the out the reason why now I am not getting the detailed error description
and how to rectify this as without the actual errors it wil be difficult to investigate the reason for failure and
to convince the client.
Rao.V
Rao.V
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1082 Visits: 705
Any help appreciated...

We are facing same issue with DTS package.... the package runs fine manually but fails when scheduled through job giving the below mentioned error:

"
DTSRun: Loading...
DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_3
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_3 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220421 (8004043B)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 1100

Error Detail Records: Error: -2147220421 (8004043B);
Provider Error: 0 (0) Error string: The task reported failure on
execution. Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help context: 1100
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.
"

Have tried all options ... redeploying pkg,proxy settings, new job creations... noting helped....
Mark Taylor-212571
Mark Taylor-212571
SSC Veteran
SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)SSC Veteran (288 reputation)

Group: General Forum Members
Points: 288 Visits: 62
I have seen this error in the past. I have had jobs run for years without any issue then all of sudden it stopped working. Unfortunately I cannot find the Microsoft KB reference about it but, if you are running the DTS package under the SA in your job change it to the NT account that is running your services and ensure that the NT account has access to the folder where the data is stored. For a SHORT TERM fix (and I do not recommend it) you can also change the owner of the job to your own NT account or any other NT account that has access to the folder and has the correct level of Privileges to run the job.

Hope this helps, if not let me know.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search