Skip to Content

DBSQL_DUPLICATE_KEY_ERROR

Hello Gurus.

I'm occasionally getting these Runtime errors: DBSQL_DUPLICATE_KEY_ERROR.

I've seen similar posts on here recently.  Can anyone help?

Problem 1

Runniing Expected Event Monitor.   It dumps on this line in  /SAPTRX/LEH_FUNCSF01   UPDATE_DB_TABLE

Problem 2

Posting an idoc in WE19,   Dumps on same line as above.

Thanks.

Zenon.

EE_MON.JPG (59.3 kB)
WE19.JPG (60.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 27, 2015 at 03:01 PM

    Hi Zenon,

    this results on a mismatch of the counter in /SAPTRX/EH_HDR-LAST_EEHST_NBR for the EH and the number of entries in /SAPTRX/EH_EEHST for the same EH.

    Root cause is normally some coding that writes besides the standard EM interfaces to EM tables.

    Best regards,

    Steffen

    Add comment
    10|10000 characters needed characters exceeded

    • What should work if you can live with background jobs:

      SPRO:

      Event Management

           Event Messages, Status Queries, Web Interface and EM OData Service

                Define Criteria for Event Message Processing

      Criteria for Buffering Event Messages

      You define criteria for buffering event messages to save event messages in the database without them being processed by SAP Event Management (for example, all event messages for a specific event). They are sent to SAP EM later on using a report (transaction /SAPTRX/MI03) where they are then processed.

      Best regards,

      Steffen

  • avatar image
    Former Member
    Aug 28, 2015 at 02:32 AM

    Hi Zenon,

    This is what we discussed in the past.

    Runtime Error : DBSQL_DUPLICATE_KEY_ERROR | SCN

    1. Can you go to expected event monitor and check your custom activity function how it sets?

    2. Check the sequence of expected event monitor set the event handler status?

    3. Is your expected event monitor status setting sets for two different event handlers at same time?

    Regards


    GGOPII

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 28, 2015 at 08:47 AM

    Hi,

    Since you have mentioned occasionally...

    Can you check , whether you are running multiple instances at the same time. which will result in such dumps..

    It might happen, that new instance will get trigger although previous instance is still running.then it will lead to the mentioned dump.

    Regards,

    Ratnakar

    Add comment
    10|10000 characters needed characters exceeded