| Info |
|---|
Learn more about all recommended periodic administration activities: Periodic administration activities |
Delete entries from table /PACG/ECM_MSIDM - Incoming message mapping.
tocin order to optimize system performance.
Purpose of the affected table
Table /PACG/ECM_MSIDIM is used for storing messages from inbound processing.
Transaction GUID
FSM Company ID
Message ID
Cloud object GUID
Cloud message type
Message class
Message Type
Message Number
Message variable
Message variable
Message variable
Message variable
Inc. message status
Created on
Time
Created by
000TOukwL5hX0000h10o3m
5016
861
6E50764F39554ED99359E3B7AEFCDCC4
EQUIPMENT
/PACG/ECM_MAIN
I
042
861
2
11.09.2022
13:00:04
SMR
Expected results after execution
Performance optimization., 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. |