Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

Learn more about all recommended periodic administration activities: Periodic administration activities

Delete entries from table /PACG/ECM_MSIDM - Incoming message mapping in order to optimize system performance.

toc

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.

Info

For the first-time deletion, it’s recommended to split the deletion process into a few parts, based on age.