Error: One or more layers failed to draw: Invalid SQL syntax
Clicking the OK button on the Add Route Events or Display Route Events dialog to display events on ArcSDE for Coverages data produces this 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.