Messages not getting deleted from SXMB_MONI

[Former Member]

Hi,

We have scheduled jobs to archive and delete the XML messages in SAP XI.

ARV_BC_XMB_WRP - for archiving (RSXMB_ARCHIVE_MESSAGES)

ARV_BC_XMB_DEL - for deleting (RSXMB_DELETE_ARCHIVED_MESSAGES)

The jobs are getting successfully executed. We could see the archived files in the target directory.

But still the messages persist in the table SXMSPMAST and its growing fast.

No idea why they are not getting deleted.

Please help.

Thanks.

[Former Member]

Field ITFACTION of the table SXMSPMAST stores the flag for deletion/Archive etc. Please check what is a status of this flag in table SXMSPMAST for the message ID which is not getting deleted from SXMB_MONI.

There are some step by step Archive and Deletion guides available on SDN. Plz check those. For e.g.

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

Regards,

Gouri

[Former Member]

Hi Gouri,

I have done the same that is mentioned in the blog.

The messages are getting archived. Even the deletion job shows the status as success.

But they persist in the table and in Moni.

[Former Member]

Are you able to see any messages when you click on "Archived XML Messages (Search Using Archive) " option in SXMB_MONI?

Is there any data inside a archive file ?

Regards,

Gouri

[Former Member]

Yes Gouri,

There are messages in the archive file.

[former_member4985]

Hi,

First things first, you need to check two reports.

About the RXMB_SHOW_STATUS, you can see the status of some messages, for example, if they're not in

status 000, 003 and 006, which means they're in final state, then it may means that some messages were not ready to be processed by the default job you configure.

There're three pre-requisites for deleting/archiving messages:

1- Age of message (older than the retention period)

2- Message status is final

3- Adapter status is final

Also, we have to consider the messages in report RSXMB_SHOW_REORG_STATUS, that shows us the messages that are being 'considered' and those are being 'ignored'.

The first one takes all the three pre-requisites in account; the second one takes only the first pre-requisite in account.

The status of the messages are take in account when the default job you set up runs.

Appying that, we can have, for example, messages that are in status 029, which means "Transfer to Process Engine - BPE (waiting for reorg. of BPE)", you should fix these status.

It can be done with note:

#1042379 - BPE-HT: Deleting messages that are no longer used

It was just an explanation about the procedures of Archiving/Deleting for you to understand.

You may find more information in note #872388

Best regards,

Caio Cagnani

[Former Member]

Hi Rumi,

All messages with ITFACTION=DEL will be deleted by report RSXMB_DELETE_MESSAGES as soon as message processing is complete (message status is final) and adapter status allows deletion.

Thanks,

Amar.

[Former Member]

Hi,

Thanks for your prompt reply.

All the messages are flagged to be archived.

The deletion job is scheduled to delete the messages after they are archived in this case.

Bul still I can see th messages in the table.