3598168 - "Person data purge failed. Please check server log or create a ticket." in Onboarding Purge

Candidate is not successfully being purged, issue: "Completed with errors".

The file 'DRTMECMasterDataObjectType.csv' in the purge results returns the notes: "Person data purge failed. Please check server log or create a ticket."

SAP SuccessFactors Onboarding

The purge process is failing due to a unique constraint issue in the EMP_PERSONAL_INFO_T table, specifically related to the UC_EMP_PERSONAL_INFO_KEY index, which requires unique PERSON_ID and EFFECTIVE_START_DATE values.

Example: Person ID 123456, there are two personal information records, both with an end_date of "9999-12-31", which is unexpected. The purge process is designed to remove personal data while keeping only the latest record (i.e., the one with "9999-12-31" as the end date). However, because both records share this end date, the system encounters a constraint violation when trying to update the start_date as part of the anonymization process.

As identifying the data issue can be challenging for customer side, kindly raise a ticket for SAP SuccessFactors Onboarding Support team, informing the following information:

• Open it under component: LOD-SF-OBX-GDP
• Kindly provide:
  • Company ID
  • Support Access
  • Affected candidate to be purged (User Sys ID)
  • Purge result file
  • Purge Request ID (in Purge Request Monitor)
  • Your approval to raise scripts in order to correct the data.

The script will only correct potential data issues, customers will have to internally perform the Purge after issue is corrected.

purge, error, candidate, cannot, be, purged, with error: unique constraint violation in self check for table, UC_EMP_PERSONAL_INFO_KEY, EMP_PERSONAL_INFO_T, Person data purge failed, Please check server log or create a ticket, onboarding, OBX , KBA , LOD-SF-OBX-GDP , Data Protection , Problem