SAP Knowledge Base Article - Preview

2882447 - SQLException thrown: unique constraint violated error generated on Employee Import or Basic Employee Import

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

SAP SuccessFactors HCM Core all versions

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.