ERROR

The features could not be deleted. Failed to delete relationships for object. The field is not nullable

Last Published: September 1, 2021

Error Message

When deleting a feature from an origin feature class in a simple relationship, the following error may occur:

"The features could not be deleted.
Failed to delete relationships for object. [GIS.Address] The field is not nullable. [STREET_NAME_ID]"

Cause

This error occurs if the foreign key of the relationship has a Not Null constraint. When an origin feature is deleted, the relationship it had with the destination feature must be broken. This is accomplished automatically by setting the value for the foreign key to Null.

Solution or Workaround

Remove the Not Null constraint from the relationship's foreign key. See: Modify field properties.

Article ID:000007608

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic