SAP Knowledge Base Article - Public

2674317 - Learning History Connector Fails (6010 User id is nullRecord Key)

Symptom

Learning History Connector fails with the following error message:

6010.png

Code                  

Message

6010

User id is nullRecord Key ::- User Id:|Item ID:|[...]

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

SAP Successfactors Learning

Reproducing the Issue

  1. Create a .txt input file and load it into the SFTP >
  2. Run the Learning History Connector >
  3. It fails with the error stated on the "Symptom" section.

Cause

  • The input file created is in .txt format, but the system is configured to accept the input file as .csv.
  • The input file delimiters are incorrect.

Resolution

1. Input file in .txt format:

  1. Go to System Admin > Configuration > System Configuration > CONNECTORS >
  2. Search for learninghistory.connector.input.file.format.csv.enable=true >
  3. Change the value to false.

In this case, the input file is already created as a .txt file, so the configuration file should not be setup to accept .csv file.

2. Input file delimiters:

  1. Go to System Admin > Configuration > System Configuration > CONNECTORS >
  2. Search for connector.input.file.columnDelimiter= > Confirm the input file is following the column delimiter correctly.
    • E.g.: connector.input.file.columnDelimiter=|

STUD_ID|CPNT_TYP_ID|CPNT_ID!##!

UserIDX|COURSE|ItemIDX!##!

[Note] Don't use more than one delimiter.

See Also

2383649 - Can LMS connectors read CSV input files?

Keywords

LMS, Learning, Management, System, Connector, Fail, Error, 6010, User id is nullRecord, Key, CSV, .csv, .txt, Txt, input file, delimiter, comma, pipe , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , Problem

Product

SAP SuccessFactors Learning all versions