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

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