SAP Knowledge Base Article - Public

2420708 - Cannot Add/Import User

Symptom

We are trying to create a new user in the system -both manually or via the import tool but we are receiving the following error:

"The system could not add the record for one or more reasons: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CUSTOMER_DB.PK_CA_USER_COMP_DATA) violated"

Environment

Learning Management System (LMS)

Cause

There are 2 currencies currently set as default in the application:

  1. References > Commerce > Currencies
  2. search all active currencies
  3. add field chooser " is global default"

currencies.jpg

Resolution

Choose of those two currencies as your default and you will be able to create users without issues.

See Also

2404547 - EntityImportServiceException: Error in importData java null pointer exception

Keywords

ORA-00001,PK_CA_USER_COMP_DATA, create new user, import user, import tool , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-BCJ , Assign (bulk), Add/ Delete Sub/ Cur, Revise, Import , Problem

Product

SAP SuccessFactors Learning 1611