Bug:  Unable to insert or update Oracle st_geometry feature classes, encountering ORA-20085 errors

相关信息
Article ID: 42461
Bug Id: NIM095988
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2, 10.1 SP1
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2, 10.1 SP1
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2, 10.1 SP1
ArcGIS for Server 10.1, 10.2, 10.2.1
ArcGIS Engine for Linux 10.1, 10.2, 10.2.1, 10.2.2, 10.1 SP1
Platforms: N/A

BUG描述
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

BUG原因
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.
已邀请:

易智瑞技术支持

赞同来自:

解决方案
The workaround for NIM095988 is to install the 10.1 SP1 QIP, 10.2.1 or 10.2.2 Spatial Reference Consistency Patch.




    创建及修改时间
    Created: 4/23/2014

    Last Modified: 7/22/2014
    原文链接
    http://support.esri.com/en/kno ... 42461

    要回复问题请先登录注册