cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with deleting old messages in PI (SXMSPMAST)

Former Member
0 Kudos

Hi experts.

We are runing this jobs daily.:

SAP_BC_XMB_DELETE_001

SAP_BC_XMB_HIST_DELETE_001

SXMS_REFRESH_ADAPTER_STATUS

The retention periods is set to 7 days.

But still there are many old messages with status 'DEL' and 'ARCH' in the field 'ITFACTION'..

When I run SXMB_MONI it takes very, very long time to search for messages.

I think the reason is the large amount of messages . or ??

Any idea why the jobs we are running dont't delete those old messages ?

/perarne

Accepted Solutions (0)

Answers (2)

Answers (2)

Eoin_Kierans
Product and Topic Expert
Product and Topic Expert
0 Kudos

You can run the report RSXMB_SHOW_STATUS, this will give you an overview of the message status of the messages in your system. It shold be noted that only messages in a final status will be archived or deleted.

For further details of the meaning of each message status you can check the entries in table SXMSSTATT, this contains the descriptions for each numerical message status.

I would also recommend that you check the note #872388, which contains many helpful tips for archiving and deleting messages.

Former Member
0 Kudos

Please check if "Switch mode" is activated in the system. If so, messages will be stored in SXMSPMAST2 table.

Regards,

Indranil