SAP Knowledge Base Article - Public

3296032 - Employee Import failing with error "unique constraint violated" error

Symptom

Employee Import error DAOException caught: SQLException thrown [301]: unique constraint violated: Table(USERS_SYSINFO)

Environment

SAP SuccessFactors HXM Suite

Cause

The user being create might have the value for Assignment ID being used as ASSIGNMENT_ID_EXTERNAL value by some other user.

Resolution

The solution is to either try updating this value to a different one for existing user to release this value or give the new user a different value for ASSIGNMENT_ID_EXTERNAL field.

For checking Assignment ID information in User Data File (UDF), make sure to uncheck configuration Exclude Assignment ID Column from the User Data Template from the "Platform Feature Settings" page. Then, ASSIGNMENT_ID_EXTERNAL will appear in UDF.

Information about changing Assignment ID can be found at 2825052 - Assignment ID - SAP ONE Support Launchpad 

To re-active a user, make sure to give a different ASSIGNMENT_ID_EXTERNAL value for this user and check option Re-activate purged users in basic import job.

Keywords

UC_USERS_SYSINFO_EXTERNAL_CODE, EUSFV4_STOCKPM2972:USERS_SYSINF, USERS_SYS_ID_EXTERNAL, ASSIGNMENT_ID_EXTERNAL , KBA , LOD-SF-PLT-UIM , Employee Import Issues , How To

Product

SAP SuccessFactors HXM Core 2211