Description of Error:
After leaving the dispatch board idle for a while the following error occurs:
The following error occurred while attempting to load jobs:
Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Cause of Error:
This error is caused when one SQL Server attempts to access a resource that is already in use by another process.
Resolution:
Do nothing. Anytime there is a deadlock ESC automatically reruns the transaction it was attempting, thereby resolving the deadlock.
Additional Information:
These errors occur in SQL Server from time to time and are completely normal. Due to the automatic retry, there should be no negative consequences of these errors.
Comments
Please sign in to leave a comment.