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