Error: One or more layers failed to draw: Invalid SQL syntax
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"
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.