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 for Me (Login required).

Search for additional results

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