Delete entries from table /PACG/ECM_MSIDM - Incoming message mapping in order to optimize system performance.
Purpose of the affected table
Table /PACG/ECM_MSIDIM is used for storing messages from inbound processing, to verify if a given message was already received. If a message was already received, idoc with status 68 is created. This may happen if communication issues occur, learn more: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/37138397/PACG+ECM+COCKPIT+-+FSM+Connector+Cockpit#Set-to-processed-for-idocs-with-status-56.
Execution recommendations
The table is relatively big-sized. Execute the program periodically via a background job.
Without error status Message Status = 2 Idoc created | With error status Message Status = 1 Processing error |
|---|---|
Delete after 2 days | Entries with processing errors should not be deleted, as failed inbound IDOCs exist. If there is a maximum timeframe for inbound messages in error status, where they won’t be handled anymore, entries in this message status can be deleted. |
For the first-time deletion, it’s recommended to split the deletion process into a few parts, based on age.