SAP Knowledge Base Article - Preview

3087765 - Permanent User Purge failing due to Failed on update or delete by foreign key constraint violation: TrexColumnUpdate failed on table - Recruiting Management

Symptom

Getting a message with the following exception when trying to do a User Permanent Purge. 

Wrapped Exception: com.successfactors.db.dao.DAOException: SQLException while executing SQL scripts.com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [462]:'<Company Specific table> :FORM_DATA' with error: On Update/Delete action failed on referencing Table;from table <Company Specific table> :FORM_DATA to table STG4SFV4_STOCKPM172602:RCM_JOB_REQ, action=DELETE, ref-action=restrict, original error was: DELETE on <Company Specific table> :RCM_JOB_REQ(JOB_REQ_ID) failed, because 743 rows with corresponding foreign keys still exist in <Company Specific table> :RCM_JOB_REQ_JOBCODE(JOB_REQ_ID)(rc=1536 ), rc=1536.


Read more...

Environment

SAP SuccessFactors  Recruiting Management 

Keywords

Permanent Purge, user purge, soft purge , KBA , LOD-SF-RCM-ADM , Admin Center, RBP, Permissions and Settings , 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.