SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Dead lock error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sravanim
Yak Posting Veteran

58 Posts

Posted - 03/26/2013 :  10:36:36  Show Profile  Reply with Quote
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 - 03/26/2013 :  11:13:40  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000