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 |
|
sravanim
Yak Posting Veteran
58 Posts |
 Posted - 2013-03-26 : 10:36:36
|
| I have a scheduled job occurs for every 20 mins.it frequently fails showing below error messageCode: 0xC002F210 Source: EXEC uspLoadPharmTargetMOATable Execute SQL Task Description: Executing the query "EXEC [ETL].[uspLoadPharmTargetMOATable] ?, ?" failed with the following error: "Transaction (Process ID 285) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 6:20:00 AM Finished: 6:20:37 AM Elapsed: 36.707 seconds. The package execution failed. The step failed.Please suggest what to do for resolution? |
|
|
sravanim
Yak Posting Veteran
58 Posts |
Posted - 2013-03-26 : 11:13:40
|
| Job runs under a package which has a sequence container.In that some has precedence constraints and other's don't have.Because of this sequence container it leads to dead lock? |
 |
|
|
|
|
|
Dead lock error