deleting messages from the sxmb_moni

[Former Member]

Hi frnz

i want to delete messages from the sxmb_moni. i am trying to delete these from the sxmb_adm---->schedule delete jobs.

here i found 1> schedule delete job for xml messages

2>schedule delete jobs for history entries

i scheduled the time and executed the job. after executing the job i am getting the status finished. while seeing the job log here its showing 0 XML messages deleted.

so the job is running but the messages are not deleting.

can u tell whatu2019s the procedure to follow the schedule delete jobs.

i gone through some blogs and threads, but i found clearly how to schedule archive jobs but not how to schedule delete jobs clearly.

pls tel me whatu2019s the mistake happening.

Regards

Munna

[Former Member]

Hi Munna,

I was able to execute RSXMB_CANCEL_MESSAGES, RSXMB_ARCHIVE_MESSAGES, and then RSXMB_ARCHIVE_MESSAGES without having to give any access key so I assume that it have to do with the Roles/profiles you have in the system.

However, I'm having a problem of my own: When executing RSXMB_ARCHIVE_MESSAGES I keep getting Runtime Errors EXPORT_TOO_MUCH_DATA for "Number Range" 88 to 88. I've managed to archive and delete all other messages but not those which is, from what I can see in SXMB_MONI, only 60 messages. Any suggestions as to how to get rid of them?

Another related question: When I execute RSXMB_SHOW_REORG_STATUS, I see that there exists 54 483 messages that can be deleted but don't know where they are and how to get to them. I sent a lot of IDocs from another SAP-system to the tRFC-port of XI/PI; could this be whats beeing refered to here? If so, how do I delete them.

Thanks and sorry for using your question.

Kind regards,

Joe

[Former Member]

Hi gurus,

I have a requirement where i need to develop a custom program which should give me the provision to delete the messages based on my given input like sync.. or asynch or particual interface or message id etc...

I am currently checking the program RSXMB_DELETE_MESSAGES.

Can any body please provide me few inputs to develop a user friendly custom program.

Thanks,

Jitender

[Former Member]

Hi Munna,

Please refer to my Blog & Wiki that explains you the concept and steps required to perform your issue.

/people/chandra.kanimenisp4z121a122b/blog/2009/12/16/pi-archiving-and-delete

Regards

Sekhar

[Former Member]

thanks Sekhar, Ramesh and Suresh for the relies.

its a very good blog from u Sekhar.

i need some clarifications how to delete the messages. first i canceled the messages by running the program RSXMB_CANCEL_MESSAGES . all the messages now are in the manually canceled status.

now i want to archive the messages and delete the messages, right?

i am trying to archive the messages by scheduling the archive job.here i am giving the archive message program RSXMB_ARCHIVE_MESSAGES,but its asking the access key.

what i have to give here. i dont know the access key.

another question , i am able to see ITFACTION field in the SXMSPMAST table. i am not able to see the messages in this field.

how to delete the messages from the table SXMSPMAST. can i delete the field or not here?

please reply

Thanks Regards

Munna

[Former Member]

Hi Munna,

Check this link

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

Reports for cancelling the msgs

RSXMB_CANCEL_NOT_REST_MESSAGES Cancel XI Messages With Errors That Cannot Be Restarted

RSXMB_DELETE_ARCHIVED_MESSAGES Delete Archived XML Messages

RSXMB_DELETE_MESSAGES Delete XML Messages from the Persistency Layer marked for DEL

RSXMB_CANCEL_MESSAGES Mass cancellation of error messages - XI

Check this link in 11th page

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

Regards

Ramesh

[Former Member]

Hi,

Please check

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

We can only delete messages with status "further processing not possible". For successful message and sync error message the deletion can be done by scheduling job via SXMB_ADM but these job wont delete async error messages here you have to cancel the messages then you can delete them via job.

For cancelling the messages please use. Report :RSXMB_CANCEL_MESSAGES"

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

Regards,

Sunil.