My Oracle Support Banner

E-COMP : ORA-00001: unique constraint (SYSADM.PS_PSPROJECTWORK) violated SQL stmt: INSERT INTO PSPROJECTWORUE (62,16) When Doing a Full Database Compare (Doc ID 2682933.1)

Last updated on JUNE 22, 2020

Applies to:

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

Symptoms

During full database compare, compare reports fails and it shows the following error,


Records Application Upgrade Compare started: 2020-06-17-07.10.55 (62,6)

System Error : File: E:\PT858P03C_2004081648-retail\peopletools\src\psprj\upgrade.cppSQL error. Stmt #: 3130 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PSPROJECTWORK) violated SQL stmt: INSERT INTO PSPROJECTWORUE (62,16)
Internal Error: invalid transaction handle instance passed from SamDestroy 0: 795 vs 0
Records Compare Report Created : c:\temp\HRUPG_2_HRUPGPT\Upg00Records.prt (75,9)
Browser Compare Report Created : c:\temp\CompareViewer.html (75,19)




The issue can be reproduced at will with the following steps:


1. Upgrade tools and PUM upgrade from 8.55 to 8.58 and PUM31 to PUM34 respectively.
2.. Perform a full DB compare from one to other environment.
3. Above error shows up when the compare starts.


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


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