laptop and a wrench

Bug

Select by Attributes fails to execute in ArcMap 10, when using a long expression, with the following error message, "General function failure, Query too complex ".

Last Published: August 25, 2014 ArcGIS for Desktop
Bug ID Number NIM066871
SubmittedApril 5, 2011
Last ModifiedMarch 19, 2025
Applies toArcGIS for Desktop
Version found10.0
Operating SystemWindows OS
Operating System VersionXP
StatusNon-Reproducible

Additional Information

No Public Explanation

Workaround

Remove the spaces from the field using LTrim and RTrim commands. Reformat the query to select multiple values from the same Field, [FieldName] IN ('4189', '4190', '4191').

Steps to Reproduce

Bug ID: NIM066871

Software:

  • ArcGIS for Desktop

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