SAP Knowledge Base Article - Public

2529731 - Cannot specify NULL exception for a referenced field which doesn't have any data - SuccessFactors LMS

Symptom

We are 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 and we are not planning to use these fields. How can the Item connector be made to accept the templates file without these values being populated at all.

Environment

SAP SuccessFactors Learning Management System (LMS)

Cause

The file contains the header row for the referenced fields even though you are not using them on your end and the corresponding values is not passed.

Resolution

If you do not have any data to be passed for the referenced field, you could ignore the entire column in the file. I.e. You could remove the field name in the header row and also the corresponding data column for all the data rows.

See Also

2642533 - LMS: Cannot specify a NULL Key value for reference entity REV_DTE in Item Connector

2769270 - Item Connector: Not nullable "CPNT_ID" column

Keywords

Cannot specify a NULL key value for referenced entity , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions