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,!##!
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.
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