SAP Note 1113757 - XI3.0/7.0x/7.1x: Cleaning up the history table

Component : Integration Server -

Solution : https://service.sap.com/sap/support/notes/1113757 (SAP Service marketplace login required)

Summary :
The SAP Note addresses an issue where the history table SXMSPHIST retains surplus entries despite successful execution of the RSXMB_DELETE_HISTORY report. Users of the Exchange Infrastructure face persistent entries that should have been deleted. The solution involves creating and running a new report, RSXMB_CHECK_HISTORY, to check and delete these surplus entries based on the retention period. This requires specific authorizations and can only be executed standalone to maintain data consistency. For the execution, use of an SAP standard role is advisable, and scheduling the report as a background job is recommended to manage the execution time effectively.

Key words :
sap standard production program    package, relevant support package, executable program    status, program rsxmb_check_history    type, attached correction instructions, terms rsxmb_delete_history reason, delete history entries, report checks entries, surplus history entries, history table sxmsphist

Related Notes :

1691037Report RSXMB_CHECK_HISTORY uses incorrect time zone
1332139NW04s Support Package Stack 19
1320523XI 30 Support Package Stack (SPS) 24
1137791NW04s Support Package Stack 15