topic Error 001625 failed to alter field is nullable in Data Management Questions

Error 001625 failed to alter field is nullable

JoeBorgione — Thu, 07 Jan 2021 16:32:35 GMT

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.

Re: Error 001625 failed to alter field is nullable

DanPatterson — Thu, 07 Jan 2021 18:36:22 GMT

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)

Re: Error 001625 failed to alter field is nullable

JoeBorgione — Thu, 07 Jan 2021 18:38:23 GMT

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

Re: Error 001625 failed to alter field is nullable

DanPatterson — Thu, 07 Jan 2021 18:51:39 GMT

then why did you mark you answer correct?😂

Re: Error 001625 failed to alter field is nullable

JoeBorgione — Thu, 07 Jan 2021 18:52:33 GMT

correct enough....