2769270 - Item Connector: Not nullable "CPNT_ID" column

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

SAP SuccessFactors Learning

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.

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.

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

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