November 28, 2003 at 12:32 am
I’m a bit lost with this one.
I have a job that is fired off by a trigger.
The job fails every morning now and I can not seem to be able to find out why.
The job history shows:
The job failed. The Job was invoked by User MYDOMAIN\USER. The last step to run was step 1 (dts name).
The job steps shows:
Executed as user: MYDOMAIN\USER. ...DTSStep_DTSExecuteSQLTask_10 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_10 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_11 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_12 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_12 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_13 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_13 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_8 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_8 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_14 DTSRun OnFinish: DTSStep_DTSExecuteSQL... Process Exit Code 1. The step failed.
I then go to the DTS package and view the package logs. All of the steps are reported as successful for the same time as when the Job started it.
I then go to view the package logs of the second step in the Job. It never ran.
I manually execute the entire package and it is successful. I manually execute DTSStep_DTSExecuteSQLTask_14 and it’s also successful.
I have made sure that the job and DTS are executing on the same server.
Huh?
-----
I have added an output file to the job step and the following error is returned.
DTSRun OnError: DTSStep_DTSExecuteSQLTask_6, Error = -2147221499 (80040005)
Error string: Need to run the object to perform this operation
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error Detail Records:
Error: -2147221499 (80040005); Provider Error: 0 (0)
Error string: Need to run the object to perform this operation
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100
Error: -2147221499 (80040005); Provider Error: 0 (0)
Error string: Provider generated code execution exception: EXCEPTION_ACCESS_VIOLATION
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 5300
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6
DTSRun: Package execution complete.
----
If it aint broke don't fix it!
Edited by - jordanac on 11/28/2003 02:03:02 AM
Edited by - jordanac on 11/28/2003 03:05:07 AM
Andy.
November 28, 2003 at 4:55 am
Greetings,
I have managed to resolve this. An EXCEPTION_ACCESS_VIOLATION error led me to believe that this is a memory problem.
It occurs when a pointer is dereferenced and the pointer points to inaccessible memory or a write operation is attempted on read-only memory.
A good old fashioned bounce helped.
If it aint broke don't fix it!
Andy.
November 28, 2003 at 8:08 am
EXCEPTION_ACCESS_VIOLATION usually means corruption in either the OS or the App. if you reboot yourcomputer and it happens again on the SAME place you may file a BUG with MS if it is random then Hardware may be the strating point
* Noel
December 1, 2003 at 12:08 am
Hi,
Yes I agree. Its definitely the OS. This DTS run for a year and a half on another machine. Its been ok for 6 months on this server. Any ideas of how I could pin point the problem?
If it aint broke don't fix it!
Andy.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply