Select to view content in your preferred language

FIDs must not be negative ORA-00001 issue

4275
0
03-10-2015 05:42 AM
HeidiHughes
Deactivated User

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

Tags (2)
0 Kudos
0 Replies