Alter Field Not Working/Glitch

356
13
Jump to solution
02-09-2021 06:25 AM
Labels (1)
DanaThompson1
New Contributor III

I am using Alter Field in a Task to change a field name so I can prepare a layer to append properly.

The Alter Field fails because Error001625: https://pro.arcgis.com/en/pro-app/latest/tool-reference/tool-errors-and-warnings/001001-010000/tool-... - can't alter field nullability.

I'm not trying to alter field nullability, but I don't have the option to change that. I closed and reopened Alter Field several times and saw that below, for the first 1-2 seconds the window appears as on the left. Then the New Field is Nullable and New Field Type parameters disappear. Does anyone else have this issue?

Alter Field 1.png  AfterAfter

1 Solution

Accepted Solutions
DanaThompson1
New Contributor III

All, I found a workaround.

I used the Feature Class to Feature Class tool to export an intermediate file of the data. The tool has a built in Field Map, just like what you see in Append. From there I was able to alter the field name (right click & rename) and export the file, before I proceeded to Append in my Task using matching field names.

View solution in original post

0 Kudos
13 Replies
DavidPike
MVP Regular Contributor

Hi, the documentation suggests that if there are any values in the table, field nullability can't be altered:

Below from the documentation Alter Field (Data Management)—ArcGIS Pro | Documentation

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).

0 Kudos
DanaThompson1
New Contributor III

Right. But I'm not trying to alter the Field Nullability. ArcGIS thinks I am because by default the New Field is Nullable box is unchecked -- and my feature class does allow null values. But like illustrated in my post, that parameter disappears when loading the tool so I can't change it.

DanPatterson
MVP Notable Contributor

what I was suggesting is that perhaps it is slow on the uptake and doesn't remove the parameter when the tool first opens but it lags after it does its check


... sort of retired...
0 Kudos
DanPatterson
MVP Notable Contributor

Does your table contain records already?  From the help

Specifies the new field type for the field. This property is only applicable if the input table is empty (does not contain records).


... sort of retired...
0 Kudos
DanaThompson1
New Contributor III

Yes it does. Though I'm not trying to change field type.

0 Kudos
Robert_LeClair
Esri Frequent Contributor

Are you using a File Geodatabase or Enterprise Geodatabase?

0 Kudos
DanaThompson1
New Contributor III

It's a File Geodatabase.

0 Kudos
Robert_LeClair
Esri Frequent Contributor

Okay - sometimes  when I see strange GP occurrences like this I close ArcGIS Pro and rename the ESRI folder in the C:\Users\<user profile>\appdata\local and C:\Users\<user profile>\appdata\roaming to ESRI_OLD.  Restart ArcGIS Pro, load the project and try again.  What is the result?

0 Kudos
DanaThompson1
New Contributor III

Thanks for the suggestion, but unfortunately it didn't work.

0 Kudos