Symptom
Update on the manager column is not successful due to the error below:
Error while updating student.1429
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: Not nullable "FULLTIME" column
Environment
SAP SuccessFactors Learning
Reproducing the Issue
- Update values on manager from BizX.
- When the User-SF Connector ran, the manager/supervisor column will not be updated.
Cause
There are more than one instructor mapped to the same user.
Resolution
Remove one of the mappings to make sure that there is only one instructor related to the user.
Keywords
not nullable; fulltime; supervisor not updated; ERROR: Not nullable "FULLTIME" column; LRN-50944 , KBA , LOD-SF-LMS-CON , Connectors , Problem
Product
SAP SuccessFactors Learning all versions