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
SAP Knowledge Base Article - Public