Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL error 1205 when accessing a table "XXXXXX" - deadlock

Hi Experts,

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

Short text

    SQL error 1205 when accessing table "MES_DB_AGGREGATE".

What happened?

    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?

Regards,

Leela.

Former Member
Former Member replied

Hello Leela,

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.

Regards

Eknath

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question