Error 001625 failed to alter field is nullable

249
4
Jump to solution
01-07-2021 08:32 AM
JoeBorgione
MVP Esteemed Contributor

ArcGis Pro 2.6

I have a table in a file geodatabase that I created with a connection to a (non sde) sql database with table to table.  A number of fields have empty (non null) values and I want to calculate the to <Null>.  However  when I try to alter those fields in the field view, I get 

Error 001625 failed to alter field is nullable

Is there a way for me to make this work?  I'd rather not add new fields that are nullable or create an empty table of the same schema and append the originals.

 

can't wait to retire....
Tags (2)
1 Solution

Accepted Solutions
JoeBorgione
MVP Esteemed Contributor

Good idea. I could put str(-9999) in the text ones.  Thanks.

can't wait to retire....

View solution in original post

4 Replies
DanPatterson
MVP Notable Contributor

001625: Failed to alter field is nullable.—ArcGIS Pro | Documentation

which leads to

Alter Field (Data Management)—ArcGIS Pro | Documentation

and

field_is_nullable Specifies whether the field can contain null values. Null values are only supported for fields in a geodatabase. This option is only applicable if the input table is empty (does not contain records).

So... no

Althought putting in another values which is readily identifiable as "nodata" would be a solution (eg -99999 for integers or "someone forgot something" for text)


... sort of retired...
JoeBorgione
MVP Esteemed Contributor

Good idea. I could put str(-9999) in the text ones.  Thanks.

can't wait to retire....

View solution in original post

DanPatterson
MVP Notable Contributor

then why did you mark you answer correct?😂


... sort of retired...
JoeBorgione
MVP Esteemed Contributor

correct enough....

can't wait to retire....