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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Dead lock error

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 message
Code: 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?
Go to Top of Page
   

- Advertisement -