SAP Knowledge Base Article - Public

2674706 - Merge Issue Error upon clicking Items Completed


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

  1. Navigate to User > Tools > Merge Users.
  2. Select a 'Merge From' User ID which has completed over 21846 items.
  3. Select any new 'Merge Into' User ID.
  4. 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.

See Also

LRN-38557 & LRN-40801


SF Learning LMS mark (?,?) ? ORA-00920 , KBA , LOD-SF-LMS-IMP , Issue , LOD-SF-LMS-ADM , Admin Tools , Problem


SAP SuccessFactors Learning all versions