Bug
When using a Definition Query longer than 4095 characters against a 9.0 ArcSDE Server, the data fails to draw and the following error is returned: "One or more layers failed to draw."
| Bug ID Number | NIM031030 |
|---|---|
| Submitted | January 4, 2008 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 9.2 |
| Version Fixed | 9.4 |
| Status | Fixed |
Workaround
1. Consider making use of alias against long names of featureclass/columns. This way you may be able to give some more character length for your query.2. Consider breaking down the query in smaller selection sets. For Ex. the resultant selection set of principle query may be stored as a new featureclass and the subquery may be designed to run on this new selection set. This way, you may again be able to give some more character length for your query.Steps to Reproduce
Bug ID: NIM031030
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App