Adaddnode.Pl Fails With Ora-00001: Unique Constraint (Applsys.Ad_appl_tops_u2) Violated (Doc ID 1435834.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Applications Manager - 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 8-Dec-2016

Symptoms


On Oracle Applications release 11.5.10.2,
when attempting to run adaddnode.pl the following error occurs:

Enter the APPS username: apps

Enter the APPS user password:
Using CONTEXT_FILE : $CONTEXT_FILE
Using CTXORIG : $COMMON_TOP/clone/bin/../context/apps/CTXORIG.xml
APPL_TOP name of the source system (old APPL_TOP name) : <old_node>
APPL_TOP name of the target system (new APPL_TOP name) : <new_node>
Configuring snapshot information for the original (clone source) node...
Executing command:
sqlplus /nolog @$AD_TOP/patch/115/sql/adadmrat.sql APPS password <old_node> 
<old_node>  <new_node> <old_node>  $COMMON_TOP/temp/adadmat_sql.spool

SQL*Plus: Release 8.0.6.0.0 - Production on

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connected.

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Current data
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


APPL_TOP Names in AD_APPL_TOPS:


*PRESEEDED*
GLOBAL
<old_node>
<new_node> 

3 rows selected.


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

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


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Error configuring snapshot information for the source node...cannot proceed with adding the node



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