Solution : https://service.sap.com/sap/support/notes/872388 (SAP Service marketplace login required)
Summary :
The SAP Note addresses issues related to the growth of the database in PI or connected Proxy systems due to undeleted and unarchived messages. This affects tables like SXMSPMAST and SXMSCLUR among others. It provides detailed guidelines and links for setting up and troubleshooting deletion and arching of XML messages, workitems, and performance data in various components such as Integration Engine, Adapter Framework, and Business Process Engine. Key procedures involve configuring archive settings via transaction SXMB_ADM, checking job executions through SM37, and setting up XML DAS for the Adapter Framework. The note underscores the importance of a meticulously configured deletion/archiving strategy to maintain system performance and database size.
Key words :
-component priority recommendations / additional info category consulting validity, adapter framework 1314974 successful asynchronous messages - audit log persistence 195157 application log, archiving run transaction sxmb_adm -> schedule archiving job -> archive management -> management, /saphelp_nw73ehp1/helpdata/en/0e/80553b4d53273de10000000a114084/content, /saphelp_nw73ehp1/helpdata/en/cf/b2fc3f48ecc742e10000000a1550b0/content, /saphelp_nw73ehp1/helpdata/en/8b/08b140cbe49d2ae10000000a155106/frameset, /saphelp_nw73ehp1/helpdata/en/3f/81023cfa699508e10000000a11402f/frameset, status 14 1314974 successful asynchronous messages - audit log persistence 1113757 xi3, transaction sxmb_adm -> configure integration engine -> specific configuration, archiving/deleting work items 1389621 xi runtime
Related Notes :
| 1934953 | IDoc_AAE deletion of XI split messages |
| 1850046 | Message is archived too early after editing |
| 1538437 | PI auditing/performance tables are growing extensively |
| 1389621 | XI runtime: RSXMB_SHOW_STATUS with status 14 |
| 1314974 | PI 7.1 AF Messaging System audit log persistence |
| 1113757 | XI3.0/7.0x/7.1x: Cleaning up the history table |
| 944727 | Status overview of XI messages |
| 842187 | Switch: Deleting logically deleted message physically in adv |
| 836092 | BPE-RUN: Archiving/deleting work items |
| 820622 | Standard jobs for XI performance monitoring |
| 820149 | Deleting manually changed and terminated messages |
| 816022 | FAQ: XI/PI 3.0/7.0/7.1 J2EE Adapter Engine/Messaging System |
| 813993 | FAQ: Message status in the adapter framework |
| 790226 | Messages in AdapterEngine/PCK database do not get archived |
| 779664 | Consistency check of qRFC queues with deletion |
| 688147 | Check whether messages are scheduled in a queue |
| 195157 | Application log: Deletion of logs |