SAP Knowledge Base Article - Public

2529731 - Cannot specify NULL exception for an empty referenced field in Item Connector

Symptom

When creating items using the item connector, the file is getting rejected by connector with error message as "Cannot specify a NULL key value for referenced entity".

The referenced entity is not defined in the instance as this field is not used. How can the Item connector be made to accept the templates file without these values being populated?

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Fill out Item Connector template >
  2. Leave any referenced field empty >
  3. Import the file >
  4. When the connector runs, error "Cannot specify a NULL key value for referenced entity" is displayed.

Cause

The file contains the header row for a referenced field even though it is not being used, and since the header column is referenced, the system understand that a value must be imported with that column.

Resolution

If a referenced field is not in use and it must be left blank, the entire column can be removed from the file, including the header row.

See Also

Keywords

Cannot, specify, a, NULL, key, value, for, referenced, entity, item, connector, import, error, empty, blank, column , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions