Skip to main content

Error: 'Transaction process ID xx was Deadlocked on lock resources with another process'

Written by Charnjit Singh Dharival

Full error message when saving the plan or running the data import:-

An unexpected error occurred. Please report this problem to your system administrator with the following information:

System.Data.SqlClient.SqlException: Transaction (process ID xx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


The save plan and SFDC Publishing functionality has been optimised in Orchestrate version 7.80 and SFDC version 2.0.0. Please upgrade to these versions or above.

When there is a Deadlock, the system has two processes which are trying to access the same data at once. Only one will work, the other will fail.

Saving the plan again prevents this error from occurring. If the error generates again, please reboot the SQL server.

Running the following from SQL command on the database will pre-warn you if this error is going to occur again, by outputting any open transactions:

DBCC OPENTRAN
Did this answer your question?