Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2011-04-22 : 08:30:24
|
| I have a scheduled job which calls an SSIS package.This job worked yesterday. Upon arrival this morning, the job is failing with "Processing was cancelled due to an interrupt. SQLSTATE=57014"."I am not aware of anything changing relating to the package.I should say that I can run the package directly from within Integration Services. It only fails when called from the SQL job. Below, is the complete error message.MessageExecuted as user: NT AUTHORITY\NETWORK SERVICE. ...00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:18:47 AM Error: 2011-04-22 08:19:31.90 Code: 0xC0047062 Source: XXX (XXX Task) DataReader Source [4070] Description: System.Data.OleDb.OleDbException: [DB2] SQL0952N Processing was cancelled due to an interrupt. SQLSTATE=57014 at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbDataReader.GetRowHandles() at System.Data.OleDb.OleDbDataReader.ReadRowset() at System.Data.OleDb.OleDbDataReader.Read() at System.Data.OleDb.OleDbDataReader.HasRowsRead() at System.Data.OleDb.OleDbDataReader.NextResult() at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.System.Data.IDbCom... The package execution fa... The step failed. |
|
|
qman
Constraint Violating Yak Guru
442 Posts |
Posted - 2011-04-22 : 09:06:56
|
| Weird, I recreated the step in the job and it now works.... |
 |
|
|
|
|
|
Package Fails when called from SQL Job