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: : 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.
- SAP SuccessFactors HXM Suite
- SAP SuccessFactors Employee Central
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) , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.