SAP Knowledge Base Article - Public

2971922 - Unable to reset Employee Master Data and Organizational Assignment Replication

Symptom

In app "Reset Replication Requests" for Employee Master Data and Organizational Assignment, you would like to reset Employee Master Data and Organizational Assignment Replication status. After clicking "Set status to Failed" button, you got the error message "ECPAO_QRY_ADM table could not be locked; please restart query or try again later."

Environment

SAP S/4HANA Cloud

Reproducing the Issue

Follow the steps in KBA 2655553 as below:

  1. Log on as SAP S/4HANA Cloud Administrator in the SAP S/4HANA Fiori UI;
  2. Under Employee – EC Data Replication subsection, select tile "Reset Replication Requests" for Employee Master Data and Organizational Assignment;
  3. Select all entries from the list with the "Sent" or "In Process" status and choose "Set status to Failed".

Cause

This could happen when there is another running batch job which is locking ECPAO_QRY_ADM table.

Resolution

Please wait some time and try again later.

See Also

2655553 - Employee Data and Org Assig Repl from SFSF Employee Central to SAP S/4HANA Cloud not working

Keywords

Reset Replication Requests, Employee Master Data and Organizational Assignment, queries, query, table, locked, SF EC , KBA , CA-GTF-INT-EC , with SFSF EC (JB1, 1NL) , Problem

Product

SAP S/4HANA Cloud all versions