SAP Knowledge Base Article - Public

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

Reproducing the Issue

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:

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

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


SAP SuccessFactors Learning all versions