Error: Invalid SQL syntax
The Create Feature task could not be completed.
Invalid SQL syntax() [owner.tablename]
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:
- Back up the entire database.
- Compress the database.
- Execute the query.