SAP Knowledge Base Article - Public

2341991 - Error running SF User Connector "error:ORA-01400"

Symptom

When running the SF User Connector , receiving the following error message :

Error while importing data.ORA-01400: cannot insert NULL into ("XXX_STAGE_TMS"."PA_CONN_STUDENT"."STUD_ID")

Environment

SAP SuccessFactors Learning

Reproducing the Issue

1. Log into Learning as Administrator

2. Go to Learning Administration -> System Admin -> Connectors -> SF User Connector

3. Run the Connector - > View Results

4. View Details and Observe the error.

Cause

The below connector mapping for the extended user file is not correct:

sfuser.extendeduser.field.mapping.data.STUD_ID=^USERID

Resolution

Correct the property in Connector Configuration file as below and try again :

Go to Learning Administration -> System Admin -> Configuration - >System Configuration>CONNECTORS and update as below:

sfuser.extendeduser.field.mapping.data.STUD_ID=^UserId

Keywords

ora-01400,extended user file,connector failure, sfuser.extendeduser.field.mapping.data.STUD_ID=^UserId, SF User Connector, Learning Administration, Connector Configuration, System Configuration , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors HCM Core 1605