Symptom
- User connector giving fatal error for every record
- Some of the records are proceesed fine while others are giving the fatal error
- Error : ava.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (company_SBX_TMS.PK_USER_RECOMMENDATIONS_PREF) violated ORA-06512: at "company_SBX_TMS.PKG_TRIGGER", line 3222 ORA-06512: at "company_SBX_TMS.PKG_TRIGGER", line 3672 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at
Environment
SAP SF Learning Management System
Cause
The user for which the connector is throwing the error - data for them already present the LMS in the past,
And most definitely a script was executed for these set of user for either the change in ID or deleting the user.
* Script - requested from customer end created and executed from the SAF SF team.
Resolution
There is no straight forward resolution as this is a data issue due to deletion or scrambling of ID's in the system.
As a work around you can use the import content tool in place of connector to create the new users, once the users are created via the import tool, connector will not throw error on the next run for those users.
Keywords
ORA-00001: unique constraint Connector Error User is creation giving error , KBA , LOD-SF-LMS-CON , Connectors , Problem