ERROR

One or more layers failed to draw: Invalid SQL syntax[]

Last Published: April 25, 2020

Error Message

Note:
This article pertains to ArcGIS versions 8.x. Later versions of ArcGIS may contain different functionality, as well as different names and locations for menus, commands and geoprocessing tools.

Clicking the OK button on the Add Route Events or Display Route Events dialog to display events on ArcSDE for Coverages data produces an error:

"One or more layers failed to draw: Invalid SQL syntax[]"

Cause

The Dynamic Segmentation algorithm passes many SQL queries to the ArcSDE for coverages database when attempting to display route events. To improve performance, the display algorithm needs to parse many route key values together when constructing the necessary SQL statements. If your route key field is defined as character or double, you can potentially have very long route and event key values.

ArcSDE for Coverages SQL syntax has a limit of 320 characters and when using route keys with very long values, the SQL expression created can easily surpass this limit.

Solution or Workaround

Use route keys with shorter values.

Article ID:000003419

Software:
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic