2197843 - Item Connector gives error 'ORA-01400: cannot insert NULL ' while importing data

Customer gets connector failed when running Item connector.

On the report the following error is recorded:

Unexpected Error.Error saving content Module

java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("<customer_instance>"."PA_CBT_CPNT"."FORCE_ORDER")

SuccessFactors Learning Management System (LMS) - All Supported Versions

1. Navigate to System Admin > Connectors > Item Connector > View Results
2. Select the View Details option for the date in question and this will generate a report

Example data imported:

CPNT_ID,CPNT_TYP_ID,REV_DTE,NOTACTIVE,CPNT_TITLE,INIT_NUMBER,INIT_PERIOD_TYPE_ID,INIT_BASIS_TYPE_ID,REVISER!##!
FORM-TEST,DOCUMENT,NOV-18-2011 16:30:00,N,TEST ITEM,20,Days,Event,!##!

Scenario 1
The separators need to be reviewed as in this example "," is being used yet "|" as it is set up in the connector configuration.

System Admin > Configuration > System Configuration > Connectors

### Input File Settings

#Indicates input file preference
connector.input.file.escapeChar="
connector.input.file.columnDelimiter=|
connector.input.file.eolSymbols=!##!

For resolution, change the separators in the input file.

Scenario 2
Input file has "|" as delimiter, then the problem is that you are trying to update a revision of the item via item connector, and this will need the FORCE_ORDER="Y" or "N" on the input file in order to this error been removed. This is aplicable to versions prior to 1805.

After 1805 this has been corrected and FORCE_ORDER will be set to N by default, when not informed on the input file.

Connector, ORA-01400, Cannot Insert Null Into, connector.input.file, item, connector, FORCE_ORDER , KBA , LOD-SF-LMS-CON , Connectors , Problem