topic FIDs must not be negative ORA-00001 issue in Data Management Questions https://community.esri.com/t5/data-management-questions/fids-must-not-be-negative-ora-00001-issue/m-p/41168#M2263 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>We are attempting to compress our system (Oracle 11g/SDE 10.0/ArcGIS Server 10.0) back to a zero state.&nbsp; However,</P><P>when we try to reconcile, one table gives us errors: ORA-00001: unique constraint (XXXX.A836_PK) violated 'FIDs must not be negative'.</P><P></P><P>This table has been registered with the geodatabase, versioned and a versioned view has been created, but it does not contain shapes.&nbsp; It is a stand alone table.</P><P></P><P>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.</P><P></P><P>Any suggestions on how to move forward are welcome.&nbsp; </P><P></P><P> Thanks in advance, Jewell Brannigan</P></BODY></HTML> Tue, 10 Mar 2015 12:42:00 GMT HeidiHughes 2015-03-10T12:42:00Z FIDs must not be negative ORA-00001 issue https://community.esri.com/t5/data-management-questions/fids-must-not-be-negative-ora-00001-issue/m-p/41168#M2263 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>We are attempting to compress our system (Oracle 11g/SDE 10.0/ArcGIS Server 10.0) back to a zero state.&nbsp; However,</P><P>when we try to reconcile, one table gives us errors: ORA-00001: unique constraint (XXXX.A836_PK) violated 'FIDs must not be negative'.</P><P></P><P>This table has been registered with the geodatabase, versioned and a versioned view has been created, but it does not contain shapes.&nbsp; It is a stand alone table.</P><P></P><P>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.</P><P></P><P>Any suggestions on how to move forward are welcome.&nbsp; </P><P></P><P> Thanks in advance, Jewell Brannigan</P></BODY></HTML> Tue, 10 Mar 2015 12:42:00 GMT https://community.esri.com/t5/data-management-questions/fids-must-not-be-negative-ora-00001-issue/m-p/41168#M2263 HeidiHughes 2015-03-10T12:42:00Z