Symptom
- User connector giving fatal error for every record
- Some of the records are processed 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
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Learning
Cause
The user for which the connector is throwing the error, data for the user is already present the LMS in the past.
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 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, ORA-06512, TMS.PKG_TRIGGER, SQLIntegrityConstraintViolationException , KBA , LOD-SF-LMS-CON , Connectors , Problem
SAP Knowledge Base Article - Public