ERROR

Invalid SQL syntax

Last Published: April 25, 2020

Error Message

ArcMap Error:
The Create Feature task could not be completed.
Invalid SQL syntax() [owner.tablename]

Cause

The sde.states table has become too large (too many rows). To process the Create Features task, ArcSDE queries this table; the resulting query statement exceeds an Oracle query size limitation.

Solution or Workaround

This issue was fixed in version 8.1, so the best solution is to upgrade. In the meantime it is possible to temporarily eliminate the error by following these steps:

  1. Back up the entire database.
  2. Compress the database.
  3. Execute the query.

Article ID:000002456

Software:
  • ArcMap 8 x

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

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options