Following SAP Note 820149-- To delete the Manually Changed Messages

[Former Member]

Hi all,

I have 10,000 messages in error state, i would like to delete all of them from MONI and i followed these steps

1) Cancelled all of them from MONI and now they as with cancelled manually status.

2) I set the parameter according to this SAP Note 820149

3) Defined Interfaces for Archiving and Retention Periods ( here mentioned all interfaces & retention periods are all set as 1 expect History Entries for Deleted XML Messages. this has been setup as 7)

4) Now Scheduled Archiving Job & Delete Jobs from SXMB_ADM .

Archiving Job finished and when i check the log, says 10,000 messages Archived.

Deletion job finished and when i check the log, says 0 messages deleted.

What could be the problem. am i missing any thing???

Please guide me on How to delete the Manually Cancelled messages from MONI.

I am able to delete successfully processed messages with out any issue

Regards

Vamsi

[former_member4985]

Hello.

Checking out the report 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.

Also, please check note:

#872388 - Troubleshooting Archiving and Deletion in PI

Remeber the pre-requisites. If the messages are not archived and you mark

their interfaces now, they should be deleted.

Regards,

Caio Cagnani

[Former Member]

Heloo Caio Cagnani,

I would like to summarize my case here:

1) I have defined the history of retention period as 7 days

2) All these 10,000 messages are older than 7 days

3) all these are failed messages, not in final state.

When i run RXMB_SHOW_STATUS report, i have like this

000 status--- nothing

003 status---989 messages

006 status--- 0 messages

As i said, messages are archived once the Archive job has been finished

But why they did not get deleted

Regards

[Former Member]

Hello,

Your retention period should be after the date on which you canceled the messages .

Messgaes are archived from the table SXMSPMAST and the EXETIMEST field is used to evalute if the message falls withing the retention period .

When u cancel the message in moni it changes the values for EXETIMEST to the date- time when u canceled the meesage .

Regards,

Ganesh.

[former_member4985]

Hi Vamsi,

Like I said, you have three pre-requisites:

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

2- Message status is final

3- Adapter status is final

If you have the messages in final status so the retention period

could be not reached yet.

Set it lower or wait till that to see if the messages will be deleted.

Kind regards,

Caio Cagnani

[Former Member]

Hi,

I have used these two steps to delete the Manually cancelled messages from MONI

1) Execute the report "RSXMB_ARCHIVE_MESSAGES" to Archive the Cancelled messages

2) Execute the report "RSXMB_DELETE_ARCHIVED_MESSAGES" to delete the messages

Since so many days i was trying to delete them from MONI but not happen

I tried this, deleted all once

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

Regards

[former_member4985]

Hey,

Thank you for your feedback Vamsi, it's good to know that you could

find a solution.

I hope I could help.

With regards,

Caio Cagnani