Delete Job for XML Messages

[Former Member]

Hello,

I have a question concernig delete jobs in SAP PI (SXMB_ADM --> Administration).

If I set the period to 14 days, does it mean that the job runs every 14 days and then deletes all available messages?

My requirement would be, that the jobs runs every 14 days and then deletes all messages that are older than 7 days.

Another question regarding deletion jobs for history entries. What exactly is an history entry? Is it the perstisted message after a pipeline step (like the message version that I can see in monitor for processed xml messages)?

Thank you very much for your valuable help!

[Former Member · Accepted solution]

Hey

In sxmb_adm->define interfaces for archiving and retention period.set the retention period as 7 days.

then get back to sxmb_adm->schedule deletion job and schedule it to run every 14 days.

Thanks

Aamir

[Former Member · Accepted solution]

Hallo!

Thank you very much for your helpful answer!

One more question on this topic: The schedule job then would delete all archived messages after 7 days (if retention period is set to 7 days), right?

How could error messages be deleted from message monitoring after a certain retention period? (if no archiving is defined on them)?

[Former Member · Accepted solution]

>>The schedule job then would delete all archived messages after 7 days (if retention period is set to 7

Yeah,pretty much.

after the 7 day period they will be flagged as "Ready to be archived",then when the next archiving job runs,they will be archived.You can check the status of all the messages by executing report RSXMB_SHOW_REORG_STATUS

>>How could error messages be deleted from message monitoring after a certain retention period?

errored messages are not archived by default,since XI assumes that you might be working on them to fix it and will re-send them once the issue is resolved.If you want to archive errored out messages,you need to cancel those messages(manually or by running cancellation job periodically),once they are shown as canceled,they will be archived like any other successful message.

Thanks

Aamir

[Former Member · Accepted solution]

errored messages are not archived by default,since XI assumes that you might be working on them to fix it and will re-send them once the issue is resolved.If you want to archive errored out messages,you need to cancel those messages(manually or by running cancellation job periodically),once they are shown as canceled,they will be archived like any other successful message. 

I see, so there is no direct way to cancel those messages. Manual cancellation is not really an option so there should be a cancellation job. Where can I configure the cancellation job?

Best option would be to delete them immediately after cancellation and not archive them at all. Is this possible?

Thank you again!

[Former Member · Accepted solution]

Schedule report RSXMB_CANCEL_MESSAGES via SM36 to automatically cancel error messages.

Thanks

Aamir

[Former Member]

There is one more thing I could not clarify yet.

I flagged some messages to be deleted after a certain retention period and some to be archived. However is it possible to delete messages after they have been archived?

So for example archive messages after 30 days, and after another 30 days delete them from the archive?

[Former Member]

Further question

[former_member200962]

If I set the period to 14 days, does it mean that the job runs every 14 days and then deletes all available messages?

If I am not wrong the archiving and deletion takes place on successfully processed messages...

Regards,

Abhishek.