2954162 - Account Merging Error in new HTML5 Learning Admin

When merging in new admin UI, receive the following error:

Error message = SqlMapClient operation; uncategorized SQLException; SQL state [HY000]; error code [287]; --- The error occurred while applying a parameter map. --- Check the MergeStudents.updateSharedQualCpntAssignments-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [287]: cannot insert NULL or update to NULL: ONLINE_LAUNCHED

SAP SuccessFactors Learning b2005+

Merge 2 users and receive the error and also note related observed behavior:

Issue 1:
User-1 has some item-1 assigned, item-2 completed and a curricula with an item (item-3)
Now, User-1(Merge from) is merged into User-2 (Merge into)

Expected behaviour:
User-2 should have item-1 assigned, item -2 completed and a curricula with an item (item-3) in assigned state

Observed behaviour:
User-2 has item-1 assigned, item -2 completed but curricula still remains under inactivated User-1's and is not moved to User-2

Issue 2:
User-1 has some item-1 assigned, item-2 completed and a curricula with an item (item-3) that is completed which means that the curricula is in complete state
Now, User-1(Merge from) is merged into User-2 (Merge into)

Expected behaviour:
User-2 should have item-1 assigned, item -2 completed and a curricula with an item (item-3) in complete state

Observed behaviour:
User-2 has item-1 assigned, item -2 completed and a curricula with an item (item-3) in incomplete state

Due to null values allowed previously on online content launched/access instead of Y/N; the error is presented in the merge process, but does not prevent proper merging.

You can simply ignore this error (or workaround to perform merge via legacy admin UI) and use reporting tools to compare users learning plan & completions for entities associated to each user and manage changes as needed.

INC0065248

sap sf success factors learning merge user users item error cannot insert NULL or update online_launched online launched last access , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem