topic Re: Calculate field tool only works once. in ArcGIS Pro Questions

Calculate field tool only works once.

ajkelsey — Sat, 14 Sep 2019 14:35:39 GMT

The calculate field tool only works once for me. I can run another calculation with no errors, but the field does not populate. I have to restart ArcGIS Pro for it to work again. I would appreciate any insight as to why.

The layer is a geodatabase feature class and I am using Python 3 expressions. ArcGIS Pro v2.4.1.

Re: Calculate field tool only works once.

LanceCole — Sun, 15 Sep 2019 20:45:04 GMT

andrew kelsey‌,

Can you provide a little more information, such as the Python field calculation def you are having problems with and the call statement?

Re: Calculate field tool only works once.

ajkelsey — Sun, 15 Sep 2019 20:59:22 GMT

I'm not trying to do anything special. I am either multiplying or dividing two columns in the table. If i restart ArcGIS, I can run the calculation and it populates the cells. I just don't understand why I need to restart the application between each calculation.

Re: Calculate field tool only works once.

LanceCole — Sun, 15 Sep 2019 21:40:26 GMT

Andrew‌,

You are getting a Calculated Field Competed message? If you look at the details any additional info?

You do not have anything selected the second time that is limiting the data that the calculation is performed on. Try clicking the "Clear" button on the Map ribbon, unless you are intentionally limiting the data, before running the calculate field.
Have your tried creating a new project and add only that feature class to the map and see if it works there?

Re: Calculate field tool only works once.

ajkelsey — Sun, 15 Sep 2019 21:56:12 GMT

Yes. I get the completed message with no errors. No additional info in the details. After restarting, I double checked the attribute table to make sure the cells weren't populated and were not visible prior to the restart. But they were empty.

No selections in the map during calculations. Just a simple Cell1 * Cell2 or Cell1 * 43560.

I have not tried adding the feature class to a new project. I do believe I had this same issue in a previous project.

Re: Calculate field tool only works once.

LanceCole — Sun, 15 Sep 2019 22:56:47 GMT

andrew kelsey‌,

Got me on this one. As noted above, try adding the feature class to a new project and/or importing it into a new GDB as well. Check that all of the fields are numeric. Post a screen shot of your calculate field for both the first and second attempt, might be a simple overlooked issue. Try using Arcade in place of Python to calculate the fields. No joined tables, correct. There was an issue with that a few versions ago in Pro.

Re: Calculate field tool only works once.

ajkelsey — Sun, 15 Sep 2019 23:34:13 GMT

Yes. They are joined tables.

Re: Calculate field tool only works once.

LanceCole — Mon, 16 Sep 2019 00:20:35 GMT

Andrew,

Let me see if I can find the info on that previous bug. I think that was clear back in 2.2 though and has most likely been resolved. You are not trying to update a joined table field, correct. You are only using the joined data to update fields in the feature class to which the data is joined.

Re: Calculate field tool only works once.

LanceCole — Mon, 16 Sep 2019 00:43:35 GMT

Andrew,

After thoughts,

How long does the calculate field tool run each time i.e. first time when it works and second time when it does not. You can view this from the "View Details".

If the first run you do, say Cell1 * Cell2 and place that in Cell3 works, what happens if you run it again as Cell1 +!Cell2 and place that in Cell3, does it run correctly?

Is it just one particular field you are having issues with? Have you tried to delete the entire column from the feature class and add it back in and then rerun the calculate field?

And one more, Check if you by chance have any duplicate alias field names in any of your tables or feature classes.

Its late, I am done. Have a great evening.

Re: Calculate field tool only works once.

ajkelsey — Mon, 16 Sep 2019 00:53:56 GMT

I am not trying to update a joined field. I created new fields that are to be populated.

It's hard for me to try these suggestions because the project is done. I would have to recreate the table to do so.

Re: Calculate field tool only works once.

RonaldVanderpool — Tue, 17 Sep 2019 12:24:29 GMT

Hi Andrew,

No resolutions for you. Sorry. Just wanted you and GeoNet to know that I have had similar issues with the Field Calculator. It happens just as you say, either with Python or Arcade, and also whether I am calculating a field in an AGOL feature or one that is on my desktop.

Saving the project and then restarting Pro sometimes fixes the issue and on more than one occasion I have to restart my PC to get Pro functionality working.

Sigh.........At least that restarting has got me back working. Not sure if it is a bug but starting to maybe sound like it.

Re: Calculate field tool only works once.

DataOfficer — Thu, 06 Jul 2023 08:30:48 GMT

I am experiencing a similar issue in ArcGIS Pro 3.1.1. I am using SQL for the field calculations, and the expressions are just simple text calculations to populate rows of data. Calculations usually work the first time the Calculate Field window is opened, but not the second. Despite appearing to run successfully with no error messages, the field is left uncalculated. In the current instance, the layer we are working with is hosted in ArcGIS Online and accessed via our Portal.