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

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 Administration > Configuration > System Configuration > CONNECTORS >
  2. Search for "connector.input.file.format.csv.enable" line >
  3. Change it from "true" to "false" >
  4. Apply Changes.

See Also

Importing Courses with the Learning Item Connector

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, connector.input.file.format.csv.enable , KBA , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions