laptop and a wrench

Bug

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 ModifiedSeptember 13, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.2
Version Fixed10.1
StatusFixed

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.

Workaround

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

Steps to Reproduce

Bug ID: BUG-000092891

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