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
- Fill out Item Connector template >
- Leave any referenced field empty >
- Import the file >
- 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