SAP Knowledge Base Article - Preview

2749427 - Unable To Permanently Purge user after a Soft Purge

Symptom

You receive an application error when trying to permanently purge user after a Soft Purge.

The application error ID is accompanied by error:

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: TrexUpdate failed on table 'DC5PRD_STOCKPM180447:WF_REQUEST_STEP' with error: On Update/Delete action failed on referencing Table; from table DC5PRD_STOCKPM180447:WF_REQUEST_STEP to table DC5PRD_STOCKPM180447:GO_WF_PENDING_HISTORY, action=DELETE, ref-action=restrict hit 12 rows in table 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 


Read more...

Environment

  •  SAP SuccessFactors HCM Core - Purge User

Product

SAP SuccessFactors HCM Core 1811

Keywords

ECT-112903, ECT-113033, SRSD-44288, foreign key, constraint violation, failed on update or delete by foreign key constraint violation, 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: TrexUpdate failed on table, On Update/Delete action failed on referencing Table; from table, soft purge, permanent purge, error, script, failed on update or delete by foreign key constraint violation, purge, Incident INC10322234, Raised RITM1532253 to cleanup stale data, Data cleanup , KBA , LOD-SF-EC-DRM , Data Retention Management - (DRM & DRTM) EC Data Only , LOD-SF-EC , Employee Central , LOD-SF-PLT , Platform Foundational Capabilities , 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.