2629346 - Assignment Profile Synchronization exception: "java.lang.NullPointerException: while trying to invoke the method java.sql.Timestamp.getTime() of a null object loaded from local variable 'ts'"

SAP Knowledge Base Article - Public

2629346 - Assignment Profile Synchronization exception: "java.lang.NullPointerException: while trying to invoke the method java.sql.Timestamp.getTime() of a null object loaded from local variable 'ts'"

Symptom

When running Assignment Profile Synchronization a similar error to the following is displayed:

java.lang.NullPointerException: while trying to invoke the method java.sql.Timestamp.getTime() of a null object loaded from local variable 'ts'
at java.sql.Timestamp.compareTo(Timestamp.java:477)
at java.sql.Timestamp.after(Timestamp.java:459)
at com.plateausystems.elms.bo.student.helper.StudentDAOImpl_HANA.batchAddStudentQualification(StudentDAOImpl_HANA.java:202)
at sun.reflect.GeneratedMethodAccessor2198.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.$Proxy154.batchAddStudentQualification(Unknown Source)
at sun.reflect.GeneratedMethodAccessor2198.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.$Proxy155.batchAddStudentQualification(Unknown Source)
at com.plateausystems.elms.bo.assignmentprofile.helper.AssignmentProfileDAOImpl_HANA.processAddStudentQualifications(AssignmentProfileDAOImpl_HANA.java:274)
at com.plateausystems.elms.bo.assignmentprofile.helper.AssignmentProfileDAOImpl_HANA.bulkCreateAssignmentProfileStudent(AssignmentProfileDAOImpl_HANA.java:128)
at com.plateausystems.elms.bo.assignmentprofile.impl.AssignmentProfileServiceImpl.createStudents(AssignmentProfileServiceImpl.java:2328)
at com.plateausystems.elms.bo.assignmentprofile.impl.AssignmentProfileServiceImpl.resyncAssignmentProfileStudents_ADD(AssignmentProfileServiceImpl.java:2527)
at sun.reflect.GeneratedMethodAccessor2201.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.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.perfmonitor.impl.ServicePerformanceMonitorInterceptor.invoke(ServicePerformanceMonitorInterceptor.java:41)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.usagestatistics.impl.UsageStatisticsInterceptor.invoke(UsageStatisticsInterceptor.java:66)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.authorization.impl.ServiceAuthorizationInterceptor.invoke(ServiceAuthorizationInterceptor.java:127)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.util.helper.LastUpdateUserInterceptor.invoke(LastUpdateUserInterceptor.java:49)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at com.plateausystems.elms.framework.localization.DataLocalizationInterceptor.invoke(DataLocalizationInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy205.resyncAssignmentProfileStudents_ADD(Unknown Source)
at com.plateausystems.elms.bo.assignmentprofile.impl.SynchronizeAssignmentProfileAddStudentHandlerImpl.reSyncAssignmentProfileEntity(SynchronizeAssignmentProfileAddStudentHandlerImpl.java:37)
at com.plateausystems.elms.bo.assignmentprofile.helper.AssignmentProfileJobsHelperImpl.executeReSyncAssignmentProfileHandler(AssignmentProfileJobsHelperImpl.java:122)
at com.plateausystems.elms.bo.assignmentprofile.helper.AssignmentProfileJobsHelperImpl.reSynchronizeAssignmentProfile(AssignmentProfileJobsHelperImpl.java:66)
at com.plateausystems.elms.framework.jobscheduling.impl.v2.SynchronizeStudentChangesAssignmentProfileApmJob.resyncStudentChangesAssignmentProfiles(SynchronizeStudentChangesAssignmentProfileApmJob.java:252)
at com.plateausystems.elms.framework.jobscheduling.impl.v2.SynchronizeStudentChangesAssignmentProfileApmJob.execute(SynchronizeStudentChangesAssignmentProfileApmJob.java:144)
at com.plateau.common.jobscheduling.impl.simple.SimpleJobRunnable.run(SimpleJobRunnable.java:95)
at com.plateau.foundation.jobscheduling.TenantAwareJobRunnable.run(TenantAwareJobRunnable.java)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:807)

Environment

SuccessFactors Learning Management System (LMS)

Reproducing the Issue

  1. Go to System Admin->Automatic Processes->Assignment Profile Synchronization;
  2. Click the View Errors button;
  3. The exception will be listed here together with the time stamp.

Cause

There was an error identified in LRN-30813.

Resolution

The issue was fixed as part of version b1802.

Keywords

Assignment Profile, Error, Exception, , KBA , LOD-SF-LMS-ASP , LMS AP , Problem

Product

SAP SuccessFactors Learning 1711