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

Version 5



    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.




    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.


    NIM099594 is described here:



    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.