Delete messages in SXMB_MONI

[Former Member]

Hi All,

There are some unwanted messages lying in SXMB_MONI with error status in our production system.

What is the best way to clean it up?

Thanks

Mike

[Former Member]

Hi Michale,

SXMSPMAST is the master table that holds the key information about each of the
 messages going through the Integration engine. The data is persisted in this table based
 on the retention period defined for asynchronous and synchronous messages. 
If a message enters the Integration Server the field ITFACTION of SXMSPMAST table is set
 to INIT. Then the interface is checked for the action to take, if it is listed as an interface for 
archiving, the field ITFACTION is changed to ARCH. Otherwise it changes to DEL

If you want to delete the messages you can ask your basis team to run report RSTRFCQD for outbound and RSTRFCID for inbout to delete messages.

Please refer the blog also if it helps

/people/gourav.khare2/blog/2007/12/21/mass-cancellation-of-error-messages--xi

http://wiki.sdn.sap.com/wiki/display/XI/PIArchivingConceptual+Overview

Regards,

Srinivas

[Former Member]

Hi Michale,

please look at the below threads and blogs, hope this will help you.

Archiving Messages in Exchange Infrastructure 3.0

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/402fae48-0601-0010-3088-85c46a236...

Regards,

Pradeep A.

[Former Member]

Hi

Periodically Schedule a job to delete the error messages,

http://help.sap.com/saphelp_nw04/helpdata/en/cd/20bc3ff6beeb0ce10000000a114084/frameset.htm

Regards

Ramg