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:
- References > Commerce > Currencies
- search all active currencies
- add field chooser " is global default"
Resolution
Choose of those two currencies as your default and you will be able to create users without issues.
See Also
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