SAP Knowledge Base Article - Public

2741027 - User-SF Connector error: Not nullable "FULLTIME" column

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

  1. Update values on manager from BizX.
  2. 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