Question marks '?' displayed in error box when clicking on completed items for User after being merged.
SAP SuccessFactors Learning Management System (LMS)
Reproducing the Issue
- Navigate to User > Tools > Merge Users.
- Select a 'Merge From' User ID which has completed over 21846 items.
- Select any new 'Merge Into' User ID.
- After merging user, go into merged user profile and click on 'Items Completed'.
This is due to the bind parameters limitation intrinsic to the database level.
When viewing application logs can see Java Stack error:
Failure: [FaultEvent fault=[RPC Fault faultString="com.plateausystems.elms.framework.snapshot.api.SnapshotException : org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar
- ORA-00920 error
Resolved in redesign of LMS Admin GUI in version 1811 to utilize temp tables not available for current UI design.
LRN-38557 & LRN-40801
SF Learning LMS mark (?,?) ? ORA-00920 , KBA , LOD-SF-LMS-IMP , Issue , LOD-SF-LMS-ADM , Admin Tools , Problem