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 , Learning Management System , How To