How to delete messages in retention period

[Former Member]

I’ve tried the report RSXMB_DELETE_MESSAGES and check it with RSXMB_SHOW_REORG_STATUS report, but only some messages were deleted from DB.

I cannot delete the message there isn't in retention period. 

Message and adapter status is ignored in  the following
- Asynchr. msgs not in retention period (can be deleted):       1.888.873

My question is, how can i delete the messages in retention period? Or how to change the retention period?

Anyone could provide me the steps?

Thank you

[rajasekhar_reddy14]

RSXMB_DELETE_MESSAGES job deletes only ABAP stackmessages .

If any message failed due to mapping error or any other reason first you need to cancel them manually then only these message are eligible to delete it from tables.

Run deletion job peroidically to delete old messages .

[Former Member]

Hi,

Please go through the below link.

http://wiki.sdn.sap.com/wiki/display/XI/Troubleshooting+for+Archive+and+Delete+on+Integration+Engine

Regards

Venkat

[tobiasberneck]

Hi Peter,

by this link:

http://<host>:<port>/MessagingSystem/archiving/reorgdb.jsp

you can set the message to deletable, if they are still in retention period.

Retention period can be changed by sxmb_admin -> Define Interfaces for Archiving and Retention Periods -> Retention periods.

Kind regards,

Tobi.