ELM 9.X: JOBCODE_FULL SYSNC Message Receive Error Message "Cannot Insert Duplicate Key Row in Object " (Doc ID 2183095.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 Receiving SQL error message for JOBCODE_FULLSYNC message.

ERROR:
 
"can not insert duplicate key row in object 'dbo.PS_LM_JOBCODE_TBL'"

For example using Microsoft SQL:
Function: SQLExec Error Position: 0 Return: 805 - [Microsoft][SQL
Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object
'dbo.PS_LM_JOBCODE_TBL' with unique index 'PS_LM_JOBCODE_TBL'. The duplicate
key value is (7, , , ). Statement: UPDATE
PS_LM_JOBCODE_TBL SET LM_JOBCODE_ID=:1 WHERE LM_HR_SETID=:2 AND
LM_HR_JOBCODE=:3 AND LM_JOBCODE_ID=0 Original Statement: UPDATE
PS_LM_JOBCODE_TBL SET LM_JOBCODE_ID=:1 where LM_HR_SETID=:2 and
LM_HR_JOBCODE=:3 and LM_JOBCODE_ID=0


Steps to replicate the Issue:

1)  Integrate JOBCODE_FULLSYNC between HCM and ELM

2) Run the Fullsync Process in HCM and trigger JOBCODE_FULLSYNC messages.

3) In the ELM application notice JOBCODE_FULLSYNC receives ab error message.
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms