Is This Content Helpful?
We're glad to know this article was helpful.
When adding a topology rule to a topology class stored in ArcSDE for Oracle, the rule is not added. No error messages appear to indicate a failure.
A possible cause is the primary key constraint on the ID column of the GDB_VALIDRULES tables is being violated.
This occurs when the sequence which generates the ID values for this column becomes out of sync with the existing values in the column. This situation does not occur under normal circumstances, but possible causes include improper use of the Oracle import function, an Oracle shutdown during an ArcGIS transaction, or manual manipulation of the ArcSDE metadata tables.
If verbose logging is enabled for the sde.errlog, the following error is returned:
.SDE_Oracle Error: 1
ORA-00001: unique constraint (SDE.GDB_VR_PKC) violated
Advance the sequence to a higher value than the maximum value in the ID column of SDE.GDB_VALIDRULES. Log in to SQLPlus as the SDE user to run the following SQL commands.
SQL>SELECT MAX(id) FROM gdb_validrules;
SQL>SELECT registration_id FROM table_registry WHERE table_name = 'GDB_VALIDRULES';
SQL> select last_number from user_sequences where sequence_name = 'R8';
SQL> select r8.nextval from dual;