SAP Knowledge Base Article - Public

2741027 - User-SF Connector ERROR: Not nullable "FULLTIME" column LMS

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 
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:355)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:195) 
at com.sap.db.jdbc.packet.ReplyPacket.buildExceptionChain(ReplyPacket.java:108) 
at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:1030) 
at com.sap.db.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:768) 
at com.sap.db.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:536) 
at com.sap.db.jdbc.CallableStatementSapDB.execute(CallableStatementSapDB.java:370) 
at com.sap.db.jdbc.CallableStatementSapDB.executeUpdate(CallableStatementSapDB.java:916) 
at com.sap.db.jdbc.trace.PreparedStatement.executeUpdate(PreparedStatement.java:240) 
at com.plateau.common.db.hana.impl.HanaPreparedStatement.executeUpdate(HanaPreparedStatement.java:323) 
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:272) 
at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:138) 
at com.sun.proxy.$Proxy339.executeUpdate(Unknown Source) 
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at com.plateau.foundation.jdbc.StatementPerfMonitorInvocationHandler.invoke(StatementPerfMonitorInvocationHandler.java:146) 
at com.sun.proxy.$Proxy340.executeUpdate(Unknown Source) 
at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at com.plateau.common.core.api.InterruptibleInvocationHandler.invoke(InterruptibleInvocationHandler.java:71) 
at com.plateau.common.db.api.InterruptibleJdbcObjectProxyFactory$InterruptibleJdbcObjectProxy.invoke(InterruptibleJdbcObjectProxyFactory.java:155) 
at com.sun.proxy.$Proxy341.executeUpdate(Unknown Source) 
at com.plateausystems.elms.util.helper.DBUtil.executeUpdateSQL(DBUtil.java:1088) 
at com.plateausystems.elms.util.helper.DBUtil.executeUpdateSQL(DBUtil.java:1016) 
at com.plateausystems.elms.bo.student.helper.StudentDAOImpl.updateStudent(StudentDAOImpl.java:9208) 
at sun.reflect.GeneratedMethodAccessor2211.invoke(Unknown Source) 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 
at java.lang.reflect.Method.invoke(Method.java:606) 
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) 
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at com.sun.proxy.$Proxy738.updateStudent(Unknown Sour

Environment

SAP Successfactors Learning Management System (LMS) All Versions

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.

See Also

LRN-50944

Keywords

not nullable; fulltime; supervisor not updated; ERROR: Not nullable "FULLTIME" column , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning 1811