Error: Failed to add one of the specified fields. The field is not nullable
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:
Failed to add one of the specified fields. The field is not nullable.
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.
The instructions provided describe a solution for this error by re-creating a new feature class or table.
- In the Catalog pane, right-click the geodatabase > New > Feature Class.
- 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.
- Click the Next button until the table of Field Name and Data Type appear, and click the Import button.
- In the Browse for table/feature class dialog box, select the desired feature class to add, and click Add.
- Select Field Name in the table. In the New Feature Class dialog box, set Allow Null values to No, and click Finish.
- In the Catalog pane, right-click the new feature class created and select Load > Load Data.
- 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.
The data is added to the new feature class, which contains the field that does not allow NULL values.
Last Published: 6/1/2018
Article ID: 000010006
Software: ArcGIS-ArcEditor 9.3.1, 9.3, 9.2, 9.1, 9.0, 8.3, 8.2, 8.1.2, 8.1, 10 ArcGIS-ArcInfo 9.3.1, 9.3, 9.2, 9.1, 9.0, 8.3, 8.2, 8.1.2, 8.1, 8.0.2, 8.0.1, 10 ArcGIS-ArcView 9.3.1, 9.3, 9.2, 9.1, 9.0, 8.3, 8.2, 8.1.2, 8.1, 10 ArcMap 10.6, 10.5.1, 10.4.1, 10.3, 10.2.1