ETL9.2 TL_ST_LOADER Process Fails Due To Unable To Insert Duplicate Key Row In Object PS_MESSAGE_LOG (Doc ID 2096024.1)

Last updated on JUNE 12, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE STATEMENT
----------
TL_St_LOADER Failed with error Cannot insert duplicate key row in object 'dbo.PS_MESSAGE_LOG' with unique index 'PS_MESSAGE_LOG'. The duplicate key value is (1416015, 5).

ENVIRONMENT:
------------
PeopleSoft HCM 9.2
PeopleTools 8.54
SQL Server

ACTUAL BEHAVIOR
-----------
TL_ST_LOADER process fails due to unable to insert duplicate key row in object PS_MESSAGE_LOG

Problem Description
---------------------------------------------------
TL_ST_LOADER goes to Not Successful due to following error

Stmt #: 1228 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_MESSAGE_LOG' with unique index 'PS_MESSAGE_LOG'. The duplicate key value is (1416015, 5).
Failed SQL stmt: INSERT INTO PS_MESSAGE_LOG (PROCESS_INSTANCE, MESSAGE_SEQ, JOBID, PROGRAM_NAME, MESSAGE_SET_NBR, MESSAGE_NBR, MESSAGE_SEVERITY, DTTM_STAMP_SEC) VALUES(:1, :2, :3, :4, :5, :6, :7, GETDATE())
PSAESRV.3776 (722) [2015-12-18T08:40:36.223](3) RunAeAsync service request completed unsuccessfully -- Application ID=TL_ST_LOADER Process Instance=1416015

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