SAP Knowledge Base Article - Preview

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

Symptom

When conducting a basic import, user receives an application error id, which 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.

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 HCM Suite

Product

SAP SuccessFactors HCM Suite 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-MNG , Manage user Issues , 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.