2341991 - LMS SF User Connector error:ORA-01400

SAP Knowledge Base Article - Public

2341991 - LMS SF User Connector error:ORA-01400

Symptom

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

Error while importing data.ORA-01400: cannot insert NULL into ("XXX_STAGE_TMS"."PA_CONN_STUDENT"."STUD_ID"). Can you please advise what needs to be done to resolve this?

Environment

Stage,PROD,Sandbox

Reproducing the Issue

1. Log into LMS as Administrator

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

3. View Results

4. View Details

Cause

 The 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(Admin>System Admin>Configuration>System Configuration>CONNECTORS) file as below and try again :

 

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

Keywords

ora-01400,extended user file,connector failure , KBA , LOD-SF-LMS , SuccessFactors Learning , How To

Product

SAP SuccessFactors HCM Core 1605