SAP Knowledge Base Article - Public

3043101 - Content Import error: cannot insert NULL or update to NULL: Not nullable "OBJECTIVE" column

Symptom

The following error is thrown when a SCORM content is being imported into LMS.

Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: Not nullable "OBJECTIVE" column

Environment

SAP SuccessFactors Learning

Reproducing the Issue

use the content import tool via LMS Ui and receive error.

Cause

Objective is missing in the SCORM Manifest file.

Resolution

This change must be performed by the content developer as it goes beyond Cloud Support area of scope and expertise.

Edit the manifest file in a text editor (Notepad++ is preferable) and find the following section(s):

  • Incorrect:

<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="en"></langstring>
     </keyword>
    </classification>

  • Correct:

<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">Testing Objective7
       </langstring>
     </description>
     <keyword>
      <langstring xml:lang="en"></langstring>
     </keyword>
    </classification>

Keywords

SCORM, Null Objective, Import Content Error, Not nullable "OBJECTIVE" column, cannot insert NULL or update to NULL, manifest , KBA , LOD-SF-LMS-CNT , Content , Problem

Product

SAP SuccessFactors Learning all versions