SAP Knowledge Base Article - Public

2769270 - Item Connector: Not nullable "CPNT_ID" column

Symptom

When running the Item Connector, it fails rejecting all records. Checking the connector execution, in the View Details option, it is possible to see this exception message:

Cannot specify a NULL Key value. This may be due to mismatch between the column header in input file and field mapping configured in CONNECTOR configuration.SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: Not nullable "CPNT_ID" column

Environment

SAP SuccessFactors Learning Management System (LMS)

Cause

The exception with the Item Connector takes place because the "item.connector.input.file.format.csv.enable" setting is set to true. It only expects comma separated values. On the other hand, the Item Connector file contains pipe separating the values.

Resolution

Setting "item.connector.input.file.format.csv.enable" to false should prevent the exception from happening.

In the Learning admin side, click:

  1. System Admin > Configuration > System Configuration > CONNECTORS >
  2. Search for "item.connector.input.file.format.csv.enable" > Change it from "true" to "false" > Apply Changes.

See Also

2538003 - SAP SuccessFactors Learning Connectors - User Assistance Documentation link

2404463 - LMS Connectors - Connector Workbooks FAQ

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

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

Keywords

item, connector, exception, fail, Cannot specify a NULL Key value. This may be due to mismatch between the column header in input file and field mapping configured in CONNECTOR configuration.SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: Not nullable "CPNT_ID" column, item.connector.input.file.format.csv.enable , KBA , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-ADM , Admin Tools , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions