Symptom
- Deleted performance form cannot be restored using the "Restore Deleted Document" functionality
- The system displays the message: "1 total forms. Successfully restored: 0. Failed to restore: 1."
- In logs and when trying to retore form via Provisioning, error appears: "foreign key constraint violation: TrexUpdate failed on table XXX:FOLDER_MAP with error: Only found 0 of 1 rows from XXX:FOLDER_MAP(FOLDER_ID) in XXX:FOLDER(FOLDER_ID)"
Environment
SAP SuccessFactors Performance Management 2025
Reproducing the Issue
- Open "Restore Deleted Form" in the Admin Center
- Enter the Form ID and click "Search"
- Select the form and click "Restore"
- Observe the message stating: "1 total forms. Successfully restored: 0. Failed to restore: 1."
Cause
These logs indicate that the form cannot be found in the employee's folder. This occurs because the form's owner or subject user has either been purged or deactivated.
Resolution
Verify whether the form's owner or subject user has been purged or deactivated.
- If the employee has been purged: The forms cannot be restored because the chain of user association has been removed. Purge the affected forms using the legacy "PM or SM Data" purge type.
- If the employee has been deactivated: Reactivate all users involved in the form's route map. Afterwards, retry restoring the form using the "Restore Deleted Document" feature
See Also
- 2086713 - How to restore deleted forms Manually and Automatically - Performance Management - SAP for Me
- 3393362 - Performance Management Error: Failed to get document content. Wrapped Exception: DAOException caught: Exception caught: SAXException caught: An invalid XML character (Unicode: 0xfffe) was found in the CDATA section. - SAP for Me
Keywords
KI2H202, restore, deleted, form, performance form, pm, restore failed, user purged, deactivated, PM or SM data purge, error, 1 total forms. Successfully restored: 0. Failed to restore: 1 , KBA , LOD-SF-PM-ADM , Admin Center, RBP, Permissions and Settings , Problem
Product
SAP SuccessFactors Performance & Goals 2511
SAP Knowledge Base Article - Public