SAP Knowledge Base Article - Preview

3048464 - Not able to permanent purge user with multiple employments

Symptom

When trying to permanent purge one userID of an employee with multiple employments the error "Execute script to run user purge failed:  Wrapped Exception: com.successfactors.db.dao.DAOException: SQLException while executing SQL scripts.com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [462]: failed on update or delete by foreign key constraint violation: "DC5PRD"."(DO statement)": line 15 col 1 (at pos 501): TrexColumnUpdate failed on table 'DC5PRD_STOCKPM5632:EMP_EMPLOYMENT_INFO' with error: DELETE on DC5PRD_STOCKPM5632:EMP_EMPLOYMENT_INFO(EMPLOYMENT_ID) failed, because 8 rows with corresponding foreign keys still exist in DC5PRD_STOCKPM5632:EMP_JOB_INFO_T(EMPLOYMENT_ID), rc=1536." is presented. 


Read more...

Environment

  • SAP SuccessFactors HCM Suite 
  • SAP SuccessFactors Employee Central

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Suite 2011

Keywords

user id, userid, permanently purge, purged, concurrent employment, rehired, multi, multiple, global assignment, GA, CE, unable to purge, not possible to purge, cannot purge , KBA , LOD-SF-EC-ADM , Admin Tools (EC Core only) , LOD-SF-EC-CON , Concurrent Employment , LOD-SF-EC-GA , Global Assignment , LOD-SF-EC-DRM , Data Retention Management - (DRM & DRTM) EC Data Only , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.