SAP Knowledge Base Article - Public

2098034 - Unable to import imanifest file Error ORA-01400

Symptom

When using Content > Tools > Import Content and loading a zip file containing only imanifest.xml generates an error:

com.plateausystems.elms.util.helper.ElmsCreateException: SQLException - Could not create record!
at com.plateausystems.elms.bo.objective.impl.ObjectiveServiceImpl.addObjective(ObjectiveServiceImpl.java:91)
at sun.reflect.NativeMethodAccessorimpl.invoke0(Native Method)
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("COMPANY_STAGE_TMS"."PA_CBT_OBJECTIVE"."OBJECTIVE")

Environment

Learning Management System (all supported versions)

Reproducing the Issue

  1. Open the content zip file
  2. Zip only the imanifest.xml file
  3. Logon to LMS
  4. Go to Content > Tools > Import Content
  5. Browse for this imanifest zip file and load

Cause

Cannot upload a null into table PA_CBT_OBJECTIVE column OBJECTIVE.

Code causing the issue within imanifest.xml:      
    <classification>
      <purpose>
        <source>
          <langstring xml:lang="x-none">LOMv1.0</langstring>
        </source>
          <value>
            <langstring xml:lang="x-none">Educational Objective</langstring>
           </value>
       </purpose>
         <description>
            <langstring xml:lang="en"></langstring>
         </description>
            <keyword>
              <langstring xml:lang="x-none"></langstring>
            </keyword>
    </classification>
  </lom>
</metadata>

Resolution

Need to edit the imanifest.xml file and modify x-none to a value.

Fixed code for imanifest.xml:   
<classification>
      <purpose>
        <source>
          <langstring xml:lang="x-none">LOMv1.0</langstring>
        </source>
          <value>
            <langstring xml:lang="test">Educational Objective</langstring>
           </value>
       </purpose>
         <description>
            <langstring xml:lang="en"></langstring>
         </description>
            <keyword>
              <langstring xml:lang="x-none"></langstring>
            </keyword>
    </classification>
  </lom>
</metadata>

Keywords

KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning all versions