2530515 - Staging Item Connector issue

SAP Knowledge Base Article - Public

2530515 - Staging Item Connector issue

Symptom

Error in connector:

Unexpected Error.Error saving content Module
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CUSTOMER_SCHEMA"."PA_CBT_CPNT"."FORCE_ORDER")

Environment

Successfactors Learning Management System (LMS)

Reproducing the Issue

 Run the item connector.

Cause

The data in the file is not arranged correctly. I.e. the values do not match with the corresponding column header.

You may try to view it in MS Excel to clearly see how it is arranged:

  1. Save the file to locally.
  2. Open Microsoft Excel.
  3. Go to Data tab.
  4. Click Get External Data > From Text.
  5. Then, select your item connector file.
  6. Select 'Delimited' then click 'Next'.
  7. Select 'Other', then put | in the field.
  8. Click Next > Finish > OK.

 You will then see that the arrangement of columns is not proper, hence the connector fails.

Resolution

You must correct the file and ensure that the values are matching with the column headers. Otherwise, we would expect failure.

Tip:

You may arrange the file in MS excel and then save it as *.txt. This will significantly help when various columns are in the file.

 Ensure that your computer's list separator is |. (Control panel > Region > Additional Settings > List separator)

  1. After arranging the values properly, press F12.
  2. Save as type 'CSV (Comma delimited) (*.csv).
  3. Then, open the CSV file in notepad and save as text (*.txt).

See Also

  2197843 - Connector gives Error while importing data.ORA-01400: cannot insert NULL into

Keywords

Connector, ORA-01400, Failed, fail, failure, LMS, learning, NULL, FORCE_ORDER, PA_CBT_CPNT, error, Unexpected, Error saving content Module, java.sql.SQLIntegrityConstraintViolationException , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611 ; SAP SuccessFactors Learning 1702 ; SAP SuccessFactors Learning 1705 ; SAP SuccessFactors Learning 1708 ; SAP SuccessFactors Learning 1711 ; SuccessFactors Learning 1207 ; SuccessFactors Learning 1210 ; SuccessFactors Learning 1302 ; SuccessFactors Learning 1305 ; SuccessFactors Learning 1308 ; SuccessFactors Learning 1311 ; SuccessFactors Learning 1402 ; SuccessFactors Learning 1405 ; SuccessFactors Learning 1408 ; SuccessFactors Learning 1411 ; SuccessFactors Learning 1502 ; SuccessFactors Learning 1505 ; SuccessFactors Learning 1508