2826047 - Program Key Constraint on merging user records with programs

Symptom

Admin attempts to merge users with assigned programs but receives a stack trace instead

Environment

SAP SuccessFactors Learning

Reproducing the Issue

1] Go to Learning Administration

2] Users > Merge Users then attempt to Merge 2 Users

Receive this error below

Error message = [301]: unique constraint violated: TrexUpdate failed on table 'SCHEMANAME:PA_STUD_PROGRAM' with error: unique constraint violation for table SCHEMANAME:PA_STUD_PROGRAMen, constraint='$uc_UK_STUD_PROGRAM$', value='########', pos=8; indexname=UK_STUD_PROGRAM, rc=55; nested exception is com.sap.db.jdbc.exceptions.SQLIntegrityConstraintViolationExceptionSapDB: [301]: unique constraint violated: TrexUpdate failed on table 'SCHEMANAME:PA_STUD_PROGRAM' with error: unique constraint violation for table SCHEMANAME:PA_STUD_PROGRAMen, constraint='$uc_UK_STUD_PROGRAM$', value='######', pos=8;

Cause

There is sequencing data issue

Resolution

Unassign the Program from the User (and reassign if needed) and then Merge the Users

Keywords

User merge, program error, stack trace, Caused by: com.plateausystems.elms.framework.mergestudent.helper.MergeStudentsDAOImpl$4: [301]: unique constraint violated: TrexUpdate failed on table , KBA , LOD-SF-LMS-USR , User Entity , Problem

Product

SAP SuccessFactors Learning all versions