SAP Knowledge Base Article - Public

2674706 - Merge Issue Error upon clicking Items Completed

Symptom

Question marks '?' displayed in error box when clicking on completed items for User after being merged.

MergeError.png

Environment

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'.

Cause

  •  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

Resolution

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

Keywords

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

Product

SAP SuccessFactors Learning all versions