EGL9.2: CA Step 'Copying Update Project - Part2' Fails With "Cannot insert duplicate key row in object 'dbo.PSAESTMTDEFN' with unique index 'PS_PSAESTMTDEFN'" Error

(Doc ID 2382330.1)

Last updated on APRIL 04, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Microsoft SQLServer - Version 2005 to 2016
Information in this document applies to any platform.

Symptoms

Issue:
-------
While applying 9.2 PI 21 or higher on a lower 9.2 PUM image level CA step 'Copying Update Project - Part2' failed if


Steps to Replicate:
---------------------
1. Create upgrade change package with make me current option
2. Apply change package with help of change assistant


Error:
------

File: E:\pt85515b-retail\peopletools\src\pssys\aesupd.cppSQL error. Stmt #: 1040 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PSAESTMTDEFN' with unique index 'PS_PSAESTMTDEFN'. The duplicate key value is (AMR_JRNL_GEN, PrcsReq, GBL, , Jan 1 1900 12:00AM, updReq, C).
Failed SQL stmt: INSERT INTO PSAESTMTDEFN (AE_APPLID, AE_SECTION, MARKET, DBTYPE, EFFDT, AE_STEP, AE_STMT_TYPE, AE_REUSE_STMT, AE_DO_SELECT_TYPE, SQLID, DESCR) VALUES(:1, :2, :3, :4, :5, :6, :7, 'N', 'F', ' ', :8)

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