SQL error 1205 when accessing a table "XXXXXX" - deadlock
I came across a dead lock situation on my Solution Manager System and ST22 has lot of ABAP dumps "DBIF_RSQL_SQL_ERROR" and still continuing.
Application : SAP Solution Manager 7.1
OS : Windows
DB : SQL Server 2008 R2
SQL error 1205 when accessing table "MES_DB_AGGREGATE".
Error Text of the Database: "Transaction (Process ID 87) was deadlocked on lock
resources with another process and has been chosen as the deadlock victim.
Rerun the transaction."
I have gone through many sap notes on this dead lock, but still not clear on what is the exact solution for clearing this locks.
Can someone please throw some light on this?
Please go through the below SNOTE, and let us know if still you are facing the issue.
2021463 - Composite SAP Note for the necessary corrections to the "Event Calculation Engine" in Support Package 12.