3495660 - Hard Data Purge failing

• After a soft data purge, the user record cannot be found in the UDF file and we see on Data inspector tool under table Table_USERS_SYSINFO username starting with PURGED_RECORD_. After the hard purge we expect the user to get fully deleted but although the job completes, the user is still showing in the data inspector. 
• User is successfully soft purged but we are unable to hard purge it. 
• User is successfully soft purged but when we add the assignment ID to hard purge it, an error is thrown that the assignment ID does not exist. 
• While attempting to hard purge a soft purged user, we see on the application logs the following JDBCDriverException:
  • sf_class=com.successfactors.perflog.PerfLogProxy line=235 method=invoke depth=1 sourceAction=drmUserPermanentPurgeJob 
    com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [462]: failed on update or delete by foreign key constraint violation: "SFV4"."(DO statement)": line 26 col 1 (at pos 1071): TrexColumnUpdate failed on table 'SFV4_STOCKPM202262:PER_PERSON' with error: DELETE on SFV4_STOCKPM202262:PER_PERSON(PERSON_ID) failed, because 1 rows with corresponding foreign keys still exist in SFV4_STOCKPM202262:EMP_EMAIL_INFO(PERSON_ID), rc=1536 

SAP SuccessFactors HCM suite

1. Create a new Purge Request under "Data Retention Management", "Manual Data Purge".
2. Pick the purge file with Assignment ID.
3. Check "Ignore data retention time configuration for this purge request".
4. Uncheck "User belongs to an incomplete compensation or variable pay form".
5. "Launch Immediately".
6. Approve the purge request under "Purge Request Monitor".
7. Confirm the Purge is completed in the "Purge Progress & Results" under "Purge Request Monitor".
8. Go to "System Identifier Purge" under "Data Retention Management".
9. Upload the same file with assignment ID, click "Upload" and then "Submit".
10. Confirm the purge is completed under "System Identifier Purge Jobs Monitor".
11. Export the UDF file to make sure the user has been purged.
12. Check Data inspector and see that the user still exists in there under table Table_USERS_SYSINFO username contains PURGED_RECORD_
13. Receive an email notification with below error 

Subject: Permanent User Purge – [Failed]
No users or user records were purged from the application because the job failed. The job failed due to: 

• com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [462]: failed on update or delete by foreign key constraint violation: "SFV4"."(DO statement)": line 26 col 1 (at pos 1071): TrexColumnUpdate failed on table 'SFV4_STOCKPM202262:PER_PERSON' with error: DELETE on SFV4_STOCKPM202262:PER_PERSON(PERSON_ID) failed, because 1 rows with corresponding foreign keys still exist in SFV4_STOCKPM202262:EMP_EMAIL_INFO(PERSON_ID), rc=1536

The issue is due to email information (or emergency contact) for the employee still available in the system after the soft purge as we can see in the part of the logs EMP_EMAIL_INFO. This may happen with other fields/keys that can be confirmed on the SuccessFactors application logs also. 

1. Generate a person and employment report from the report center for this employee.
2. Delete the email or/and emergency contact information for the employee using import. How to do delete import, please refer to official handbook: Managing Mass Changes in Employee Central - Deleting Employee Data with a Single Entity. 

• 3048464 - Not able to permanent purge user with multiple employments
• 3058601 - How To Check Soft or Permanent Purge User

SAP SuccessFactors, Employee Central, Data Purge, User Profile, Data Retention Management, Reload Data, UDF file, Import Employee Data, Basic Import, Biographical Information, Personal Information, Email Information, Emergency Contact Information, EMP_EMAIL_INFO, JDBCDriverException, PERSON_ID, CS20240007837075 , KBA , LOD-SF-EC-ADM , Admin Tools (EC Core only) , LOD-SF-PLT-DRM , Data Retention Management , Problem

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions