Skip to Content
avatar image
Former Member

I'd like to cancel all my messages with "system error" status

Hi gurus:

My system's BC:MSG_AUDIT table is continuously growing. At this moment, it has more than three millon records. Apparently, this table contains audit information of messages, ie, the different versions of each.

In Adapter Engine I can see a lot of messages in "system error" status. I've tried a lot of reports with the idea to cancel and delete these messages, but I have not succeeded so far. Some of the messages have been reprocessed more than 900 times, making it grow tremendously the number of entries in BC_MSG_AUDIT table.

I've activated the XML messages archiving and deleting in my PI 7.1.

Does anyone have any idea why this is happening? and, how could I fix it?

Thanks to all in advance and best regards,

Alejandro Gómez.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 20, 2012 at 06:22 AM

    you can use report

    RSXMB_CANCEL_MESSAGES and RSXMB_DELETE_MESSAGES

    if nothing works you can use db reorg - http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp.... but be careful it will effect all message and not advisable in production running system...

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 19, 2012 at 02:53 PM

    Hi Gomez,

    This issue comes when message were failed with in MONI and PI system trying to resend those messages.

    Solution:

    There is a report to cancell all message (search in scn).

    cancel all messages - Sytem error status messages(adapter engine manually).

    ask Basis team to delete entries from BC:MSG_AUDIT, they need to schedule a job to perform deletion activity on java tables,even they can perform direct delete also(but not recommended).

    Regards,

    Raj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Raja Sekhar Reddy:

      To prevent the database reached its maximum capacity, so far I had to delete records directly from Oracle table BC_MSG_AUDIT several times. But after a few weeks, that table contain several thousand records again.

      Thanks for your response. Regards,

      Alejandro Gómez.

  • Nov 19, 2012 at 02:54 PM

    Hi Alejandro,

    You can delete messages in PI using the below link,.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/402fae48-0601-0010-3088-85c46a236f50?overridelayout=true

    Regards,

    Sreeni.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi kancham sreenivasulu:

      In the past I had reviewed this guide, but it has not helped me to solve my problem.

      Thanks for your response. Regards,

      Alejandro Gómez.