NIM095988 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM095988
Submitted	October 21, 2013
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.1
Version Fixed	10.3.0
Status	Fixed

Description

NIM095988 - After dropping the spatial index on a feature class in a geodatabase that was upgraded to ArcGIS 10.1 or later, insert or update operations return an ORA-20085 error:

"ORA-20085: Insert Spatial Reference SRID 4326 does not match gis.parcels.SHAPE registered Spatial Reference SRID 2"

The issue exists in ArcGIS 10.2.2, 10.2.1, 10.2 and 10.1 SP1 QIP.

The Spatial Reference Consistency patches for ArcGIS 10.1 SP1 QIP, 10.2.1 and ArcGIS 10.2.2 (Desktop, Engine, Server) have been released:

• Spatial Reference Consistency patch for ArcGIS 10.1 SP1 QIP

• Spatial Reference Consistency patch for ArcGIS 10.2.1

• Spatial Reference Consistency patch for ArcGIS 10.2.2

Cause

When dropping a feature class's spatial index, the layer's properties in the geodatabase data dictionary are updated to reference the incorrect spatial reference.

One can encounter this issue if the st_geometry layer had been created prior to ArcGIS 10.1 and shares a spatial reference definition similar to one of the many standard EPSG spatial references.

Once the data dictionary's properties for the layer are inconsistent, users are no longer able to insert and update geometries, and encounter the ORA-20085 error.