My Oracle Support Banner

Apply PUM Updates has Step "Copying ADS MO Project From File - IP" Failed with "...Cannot insert duplicate key row in object 'dbo.PS_EOWC_ADM_INSTBL' with unique index 'PS_EOWC_ADM_INSTBL'. The duplicate key value is (GP_WC)...." (Doc ID 3054102.1)

Last updated on JANUARY 21, 2025

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When applying PUM Image updates from PUM 47 to PUM 49, the step "Copying ADS MO Project From File - IP" failed with the following error message:

Failed SQL stmt: INSERT INTO PS_EOWC_ADM_INSTBL(PAGELET_CONFIG_ID, ENABLE_PERSONALIZE, ENABLE_USR_ADD_LNK, LAST_RUN_DTM, LAST_RUN_OPRID, LAST_UPDATE_DTM, LASTUPDOPRID) VALUES(:1, :2, :3, :4, :5, :6, :7)
Message Set Number: 200
Message Number: 0
Message Reason: File: C:\PT861P03X_2405091450-retail\peopletools\src\psapmsg\cscrollprocessing.cppSQL error. Stmt #: 489 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_EOWC_ADM_INSTBL' with unique index 'PS_EOWC_ADM_INSTBL'. The duplicate key value is (GP_WC).
Failed SQL stmt: INSERT INTO PS_EOWC_ADM_INSTBL(PAGELET_CONFIG_ID, ENABLE_PERSONALIZE, ENABLE_USR_ADD_LNK, LAST_RUN_DTM, LAST_RUN_OPRID, LAST_UPDATE_DTM, LASTUPDOP (200,0)
Error: Unable to copy data set content to database. Copy from file failed (257,164)

Message Set Number: 257
Message Number: 164
Message Reason: Error: Unable to copy data set content to database. Copy from file failed (257,164)
Copy From File failed (257,112)
Message Set Number: 257
Message Number: 112
Message Reason: Copy From File failed (257,112)
End Application Engine Process (257,402)
Application Engine program PTADSAEPRCS ended normally

The issue can be reproduced at will with the following steps:
1. Prepare the environment for the PUM udpate
2. Create the Change Package
3. Run the step "Copying ADS MO Project From File" in Change Asssitant

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.