Skip to main content

Error: Transaction (Process ID XXX) was deadlocked on lock resources with another process

Error: Transaction (Process ID XXX) was deadlocked on lock resources with another process.

H
Written by Harry Ledger
Updated over a month ago

This error occurs when the system is trying to perform two actions at the same time.

You will likely see this error message on an absence request in the workflow log.


If an absence request workflow has failed with this error, you will need to remove the pending absence and resubmit the request.

Prevent Deadlocks

If you are hosted by Access, please raise a new case online and reference the title of this article.
​
If you are on premise, to prevent deadlocks from reoccurring, please follow the steps below.
​
Please run the following script, replacing the database name with the SelectHR database name:
​
ALTER DATABASE [SelectHR] SET READ_COMMITTED_SNAPSHOT ON;
​
If this query hangs (please cancel it), then you will have to implement this manually.

Please follow the steps below:

  1. Right click on the SelectHR database.

  2. Click Properties.

  3. Select Options from the left window.

  4. Change the Is Read Committed Snapshot On setting to True.

  5. Click OK.

  6. Click Yes when it prompts you to close all connections to the database.

Did this answer your question?