SAP Knowledge Base Article - Public

2343566 - Errors when importing scheduling job for

Symptom

  • When loading a scorm package an error occurs:
  • Please report the following error to your system administrator error.instruction:
    com.plateausystems.elms.bo.contentimport.api.ScormContentImportServiceException: exception in processAndImportScormContent()
           at com.plateausystems.elms.bo.contentimport.impl.ScormContentImportServiceImpl.processAndImportScormContent(ScormContentImportServiceImpl.java:201)
    ...
    Caused by: com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not create record!
            at com.plateausystems.elms.bo.objective.impl.ObjectiveServiceImpl.addObjective(ObjectiveServiceImpl.java:92)
    ...
    Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CSO2_STAGE_TMS"."PA_CBT_OBJECTIVE"."OBJECTIVE")

Environment

  • SuccessFactors Learning Management System (LMS)

Reproducing the Issue

  1. Login to LMS using an Admin account
  2. System Admin > Tools > Legacy SCORM import
  3. Browse package and hit Next > Next > Next > Next > Next > Finish

Cause

  • The SCORM package doesn't include an Objective, this results in a null value being inserted into the database
  • Table PA_CBT_OBJECTIVE and column OBJECTIVE and OBJECTIVE_ID have NULLABLE = NO

Resolution

  • Update the SCORM content package to include an objective

Keywords

content, icontent, load, fail, error, unable, dump, stack,  , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1511 ; SAP SuccessFactors Learning 1602 ; SAP SuccessFactors Learning 1605 ; SAP SuccessFactors Learning 1608 ; 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