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.
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.
1 个回复
易智瑞技术支持
赞同来自:
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
要回复问题请先登录或注册