Periodic administration/background job activities
- proaxia
To prevent performance decrease and business processes hindrance as well as to reduce manual effort, it is highly recommended that certain integration management activities be run periodically. Integration administrators together with BASIS consultants can schedule background jobs to automate the processes.
Automation of monitoring processes
Certain monitoring processes such as idoc reprocessing or queue monitoring can be automated to reduce manual effort.
Administration activity | Program | Interval / range |
|---|---|---|
Reprocessing of unprocessed IDOCs Certain IDOCs fail because of object lock, e.g. locked service order or CATS. This prevents an idoc from being successfully processed at a given moment and keeps the related object locked in FSM. The issue does not require any customizing/master data adjustment. An administrator can simply re-process such idocs manually later (e.g. in /PACG/ECM_COCKPIT - FSM Connector Cockpit). It’s recommended however to automate it by scheduling a periodic BG job. | RBDMANI2. Learn how to set up a BG job for this report: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/6293534
| Execute a few times a day (not more often than hourly) for FSM Cloud Connector-related idocs (MESSAGE TYPE /PACG/ECM*) with status 51 created in the last 24-48 hours |
Queue monitoring FSM Cloud Connector-related queues should be monitored on a regular basis to ensure the communication between SAP and FSM is undisrupted. An administrator/BASIS consultant could monitor queues using standard SAP transactions SMQ1 and SMQ2. It’s recommended however to automate this process by using the dedicated queue monitoring program and scheduling a periodic BG job. If you want to trigger automatic activation of queues via BB job, wherever possible, see also: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1903034369 | Program /PACG/ECM_QSTATUS, transaction /PACG/ECM_QSTATUS - Email queue issues | Hourly for FSM Cloud Connector-related queues with statuses SYSFAIL, CPICERR, STOPPING, STOP, NOSENDS. Optionally for READY, WAITING, WAITSTOP with min. lifetime of e.g. 15 min. |
Table deletion
Tables storing technical data can quickly grow and hence should be reduced regularly in order to optimize performance.
For the first-time deletion, it’s recommended to split the deletion process into a few parts, based on age.
Administration activity | Program | Interval / range |
|---|---|---|
Delete entries from table /PACG/ECM_MIDMAP - Mapping of the message ID to the idoc number | Program /PACG/ECM_DELETE_MIDMAP, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/75464857 | Entries can be deleted if older than the number of days set in /PACG/ECM_CPROP - General Properties of FSM Cloud Connector, field Unconf.IdocsAge. Learn more: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/75464857/PACG+ECM+DEL+MIDMAP+-+Delete+table+PACG+ECM+MIDMAP#Execution-recommendations |
Delete entries from table /PACG/ECM_EOBREF - SAP -> external object reference | Program /PACG/ECM_DELETE_EOBREF, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/73105716 | Delete entries older than a year. |
Delete entries from table /PACG/ECM_MSIDIM - Incoming message mapping | Program /PACG/ECM_DELETE_MSIDIM, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/75464864 | Delete entries without error status after 2 days. |
Delete entries from table /PACG/ECM_ARMAT - E4C: Reseved Materials Stock. | Program /PACG/ECM_DELETE_ARMAT, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/75530281 | Preferably, delete entries based on order status (relevant for business process completion). |
Delete FSM Logs | Program /PACG/ECM_FSMLGH_DELETE, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1824423949 or SBAL_DELETE, transaction SLG2 - Application Log: Delete logs, depending on settings in /PACG/ECM_CUSLOG, field Log Type | Delete entries older than 3 months or according to your company rules for data retention |
Delete unneeded IDOCs (and idoc data for the Cockpit in table /PACG/ECM_CIDOCS) | For idoc deletion, use WE11. Learn more: Deleting unneeded IDOCs
For deletion of idoc data used by https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/2137096193, see program /PACG/ECM_DELETE_CIDOCS, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1880326310 | Delete entries older than 3 months or according to your company rules for data retention |
Delete entries from table /PACG/ECM_ALTEW - Not booked Time Effort and Work Time | Program /PACG/ECM_DELETE_ALTEW, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1881178137 | The table stores all inbound time efforts therefore can grow to significant size. Deletion frequency and criteria should depend on whether time efforts are updated in FSM after synchronization (see https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1557135363) and whether the functionality of parking is used (see https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1203175437). |
Delete entries from table /PACG/ECM_CIDOCS - Cockpit relevant Idocs | Program /PACG/ECM_DELETE_CIDOCS, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1880326310 | Idoc data is written to this table during inbound/outbound idoc processing, so that it can be later used by https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1883766798. Delete entries with the same interval as idocs. |
Delete entries from table /PACG/ECM_DEL_APRES - Complex Pers. Reservations from FSM | Program /PACG/ECM_DELETE_APRES, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1966080113 | The interval depends on the number of reservations longer than a day and saved as CATS |
Delete entries from table /PACG/ECM_DELEVT - Deletion Requests Information Table | Program /PACG/ECM_DELETE_DELEVT, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/2148728848 | Depending on retention policy customizing in FSM |
Archiving
Archiving certain objects, such as FSM Activities or Message Broker logs, is a safer solution than permanent deletion.
Administration activity | Program | Interval/range |
|---|---|---|
Archive (ZIP) Message Broker logs | N/A, log storage location depends on Message Broker configuration. Learn more: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/6293746 | Monthly |
Archive unnecessary FSM Activities | /PACG/ECM_ARC_DLT_E4CACT. Learn more: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/551682051 | According to company’s data retention rules |
Other
Administration activity | Program | Interval/range |
|---|---|---|
Automated offboarding of FSM users. A dedicated tool allows to easily find persons in the company who are no longer employed based on Action type from PA30 (infotype 0000) such as retirement or leaving. | /PACG/ECM_USERS_OFFBOARD, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1828061185 | Depending on turnover rate and according to company’s data retention rules |
FSM attachments no longer needed in the SAP ECC/S4 system can be removed using the dedicated tool. It does not affect attachments in FSM. | Program /PACG/ECM_DELETE_ATTCHMS, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1838546945 | According to company’s data retention rules |
If arrival date should be calculated for reserved materials and displayed in FSM, a dedicated tool has to calculate it regularly | Program /PACG/ECM_RMAT_ARRIVAL, transaction https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1722679297 | Depending on reserved material process |
Assign the relevant authorization objects or roles to new SAP users. Learn more: https://proaxia-prod-doc.atlassian.net/wiki/spaces/PFCC/pages/1702854657 |
|
|
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.