AnsweredAssumed Answered

FIDs must not be negative ORA-00001 issue

Question asked by spatialtech on Mar 10, 2015

Hello,

We are attempting to compress our system (Oracle 11g/SDE 10.0/ArcGIS Server 10.0) back to a zero state.  However,

when we try to reconcile, one table gives us errors: ORA-00001: unique constraint (XXXX.A836_PK) violated 'FIDs must not be negative'.

 

This table has been registered with the geodatabase, versioned and a versioned view has been created, but it does not contain shapes.  It is a stand alone table.

 

The table has an ObjectID column which does not contain any 0s, negative, or NULL values. We have searched the base and add/delete tables, but cannot find any inconsistencies.

 

Any suggestions on how to move forward are welcome. 

 

Thanks in advance, Jewell Brannigan

Outcomes