Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 28, 2015 at 02:40 PM

    Hi Leela,

    This wiki page may help you find the root cause of this deadlock:

    Information about deadlocks in DBACockpit - SAP on SQL Server - SCN Wiki

    Kind Regards,

    Luis Darui

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Eknath,

           I implemented the note and applied the manual corrections as per the note and the dumps stopped now.

      Thanks a lot for the SAP Note, this was a direct fix for my issue.

      Regards,

      Leela.

  • avatar image
    Former Member
    Oct 28, 2015 at 06:28 AM

    Hi Leela,

    SQL error 1205 when accessing table "MES_DB_AGGREGATE".

    Suggest you to follow SAP Notes

    32129 - Deadlock analysis for the SQL server

    1870847 - How to judge if a SQL Server deadlock is caused by parallel processes using the deadlock trace

    Also try to implement the relevant support package to the system as per release to check again.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded