Skip to Content
avatar image
Former Member

how to remove deadlock

Hi All,

We are on SQL 2005 and windows. Our delta load from ERP to BW is erroring out with Database error 1204.

I can see 2 entries in DB02 Deadlock Monitor? How do I relase these deadlock from SAP or SQLServer?

Please help!

Thanks,

Antarpreet

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 18, 2008 at 06:46 PM

    On which object does this deadlock occur?

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      ST04 transaction is showing the deadlock statistics.

      So these are historic entries that normally are kept for 7 days in the system and then cleaned out automatically.

      (Checkup with SAP note [75158|http://service.sap.com/sap/support/notes/75158])

      I believe you don't have to worry, there is no actual problem in your system, as the deadlocks are already solved / cleaned out. There should also be messages in your system log (Transaction SM21) about this......

      Regards

      Rolf