Error Running Purchasing Report

[Turpentine]

I have a user who recently received an error when trying to run report for a specific period of time. The error said the following:

A get/change next operation on table 'POP_PORcptApply' deadlock was detected.

Please let me know, if anyone has run into the same issue or a similar one and how this was resolved.

Thanks!

 

[LyleU]

From SQLServerPerformance.com:
*************
Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire a lock on the object that the other process has. When this happens, SQL Server identifies the problem and ends the deadlock by automatically choosing one process and aborting the other process, allowing the other process to continue. The aborted transaction is rolled back and an error message is sent to the user of the aborted process. Generally, the transaction that requires the least amount of overhead to rollback is the transaction that is aborted.
*****************
As you can see, your error was nothing fatal to the system and likely you could run your report right after receiving the message. Repeated deadlock errors would raise concerns so you might want to watch the situation for a while.

Lyle