ERROR

General function failure (_FeatureClass) - Syntax error in query expression

Last Published: April 25, 2020

Error Message

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.

This error occurs when adding a new feature to a feature class in a personal geodatabase in ArcMap:

Create: An unexpexted failure occured
General function failure (_FeatureClass)
Syntax error in query expression '(OBJECTID IN (6) ) AND (_FeatureClass.OBJECTID NOT IN (SELECT OBJECTID FROM DELTA _FeatureClass ) )'.

Cause

The feature class has a leading underscore (_) in its name. This causes queries used for inserting new features to fail.

Solution or Workaround

 

Rename the feature class so it doesn't have an underscore as the leading character.

Article ID:000004275

Software:
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic