ERROR

Failed to add one of the specified fields. The field is not nullable

Last Published: April 25, 2020

Error Message

In some instances, when adding a field to a feature class or table with a field property 'Allow NULL values = No', the following error is returned:

Error:   
Failed to add one of the specified fields. The field is not nullable.

Cause

The feature class or table contains at least one feature or row. Fields with 'Allow NULL values = No' can only be added to empty feature classes or tables.

Solution or Workaround

The instructions provided describe a solution for this error by re-creating a new feature class or table.

  1. In the Catalog pane, right-click the geodatabase > New > Feature Class.
  2. In the New Feature Class dialog box, set the Name and select the correct Type for the feature class, as well as the coordinate system.
    New Feature Class dialog box
  3. Click the Next button until the table of Field Name and Data Type appear, and click the Import button.
    Import the feature class
  4. In the Browse for table/feature class dialog box, select the desired feature class to add, and click Add.
    Add the feature class
  5. Select Field Name in the table. In the New Feature Class dialog box, set Allow Null values to No, and click Finish.
    Select No for Allow NULL values
  6. In the Catalog pane, right-click the new feature class created and select Load > Load Data.
  7. In the Simple Data Loader dialog box, browse to the original feature class in the Input data, and click Add > Next > Next > Next > Next > Finish.
    Load feature class
The data is added to the new feature class, which contains the field that does not allow NULL values.
A feature class and attribute table which contain no NULL values

Article ID:000010006

Software:
  • ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic