SAP Knowledge Base Article - Public

2691857 - Error generated by Assignment Profile Synchronization automatic process

Symptom

When the Assignment Profile Synchronization is run, while it completes successfully, the following error is reported:

Re-Synchronization AP_ID=<assignment profiled ID> of Handler (Remove Student) failed due to the exception
com.plateausystems.elms.util.helper.ElmsFinderException: cannot find the students getRemoveStudListForAssignmentProfile(...)
at com.plateausystems.elms.bo.assignmentprofile.impl.AssignmentProfileServiceImpl.getRemoveStudListForAssignmentProfile(AssignmentProfileServiceImpl.java:2578)
at sun.reflect.GeneratedMethodAccessor2129.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 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.framework.localization.DataLocalizationInterceptor.invoke(DataLocalizationInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at com.sun.proxy.$Proxy538.getRemoveStudListForAssignmentProfile(Unknown Source)
at com.plateausystems.elms.bo.assignmentprofile.impl.SynchronizeAssignmentProfileRemoveStudentHandlerImpl.getSynchronizeAssignmentProfileEntityData(SynchronizeAssignmentProfileRemoveStudentHandlerImpl.java:36)
at com.plateausystems.elms.bo.assignmentprofile.helper.AssignmentProfileJobsHelperImpl.executeReSyncAssignmentProfileHandler(AssignmentProfileJobsHelperImpl.java:84)
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 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)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

Environment

SuccessFactors Learning Management System (LMS) - All Supported Versions

Reproducing the Issue

  1. Naviagte to System Admin > Automatic Processes > Assignment Profile Synchronization
  2. Note the Last Execuation Result value is set to Completed with errors
  3. Selecting the View Errors button will generate the error as outlined

Alternativitly you may generate a similar error in the following way

  1. Naviagte to Users > Assignment Profiles > search for Assignment Profile ID mentioned in the error message
  2. Go to Manage Rules > Preview Users in Assignment Profile

error.jpg

Cause

There is a value configuration within the rule of the Assignment Profile which have no values assoicated to it, just the attribute and the rule. For example note the screenshot below which has no values selected for the Known As attribute.

error 1.jpg

Resolution

You will need to either update the Assignment Profile rule and enter in a value or delete the rule altogether.

Once you have made a selection, the next time the Assignment Profile Synchronization automatic process runs the error message should not generate any more.

Keywords

Re-Synchronization AP_ID, Handler (Remove Student) failed due to the exception, Caused by: java.sql.SQLSyntaxErrorException, ORA-00903, invalid table name, Assignment Profile Synchronization, automatic process , KBA , LOD-SF-LMS-ASP , LMS AP , LOD-SF-LMS-AMP , Automatic Processes , Problem

Product

SAP SuccessFactors Learning all versions