ERROR

<layer name>: An invalid SQL statement was used

Last Published: January 3, 2024

Error Message

In ArcGIS Pro 3.2 and later, when zooming in to the feature layer created from a CSV file, the point features are not displayed, returning a drawing alert notification. Clicking the drawing alert notification returns the following error message:

Error:
<layer>: An invalid SQL statement was used.
Drawing alert error message.png

Cause

The X and Y coordinate field names in the referenced CSV file contain spaces or special characters.

Solution or Workaround

In the CSV file, ensure the field names do not include special characters or spaces.

  • Remove special characters from the field names.
  • Replace spaces in the field names with underscores.

Article ID:000031665

Software:
  • ArcGIS Pro 3 2

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options