Symptom
When admins try to change the Content Object in the Item Level, a communication error pops up in the screen.
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
-
Open the desired item;
- Click on "Online Content" under Related (More);
- Click on the Content Object's name;
- Click on the Magnifying Glass;
- Search for the new Content Object;
- Click "Select";
- Click "OK" on the "Edit Content Object" pop up screen;
- Click "Save" at the bottom of the page;
- It may pop up a warning to reassign the course to users, click "YES"
- 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.
-
Open the desired item;
- Click on "Online Content" under Related (More);
- Click on the red "X";
- Confirm the removal;
- Click on the "+" dropdown;
- Click on "Add Content Object"
- Search for the new Content Object;
- Click "Select";
- Set the proper configuration;
- Click "OK" on the "Edit Content Object" pop up screen;
- Click "Save" at the bottom of the page;
- It may pop up a warning to reassign the course to users, click "YES"
- 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 , Items , Product Enhancement