This issue has been solved.

Transaction Process ID was deadlocked on lock resources

Created: 04 Jul 2011 • Updated: 13 Jul 2011
Login to vote
0 0 Votes

I am having issued deleting stale computers from our Deployment Solution.  I am able to to delete one or two computers then I get an error message stating the following:  Transaction (Process ID XX) was deadlocked on lock resources with another process and has veen chosen as the deadlock victim.  Rerun the transaction.  I am fairly new to the DS and SQL.  What can I do to solve this issue.

Quick Look Solution

Deadlock Victim

The issue of not able to delete stale computer objects because those stale objects had pending jobs attached to the object.  Once I killed the pending jobs, then I was successfully able to delete the computers.

Filed Under

Comments

luke.s's picture
luke.s
Partner
Accredited
Certified
05
Jul
2011

Hi Randye, Witch version is

Hi Randye,

Witch version is your Deployment Server? Are the DS and SQL in the same server?

Regards,

If the suggestion has helped to solve your problem, please mark the post as a solution.

Fábio Sanches
IT Technical Manager | WTR Services | www.wtrservices.com.br

05
Jul
2011

Hi Fabio, DS is version 6.9

Hi Fabio,

DS is version 6.9 and yes, the SQL is on the same server.

Randy

11
Jul
2011
SOLUTION

Deadlock Victim

The issue of not able to delete stale computer objects because those stale objects had pending jobs attached to the object.  Once I killed the pending jobs, then I was successfully able to delete the computers.