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 Management System (LMS) - All Supported Versions
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 from saving the 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. In release 1611, the Engineering Team 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, Re-Synchronization AP_ID of Handler, (Remove Student) failed due to the exception, 1611 , KBA , LOD-SF-LMS-ASP , Assignment Profile , LOD-SF-LMS-APM , Automatic Processes , Problem