Video Screencast Help

Transaction Process ID was deadlocked on lock resources

Created: 04 Jul 2011 • Updated: 13 Jul 2011 | 3 comments
This issue has been solved. See solution.

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.

Comments 3 CommentsJump to latest comment

luke.s's picture

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

randye's picture

Hi Fabio,

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

Randy

randye's picture

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.

SOLUTION