January 19, 2006 at 12:29 pm
Hello friends..I need some help regarding error.....
I have DTS package scheduled to run...whenever job failed I am getting error when i checked in job history and found....
Executed as user: SCVSQLSRVR\SYSTEM. ...art: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_7 DTSRun OnError: DTSStep_DTSExecuteSQLTask_4, Error = -2147217873 (80040E2F) Error string: The statement has been terminated. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217873 (80040E2F); Provider Error: 3621 (E25) ... Process Exit Code 1. The step failed.
I also checked in EventViewer i got this error msg...
SQL Server Scheduled Job 'DTS_01_NewmpAdd-V2' (0x88A2B288A927FA4A844B9A82E949DA0A) - Status: Failed - Invoked on: 2006-01-19 12:01:00 - Message: The job failed. The Job was invoked by Schedule 120 (DTS_01_ NewmpAdd -V2). The last step to run was step 1 (DTS_01_ NewmpAdd -V2).
I am still vague @ exact error..can any body plz help me where i will get exact reason for failure.....
But when i ran this job after half hr later...it succeeded!!!!
Plz help me out.......
Regards,
Papillon
January 19, 2006 at 12:46 pm
Hello Papillon
go thru this link
http://www.sqlservercentral.com/forums/messages.aspx?forumid=23&messageid=166060
Lucky
January 20, 2006 at 8:56 am
Papillon,
Enable logging for the DTS package if you haven't already. When the job fails, look at the package log to see the DTS error and the failed step by right-clicking on the package name in Local Packages and selecting Package Logs...
Greg
Greg
January 20, 2006 at 9:29 am
My, but this turned out to be an obscure one. Your error is Error: -2147217873 (80040E2F); These two numbers are the same, the first is base 10 the other HEX. The minus is due to the high order bytes being FFFF. I have found that having a C programming backround has helped me to debug Microsoft problems. OLEDB is a COM object, and in this case using the SQL Server provider. When instantiating and COINITIIALIZING COM objects, your program is given feed backback via these COM return codes. I have the MS Visual Studio installed on my PC. Scanning files for 80040E2F brought me to file oleDBerr.h. Value violated the integrity constraints for a column or table. Not excesively helpful. The violation could have been on the system table, if two jobs are initiated at the same time, or it could be on a user table. One thing I find helpful is when I turn the DTS package into a job; their is an Advanced tab on the Job Step that allow me to specify a log file name. The message in this file are better.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply