Versions Compared

Key

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

Delete entries from table /PACG/ECM_MIDMAP - Mapping of the message ID to the idoc number.

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 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_EQUIImage Added

Expected results after execution

Performance optimization.

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 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.