2488688 - Unable to Complete "User Permanent Purge" due to "child record found" error

SAP Knowledge Base Article - Public

2488688 - Unable to Complete "User Permanent Purge" due to "child record found" error

Symptom

User permanent purge is failing with the following error:

"No users or user records were purged from the application because the job failed. The job failed due to: Run user purge failed: Wrapped Exception: com.successfactors.db.dao.DAOException: SQLException while executing SQL scripts.java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (STG2EUSFV4_STOCKPM100156.FK_EMP_PERSONAL_USERS_SYS_ID) violated - child record found."

Environment

SAP SuccessFactors Platform.

Reproducing the Issue

  1. Run the Data Retention Management tool (DRM) for User Permanent Purge;
  2. Upload the attached field purge.csv and execute the purge;
  3. Go to Maintenance Monitor and observe taht the job shows as failed.

Error message:

"No users or user records were purged from the application because the job failed. The job failed due to: Run user purge failed: Wrapped Exception: com.successfactors.db.dao.DAOException: SQLException while executing SQL scripts.java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (STG2EUSFV4_STOCKPM100156.FK_EMP_PERSONAL_USERS_SYS_ID) violated - child record found."

Cause

The issue is due to the integration issues between SF features (such as Time Sheet Concurrent Employments (only if the main employment is purged first)) and LMS.

Resolution

  1. In provisioning Turn Off the "Enable Successfactors Learning Integration";
  2. Log out and back in again on you environment;
  3. Re-run the the DRM tool;
  4. Once the purge is successfully completed, re-enable the "Enable Successfactors Learning Integration".

Keywords

Purge User Failed, DRM Error, DRM, permanent purge, user permanent purge, user purge fails, FK_EMP_PERSONAL_USERS_SYS_ID, violated - child record found, data retention tool, data retention management tool, , KBA , LOD-SF-PLT-PRG , Self Service permanent purge/ reactivation script , LOD-SF-LMS-INT , LMS Integrations , LOD-SF-EC-EDP , Employee Data Imports , Problem

Product

SAP SuccessFactors HCM Core all versions