AnsweredAssumed Answered

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

Question asked by bian.fil on Jul 3, 2017
Latest reply on Jul 5, 2017 by RRobichaux-esristaff

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,