Symptom
- Duplicate end date of 31/12/9999 in custom MDF causing error "1. Import failed due to unexpected system error. Please contact administrator" when performing upload.
Environment
SAP SuccessFactors HCM Suite
Reproducing the Issue
- Attempt to import data using the standard downloaded template.
- Execute the import job.
- Encounter the error message: "1. Import failed due to unexpected system error. Please contact administrator".
Cause
- For MDF records with effective dating, Effective End Date of the latest records will be automatically set as 9999/12/31.
- When a new record was imported or add, the system will automatically modify the Effective End Date of last record from 9999/12/31 to one day before the Effective Start Date of the new record.
- The issue is caused by dirty data where two rows of MDF object record for the same user have the Effective End Date of 9999/12/31.
- The system will only allow one record with Effective End Date of 9999/12/31
- The duplicate dirty data was caused by concurrent data operations in the last update. It might be multiple API imports running at the same time for the same user during the last import. Please check the below KBA 3211937 - MDF import Job failed and show "unique constraint violated..." error in Provisioning
Resolution
- Make a backup of data for the last record.
- Delete the last record in the UI page either in People Profile or in Manage Data.
- After the data is deleted, there will be only one record with Effective End Date 9999/12/31.
- Add back the deleted data record.
- Verify that the data is normal by executing the import again
- If there is a problem in deleting record or the issue still exists after adding back or you do not know which record is the duplicated one, contact support for further assistance.
See Also
3211937 - MDF import Job failed and show "unique constraint violated..." error in Provisioning
Keywords
SAP SuccessFactors, duplicate end date, 31/12/9999, custom MDF, import error, unexpected system error, data import, effective end date, dirty data, concurrent data operations, Meta Data Framework , KBA , LOD-SF-MDF-IMP , Import and Export Issues , Problem
Product
SAP SuccessFactors HCM Suite all versions