2511198 - Error in connector run while creating users - Error : ava.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (company_SBX_TMS.PK_USER_RECOMMENDATIONS_PREF) violated ORA-06512: at "company_SBX_TMS.PKG_TRIGGER - LMS

SAP Knowledge Base Article - Public

2511198 - Error in connector run while creating users - Error : ava.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (company_SBX_TMS.PK_USER_RECOMMENDATIONS_PREF) violated ORA-06512: at "company_SBX_TMS.PKG_TRIGGER - LMS

Symptom

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

 

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

Product

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611 ; SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SAP SuccessFactors Learning 1711 ; SuccessFactors Learning 1207 ; SuccessFactors Learning 1210 ; SuccessFactors Learning 1302 ; SuccessFactors Learning 1305 ; SuccessFactors Learning 1308 ; SuccessFactors Learning 1311 ; SuccessFactors Learning 1402 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408 ; SuccessFactors Learning 1411 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508