Solution - ArcFM - Oracle Errors When Adding Domain to Field in ArcFM 10.2.1

Version 5

    Behavior

     

    The following error message is displayed when attempting to add a domain to a feature class field in ArcCatalog:


    Unable to alter the field's domain.

    Underlying DBMS error [ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

    ORA-20085: Insert Spatial Reference SRID 4326 does not match SDE.GDB_ITEMS.SHAPE registered Spatial Reference SRID 0

    ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2000

    ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 2372


    No errors are written to the Miner event log.

     

    Cause

     

    This is caused by an ESRI bug, NIM099594:

     

    Oracle errors, ORA-29877, ORA-20085 and ORA-06512 are encountered when attempting to make object schema changes, spatial index changes, add Global IDs, registering data as versioned (Register as Versioned tool), or creating a raster dataset in ArcCatalog after upgrading certain ArcSDE 10.0 Oracle geodatabases. http://support.esri.com/en/knowledgebase/techarticles/detail/42335

     

    NIM099594 is described here: http://support.esri.com/en/knowledgebase/techarticles/detail/42335


    Solution

     

    ESRI has fixed this issue in a patch available here: ArcGIS 10.2.1 for (Desktop, Engine, Server) Spatial Reference Consistency Patch | Samples and Utilities.