laptop and a wrench

Bug

"ST_ORA-29903: error in executing ODCIIndexFetch() routine" is returned when running an st_intersects query against a specific large dataset.

Last Published: August 25, 2014 No Product Found
Bug ID Number NIM086252
SubmittedNovember 5, 2012
Last ModifiedJune 5, 2024
Applies toNo Product Found
Version found10.1
Version Fixed10.2
StatusFixed

Workaround

Make the data's first gridsize larger (change from 370 to 400000):col grid format a30;col srid format 999999;col index_name format a10;col owner format a10;set pages 9999select owner,table_name, index_name, grid, srid from sde.st_geometry_index where table_name='MAPPLUTO';OWNER TABLE_NAME INDEX_NAME GRID(GRID1, GRID2, GRID3) SRID---------- ---------- ---------- ------------------------------ -------GDB MAPPLUTO A6376_IX1 SP_GRID_INFO(370, 0, 0) 300080drop index A6376_IX1;create index A6376_IX1 on MAPPLUTO(shape) indextype is sde.st_spatial_index parameters('st_grids=400000,0,0 st_srid=300080');select owner,table_name, index_name, grid, srid from sde.st_geometry_index where table_name='MAPPLUTO';OWNER TABLE_NAME INDEX_NAME GRID(GRID1, GRID2, GRID3) SRID---------- ---------- ---------- ------------------------------ -------GDB MAPPLUTO A6376_IX1 SP_GRID_INFO(400000, 0, 0) 300080Select now returns correct records.

Steps to Reproduce

Bug ID: NIM086252

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options