SAP Knowledge Base Article - Public

2809329 - Communication error to change Content Object in the item level - cannot insert NULL or update to NULL: Not nullable "CPNT_TYP_ID" column

Symptom

When admins try to change the Content Object in the Item Level, a communication error pops up in the screen.

1.jpg

 

Exception in method: saveSettingsAndContentStructure Exception is: An error has occurred: could not update OnlineComponentModuleObjectives
com.plateausystems.elms.client.flex.remotingservice.GeneralRemotingException: An error has occurred: could not update OnlineComponentModuleObjectives

Caused by: com.plateausystems.elms.util.helper.ElmsUpdateException: could not update OnlineComponentModuleObjectives

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

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Open the desired item;
  2. Click on "Online Content" under Related (More);
  3. Click on the Content Object's name;
  4. Click on the Magnifying Glass;
  5. Search for the new Content Object;
  6. Click "Select";
  7. Click "OK" on the "Edit Content Object" pop up screen;
  8. Click "Save" at the bottom of the page;
  9. It may pop up a warning to reassign the course to users, click "YES"
  10. Error will show up.

Cause

As confirmed by Engineering team, the method to change the Content Object is incorrect.

Resolution

If it's desired to replace the content, it should be deleted and add the new Content Object from the "+" dropdown.

  1. Open the desired item;
  2. Click on "Online Content" under Related (More);
  3. Click on the red "X";
  4. Confirm the removal;
  5. Click on the "+" dropdown;
  6. Click on "Add Content Object"
  7. Search for the new Content Object;
  8. Click "Select";
  9. Set the proper configuration;
  10. Click "OK" on the "Edit Content Object" pop up screen;
  11. Click "Save" at the bottom of the page;
  12. It may pop up a warning to reassign the course to users, click "YES"
  13. Finish the reassignment process.

Keywords

not able to replace content object, communication error, change content object, could not update OnlineComponentModuleObjectives, cannot insert NULL or update to NULL: Not nullable "CPNT_TYP_ID" column , KBA , LOD-SF-LMS-ITE , LMS Items , Product Enhancement

Product

SAP SuccessFactors Learning all versions