Is This Content Helpful?
We're glad to know this article was helpful.
When attempting to draw a layer, ArcMap returns the following error:
"One or more layers failed to draw:..."
After dismissing this error message, either a layer or the layer's labels do not draw. This message may also appear when trying to open a layer's attribute table.
There may be more than one reason why this message occurs. One possible reason is that the data source type of an ArcMap layer has been changed to a type that has a different SQL syntax. A common example is when a layer's data source is changed from a shapefile to a geodatabase feature class or vice versa, and that layer has a definition query.
Common layer SQL queries include: definition queries, SQL expressions used for multiple label classes, and symbology exclusion expressions.
After repairing/changing the layer's data source, update all layer SQL queries.
Note: If unsure about the syntax, use the Query Builder to build a query based on the new data source type.
Note: This dialog box is found in different places depending on what type of symbology is being used. If Single Symbol symbology, click the Exclude button. If Graduated Colors symbology, click Classify, then Exclusion.