Symptom
You receive an application error when conducting a basic import.
The application error id is accompanied by the error:
- unique constraint violated: Table(USER_ACCOUNT), Index(UC_USER_ACCOUNT_PERSON_ID)
- Failed to add/update user [xxxxx] "XXXXX" - DAOException caught: SQLException thrown unique constraint violated" appears in the email notification after an Employee Import Scheduled job completes.
- Exception caught error is received when importing a user.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
SAP SuccessFactors HXM Suite
Product
Keywords
basic import, SQLException thrown: unique constraint violated, DAOException caught, employee import,ORA-00001,Exception caught when saving user,Exception caught:, unique constraint violated: Table(USER_ACCOUNT), Index(UC_USER_ACCOUNT_PERSON_ID), DAOException caught: com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB , KBA , LOD-SF-PLT-UIM , Employee Import Issues , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.