laptop and a wrench


The following error is returned: "One or more layers failed to draw: An invalid SQL statement was used" after applying a definition query on a joined feature class in an ArcSDE 10.2.x Oracle geodatabase, connected with a three-tier connection in ArcGIS Desktop 10.0 SP5.

Last Published: December 14, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000092891
SubmittedDecember 9, 2015
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.2
Version Fixed10.1

Additional Information

Issue does not occur at ArcGIS DT 10.1 and also is not reproducible using direct connections. Please contact Support services if this issue is still being encountered in a current version.


Use the default connection type for database connections (direct connect).

Steps to Reproduce

Bug ID: BUG-000092891


  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options