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

When creating items using the Item Connector, the file is rejected with the error message: “Cannot specify a NULL key value for referenced entity.”

The referenced entity is not defined in the instance because this field is not used. How can the Item Connector be configured to accept the template file without requiring these values to be populated?

SAP SuccessFactors Learning

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.

• The file contains a header column for a referenced field even though it is not used. Because the column is referenced, the system interprets it as requiring a value to be imported.
• The connector.input.file.columnDelimiter configured in the system does not match the delimiter used in the incoming feed file.

1. When a referenced field is not in use and no value should be provided, the corresponding column must be removed from the file, including the header row.
2. Verify the delimiter used in the feed file and update connector.input.file.columnDelimiter in System Configuration > Connectors to match it (or vice versa).

• 2642533 - LMS: Cannot specify a NULL Key value for reference entity REV_DTE in Item Connector
• 2769270 - Item Connector: Not nullable "CPNT_ID" column

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