Error 001625 failed to alter field is nullable

2490
4
Jump to solution
01-07-2021 08:32 AM
Labels (3)
JoeBorgione
MVP Emeritus

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.

 

That should just about do it....
Tags (2)
1 Solution

Accepted Solutions
JoeBorgione
MVP Emeritus

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

That should just about do it....

View solution in original post

4 Replies
DanPatterson
MVP Esteemed 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 Emeritus

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

That should just about do it....
DanPatterson
MVP Esteemed Contributor

then why did you mark you answer correct?😂


... sort of retired...
JoeBorgione
MVP Emeritus

correct enough....

That should just about do it....