on 11-19-2012 2:42 PM
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.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI SAP tech:
I tried to delete several messages and it have been deleted successfully. The problem is that there are several thousands of messages, and the application does not allow me to select them all and delete them at once.
Do you know if there is any way to mark them all and delete them in one go? I think that that will solve my problem.
Thank you very much. Regards,
Alejandro Gómez.
Hi Alejandro,
You can delete messages in PI using the below link,.
Regards,
Sreeni.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.