Skip to Content
avatar image
Former Member

deleting messages from the sxmb_moni

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jan 31, 2010 at 04:45 PM

    Hi,

    Please check

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 31, 2010 at 05:25 PM

    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-85c46a236f50?quicklink=index&overridelayout=true

    Regards

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 01, 2010 at 03:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Feb 05, 2010 at 10:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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