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


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



SAP SuccessFactors  Recruiting Management 


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.