2343537 - Full HRIS Sync Job Fails with Remote Exception Error ORA-00001

SAP Knowledge Base Article - Public

2343537 - Full HRIS Sync Job Fails with Remote Exception Error ORA-00001

Symptom

Full HRIS Sync fails while daily HRIS sync completed without failure. Both sync jobs use the same admin ID. The full HRIS sync job was set to sync as far back as 01/01/1900.  

The error displayed in the job detail log shows remote exception error ORA-00001: unique constraint violated (username).

HRIS Full Sync Failure Details (excerpt):

Full exception:com.successfactors.jobscheduler.ScheduledJobExecutionException: com.successfactors.sca.ServiceSystemException: Remote Exception: RuntimeException; nested exception is: com.successfactors.sca.ServiceSystemException: Remote Exception: SQLException thrownORA-00001: unique constraint (STG4SFV4_STOCKPM1610.UC_USER_ACCOUNT_USER_NAME) violated.

Note: [remainder of job run detail log information removed for simplicity]

Cause

The root cause of the problem is related to the configuration of the HRIS Sync Mapping in the Succession Data Model (SDM). In this case the standard-element field "username" is mapped to a custom string field in HRIS element "personInfo". The custom-string field contained duplicate data, therefore, when it was synced with the username field the system failed to complete the sync job since all "usernames" must be unique.

HRIS Sync Mapping from SDM:

  <hris-sync-mappings>
    <hris-element-ref refid="personInfo">
      <hris-mapping >
        <hris-field-ref refid="custom-string1"/>
        <standard-element-ref refid="username"/>
      </hris-mapping>

Resolution

To resolve the problem, the duplicate information in the custom-string field must be changed such that each field contains unique data. Once all the data in the custom-string field is unique the full HRIS sync job will run without error.

Alterntively, the Full HRIS Sync will run if the reference to the sync mapping of the custom-string field to the username field is removed. This may work as a temporary workaround if the duplicate data in the custom-string field cannot be changed first.

 

Keywords

KBA , LOD-SF-EC-INT , Suite Integration (EC to RCM, ONB, CVP) , Problem

Product

SAP SuccessFactors HCM Core 1511 ; SAP SuccessFactors HCM Core 1602 ; SAP SuccessFactors HCM Core 1605 ; SAP SuccessFactors HCM Core 1608 ; SuccessFactors HCM Core 1207 ; SuccessFactors HCM Core 1210 ; SuccessFactors HCM Core 1302 ; SuccessFactors HCM Core 1305 ; SuccessFactors HCM Core 1308 ; SuccessFactors HCM Core 1311 ; SuccessFactors HCM Core 1402 ; SuccessFactors HCM Core 1405 ; SuccessFactors HCM Core 1408 ; SuccessFactors HCM Core 1411 ; SuccessFactors HCM Core 1502 ; SuccessFactors HCM Core 1505 ; SuccessFactors HCM Core 1508