Adaddnode.Pl Fails With Ora-00001: Unique Constraint (Applsys.Ad_appl_tops_u2) Violated
(Doc ID 1435834.1)
Last updated on MAY 16, 2024
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.
Symptoms
On Oracle Applications release 11.5.10.2,
when attempting to run adaddnode.pl the following error occurs:
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 -
(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
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
Changes
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 |
| Changes |
| Cause |
| Solution |