RUNNING MAINTAIN SNAPSHOT INFORMATION FAILED WITH ORA-00001: unique constraint (APPLSYS.AD_SNAPSHOT_BUGFIXES_U2) violated (Doc ID 968753.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Application Install - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 27-Apr-2011***
***Checked for relevance on 10-May-2013***

Symptoms

On 11.5.10.2 / 10g or 11g database
When attempting to run adadmin / "Update current view snapshot" under "Maintain Snapshot Information", the following error occurs.

ERROR
-----------------------

Completed Processing Snapshot Info

sqlplus -s &un_apps/***** @$AD_TOP/11.5.0/patch/115/sql/adphsnbr.pls <appl top name> 
ALL

PL/SQL procedure successfully completed.


APPL_TOP Name: <appl top name>
Mode : ALL


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Updating tables...
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_SNAPSHOT_BUGFIXES_U2) violated
ORA-06512: at line 164



An error occurred while Running adphsnbr.pls.
Continue as if it were successful [No] : No

sqlplus -s APPS/APPS @$AD_TOP/patch/115/sql/adphsnbr.pls <appl top name> ALL
.The above command failed with error code 1.

AD Administration error:
Error calling adusnapUpdateSnapshotAllBugFixes()

Failed to store APPL_TOP Snapshot to tables
adusnapMaintainSnapshot() : Error calling adusnapUpdateCurrentView()
Error calling adusnapMaintainSnapshot

Changes

Database 10g or 11g

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