Transaction (Process ID ) was deadlocked on lock | communication buffer resources with another process
Error message:
Transaction (Process ID 130) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. DatabaseException caused by prior exception: com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 130) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Above issue happening only in Prod on some of the assignments, no issue if I remove SLA on the assignment.
Also, same issue happening once case resumed on temporary page and routed to wait shape.
No issues observed in logs, above error message is from broekn queue items "System-Queue-ServiceLevel ".
Can please help to check this.
***Edited by Moderator Marije to add Support Case Details; u***