/PACG/ECM_DEL_MSIDIM - Delete table /PACG/ECM_MSIDIM

Learn more about all recommended periodic administration activities: Periodic administration/background job activities

 

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: /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

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.

If you'd like to help us improve the documentation, please provide your feedback using the communication channels listed /wiki/spaces/PFCC/pages/1561427969. Learn about support possibilities here.