My Oracle Support Banner

E-UPG: Cannot insert duplicate key row in object 'dbo.PS_MAINTENANCE_LOG' with unique index 'PS_MAINTENANCE_LOG'. The duplicate key value is (887901, ). (Doc ID 2399886.1)

Last updated on MAY 29, 2018

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

On : PT 8.55 version, PeopleSoft Update Manager

Receiving error at updating PeopleTools patch step during the People tools upgrade

Receiving below error at updating PeopleTools patch step during the People tools upgrade

Error: SQL execute error for INSERT INTO PS_MAINTENANCE_LOG ( UPDATE_ID, DESCR, FIXOPRID, APPLYOPRID, PRODUCT_LINE, MAINTLOGTYPE, RELEASELABEL) VALUES ( '887901', 'Patch for PeopleTools 8.52.12', 'PPLSOFT', 'PPLSOFT', ' ', 'USR1', 'PeopleTools 8.52.12.000')
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_MAINTENANCE_LOG' with unique index 'PS_MAINTENANCE_LOG'. The duplicate key value is (887901, ).
Ended: Wed May 9 22:15:19 2018
Unsuccessful completion

ERROR
-----------------------
Error: SQL execute error for INSERT INTO PS_MAINTENANCE_LOG ( UPDATE_ID, DESCR, FIXOPRID, APPLYOPRID, PRODUCT_LINE, MAINTLOGTYPE, RELEASELABEL) VALUES ( '887901', 'Patch for PeopleTools 8.52.12', 'PPLSOFT', 'PPLSOFT', ' ', 'USR1', 'PeopleTools 8.52.12.000')
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.PS_MAINTENANCE_LOG' with unique index 'PS_MAINTENANCE_LOG'. The duplicate key value is (887901, ).
Ended: Wed May 9 22:15:19 2018
Unsuccessful completion




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Change Assistant
2. PT 8.55.18 to PT 8.56.01 upgrade template
3. Updating PeopleTools patch information

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!


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