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
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