Ora 00001: unique constraint (SDE.R5_SDE_ROWID_UK) violated. SDE.GDB_Item Relationships

[filippobianchini1]

Hi all, 

I am currently trying to create a new feature class in my Oracle SDE geodatabase and I get this error: "Underlying DBMS error[Ora 00001: unique constraint (SDE.R5_SDE_ROWID_UK) violated] [SDE.GDB_Item Relationships]". 

I have tried to align the sequences following these steps:

1) check from table TABLE_REGISTRY the REGISTRATION_ID of SDE.GDB_Item Relationships table by issuing the query "SELECT REGISTRATION_ID FROM TABLE_REGISTRY WHERE TABLE_NAME = 'GDB_ITEMRELATIONSHIPS'". the query returned 5.

2) I moved forward the sequence SDE.R5 till value > the maximum value of the objectid of GDB_ITEMRELATIONSHIPS.

3) In ArcCatalog i tried to create again a feature class without succeding. it returned the same error.

Any advice? 

Thanks in advance, 

                                    Filippo

[RexRobichaux2]

Hello Filippo,

 Is this the workflow you followed to check and advance the sequence? Error: Underlying DBMS error (ORA-00001: Unique constraint (SDE.GDB_OC_PKC) violated) 

Alternatively, can you try creating a dummy table in Oracle through SQL Plus with the same user / schema that you are attempting to use to create a new feature class in ArcMap / Catalog? Just something simple like:

CREATE TABLE <your_feature_class_name>(id int);

Then, refresh your connection in Catalog and see if this new table appears in the gdb table of contents. If it does, delete it through Catalog- then re-try creating the feature class in Catalog. I'm wondering if there was once a FC with this name and it has become orphaned in some of the gdb repository system tables. I hope this helps!

Best,

Rex R