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:

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

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