2341991 - LMS SF User Connector error:ORA-01400

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?

Stage,PROD,Sandbox

1. Log into LMS as Administrator

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

3. View Results

4. View Details

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

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

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

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