laptop and a wrench

Bug

Switching options under the Allow NULL column in the ArcMap field design crashes the client when working with a SQL Server geodatabase.

Last Published: March 13, 2023 ArcGIS for Desktop
Bug ID Number BUG-000155914
SubmittedFebruary 16, 2023
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.8.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusDuplicate

Workaround

Altering a field to be NOT NULL is only applicable if the table is empty (does not contain records). There are several options for avoiding the crash:

  • Drop the table and recreate with the correct field configurations.
  • Dropping the desired column to not allow nulls and recreate the column that way.
  • Use ArcMap 10.8.1 or ArcGIS Pro 3.x. to perform the alter field.

Steps to Reproduce

Bug ID: BUG-000155914

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options