SAP Knowledge Base Article - Public

2511198 - Error in connector run while creating users - Error : ava.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint

Symptom

  1. User connector giving fatal error for every record
  2. Some of the records are processed fine while others are giving the fatal error
  3. 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

2017-07-30_21-45-11.png

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

Product

SAP SuccessFactors Learning all versions