laptop and a wrench

Bug

Creating a query layer using the field list and a where clause on an Oracle spatial table results in features not being returned, and opening attribute table fails with the error: "ORA-29902: error in executing ODCIIndexStart() routine."

Last Published: October 17, 2016 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000098514
SubmittedAugust 11, 2016
Last ModifiedJune 3, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.4.1
Version Fixed10.5.0
StatusFixed

Workaround

For ArcMap, removing the M and Z values from the query layer or removing the Where cause does not cause the error.

Steps to Reproduce

Bug ID: BUG-000098514

Software:

  • ArcSDE/Enterprise Geodatabase

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