SAP Knowledge Base Article - Public

2665256 - Assignment Profile Synchronization APM is completing with errors

Symptom

After the Assignment Profile Synchronization automatic process runs, the status for "Last Execution Result" field shows Completed with errors.

If you check the error logs, you will see an error similar to this:

Re-Synchronization AP_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:2583)
at sun.reflect.GeneratedMethodAccessor2101.invoke(Unknown Source)

Caused by: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

Re-Synchronization AP_ID of Handler (Add Students) failed due to the exception 
com.plateausystems.elms.util.helper.ElmsFinderException: Cannot find the students getAddStudListForAssignmentProfile(...)
at com.plateausystems.elms.bo.assignmentprofile.impl.AssignmentProfileServiceImpl.getAddStudListForAssignmentProfile(AssignmentProfileServiceImpl.java:2622)
at sun.reflect.GeneratedMethodAccessor2102.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Caused by: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

Environment

SuccessFactors Learning

Cause

There are Assignment Profiles where an ATTRIBUTE is defined, OPERATOR is defined but not the VALUE.

For example: An Assignment Profile is configured with the rule UserID matches 'Employee123'

UserID is the attribute, matches is the operator and 'Employee123' is the value. For this error to happen, the value must be missing.

If you try to reproduce this now, the system will prevent you to save changes without adding a value to the rule, so in case you are seeing this error, you configured the rules for your AP before LMS was enhanced to prevent this scenario. On release 1611, Engineering Team also enhanced the Assignment Profile logic code to increase its performance, which is why this error happens now.

Resolution

The error message will give the Assignment Profile ID that have this problem.

An administrator need to check these Assignment Profiles and correct the rules as per their requirements.

Keywords

LRN-14472, ORA-00903, invalid table name, assignment profile , KBA , LOD-SF-LMS-ASP , LMS AP , Problem

Product

SAP SuccessFactors Learning all versions