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 HXM 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) , Problem

About this page

This 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.