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_MIDMAP - Mapping of the message ID to the idoc number in order to optimize system performance.

Table of Contents
minLevel1
maxLevel7

Purpose of the affected table

For each outgoing Idoc, the FSM Cloud Connector creates an entry in table /PACG/ECM_MIDMAP. After cloud confirmation, entries Entries are used in the resend process.

FSM Company ID

Message ID

IDoc number

Created on

Time

Created by

Confirmed

Message Type

Low priority queue

1

30000000000011296646

7474071

24.11.2022

05:12:43

CHP

P

/PACG/ECM_EQUI

Expected results after execution

Performance optimization.Image Added

Execution recommendations

The table is significantly big-sized. Execute the program periodically via a background job.

Confirmed messages

Confirmed status = P, A or M

Unconfirmed messages

Confirmed status = space, N or H

Entries for confirmed

messages can be deleted daily. Entries for

and unconfirmed messages can be deleted if older than the number of days set in /PACG/ECM_CPROP - General Properties of FSM Cloud Connector, field Unconf.IdocsAge. For such messages, the resend process no longer applies.

Info

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