Skip to Content

Messages with status 003 are not being deleted!!

Hi,

We have around 23+ millions records in SXMSPMAST in ECC that are in status 003 but are not archived or deleted which is having huge impact on the performance of the system. These are sync messages and we are logging them on purpose for years, but now it's huge. Any suggestions on how to delete/archive them would be greatly appreaciated!!

Regards,

Sai

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 18, 2017 at 07:20 AM

    Hi Sai,

    As a plus information, here is a very good wiki page about the steps you have to check:

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

    Please check results of reports:

    RSXMB_SHOW_STATUS
    RSXMB_SHOW_REORG_STATUS

    It is possible as well, that the adapter status is not correct. Please update the adapter status once for all messages in database; for this purpose schedule report SXMS_REFRESH_ADAPTER_STATUS to be executed once as a batch job using variant UPDATE_ALL.

    In SE38 create variant UPDATE_ALL for SXMS_REFRESH_ADAPTER_STATUS and then schedule the report.

    Best regards,

    Bence

    Add comment
    10|10000 characters needed characters exceeded

  • May 17, 2017 at 04:43 PM

    Hi Sai,

    You can check the note #872388 'Troubleshooting Archiving and Deletion in PI'. Ensure that the necessary deletion jobs are running. Also check the retention periods you have set.

    Best regards,


    Daniel

    Add comment
    10|10000 characters needed characters exceeded