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, set connector.input.file.format.csv.enable to false

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.

• KBA 2404463 - LMS Connectors - Connector Workbooks FAQ
• KBA 2529731 - Cannot specify NULL exception for a referenced field which doesn't have any data - SuccessFactors LMS
• KBA 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-CON , Connectors , Problem