topic Re: 2.6.1 - field calculator with selection, dangerous bug in ArcGIS Pro Questions

2.6.1 - field calculator with selection, dangerous bug

danbecker — Tue, 22 Sep 2020 20:24:38 GMT

Is this expected behavior on 2.6.1? This is VERY DANGEROUS.

Select a record in attribute table. Right click on field, calculate field, specify a string to calculate, hit APPLY
make sure and leave the field calculator floating window open
change the selection in the table to a different record
the field calculator window is already open, don't change anything except a new string to calculate, hit APPLY or OK, doesn't matter

Notice what happens…you would expect that the record selected in step #3 would be calculated, i.e. the one currently selected, but it actually calculates the formally selected record, i.e. the selection in step #1.

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Tue, 22 Sep 2020 20:44:17 GMT

Dan - I followed your steps precisely and do not see what you're describing. One test to consider - copy/paste the existing feature class in your geodatabase as a new feature class in the same geodatabase. Repeat the workflow. Do you see the same result? If so, try this - create a new file geodatabase and copy/paste the feature class to the new geodatabase. Repeat the same workflow. Do you see the same result? Please advise.

Re: 2.6.1 - field calculator with selection, dangerous bug

danbecker — Tue, 22 Sep 2020 21:03:16 GMT

When I documented the steps above, I was using an SDE GDB (postgreSQL 9.5), unversioned, archiving enabled.

So, I created a new FGDB on disk, found a random poly feature class from a different FGDB, copy/pasted it into the new FGDB, then completed the above steps.

Same result. The first selected record is calculated.

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Tue, 22 Sep 2020 21:09:32 GMT

Thx for the update. When you installed AGP 2.6.x was it a clean install from AGP 2.5? What I mean - did you completely uninstall AGP 2.5 prior to cleanly installing AGP 2.6.x? Or did you upgrade AGP 2.5 to 2.6? The reason I ask I did a clean uninstall of 2.5 before installing 2.6 and do not see this workflow.

Re: 2.6.1 - field calculator with selection, dangerous bug

danbecker — Tue, 22 Sep 2020 21:14:13 GMT

I have never done a clean install, I've upgraded several versions atop each other. I installed 2.6, then 2.6.1 (the SP), the update was not a clean install. A co-worker was able to repo. the issue, he also did not clean install, actually, can't because I'm the person with admin. privs to run installs.

Re: 2.6.1 - field calculator with selection, dangerous bug

danbecker — Tue, 22 Sep 2020 21:22:00 GMT

I had to split the video into 2 parts; pretty basic but illustrates the issue. This is really bizarre.

(view in My Videos)

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Tue, 22 Sep 2020 21:22:50 GMT

Ok - thx for the update. Try this - rename the Esri folder in your C:\Users\<user profile>\appdata\local and C:\Users\<user profile>\appdata\roaming to Esri_Old and repeat your workflow. Does the issue persist?

Re: 2.6.1 - field calculator with selection, dangerous bug

danbecker — Tue, 22 Sep 2020 21:35:54 GMT

I renamed both those folders to _old, then re-opened Pro, and navigated to the same FGDB for the test calc's, the issue still persists.

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Tue, 22 Sep 2020 21:37:28 GMT

Thx for the videos - that helps me visualize the workflow. I followed your steps exactly. My AGP 2.6.1 does not repro what I'm seeing in your videos. The only difference is that I'm using a file GDB and not a PostgreSQL RDBMS. Weird...

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Tue, 22 Sep 2020 21:41:31 GMT

Can you share the FC as an *.xml Workspace document so I can test on my side? If so my email address is rleclair AT esri dot com

Thx!

Re: 2.6.1 - field calculator with selection, dangerous bug

danbecker — Tue, 22 Sep 2020 21:41:54 GMT

The video uses a simple FGDB on a Win Server 2016 network share; I wanted to simplify the environment, but in our case (2 different workstations, 2 different Pro licenses) it doesn't matter. A feature service, SDE Feature Class or FGDB all produce the same result as shown in the video.

We have to be REALLY careful when calculating attribute values.

Re: 2.6.1 - field calculator with selection, dangerous bug

DanPatterson — Tue, 22 Sep 2020 21:42:33 GMT

I can't replicate. Clean install of 2.6, 2.6.1 updated on top of it. Local fgdb table.

Re: 2.6.1 - field calculator with selection, dangerous bug

danbecker — Tue, 22 Sep 2020 21:50:48 GMT

I created a new FGDB on local C, created new poly feat class with 1 field. Digitized 2 non-overlapping polys.

Same result, the incorrect record is calculated, just like the initial steps.

So, this has nothing to do with the location of the FGDB (local vs. network share)

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Tue, 22 Sep 2020 22:04:49 GMT

Followed the same "create a new FGDB on local c, created..." and can't replicate either. Strange...

Re: 2.6.1 - field calculator with selection, dangerous bug

danbecker — Wed, 23 Sep 2020 13:12:07 GMT

Win 10 Pro is fully updated, version 2004

Win. control panel, uninstalled Pro, then rebooted.

Clean install 2.6, opened the same Pro project as before, then the same local C:\ FGDB, the problem still persists.

Installed 2.6.1 patch atop 2.6.

Created a new blank project, accessed the same local C:\ FGDB, problem solved

Closed new blank project.

Opened same Pro project as before, then the same local C:\ FGDB, the problem still persists.

Removed all items in geoprocessing history (147 of them), the problem still persists.

Edit: testing continues..

Created new Pro project using an existing template we had.

Had 2 instances of Pro open, the problematic project from above and the new one. I then copy/pasted the Pro map over to the new Project.

In the new project, I now have the original map from the old project. I Field calculated the same local C:\ FGDB, the problem still persists.

Created a new blank map in the new Pro project, I Field calculated the same local C:\ FGDB, problem solved

So, this bug is related to the Pro map, project, which makes sense, because my Collegue and I are working on the "same" project/map. He opened the original and did a SAVE-AS, I'm still using the original.

Edit: finally figured out the bug, it's related to a Hosted Feature Layer being present in the map.

Steps to test attribute calculation:

Select a record in attribute table. Right click on field, calculate field, specify a string to calculate, hit APPLY
make sure and leave the field calculator floating window open
change the selection in the table to a different record
the field calculator window is already open, don't change anything except a new string to calculate, hit APPLY or OK, doesn't matter

Steps to Repo the issue with calculating attributes when HFL is present in the map:

Create a new blank pro project. Insert a new blank map. Add a single FGDB layer to the map.
Perform the above "Steps to test attribute calculation". Everything will work as expected.
Add a HFL to your map. We use Enterprise, I have not tested AGOL HFLs.
Perform the above "Steps to test attribute calculation". You will see the problem where the incorrect record is calculated.
Remove the HFL. Perform the above "Steps to test attribute calculation". You will see the problem where the incorrect record is calculated.
Once the HFL is added, even after it's removed, the attribute calculation problem persists. It's not corrected until you create a new map.

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Wed, 23 Sep 2020 13:53:28 GMT

Thx for the update Dan - glad it worked out properly with a new project file.

Re: 2.6.1 - field calculator with selection, dangerous bug

Robert_LeClair — Wed, 23 Sep 2020 17:13:55 GMT

Working with Dan directly, I was able to repro this issue. Short story is a hosted feature layer published from Survey 123 Connect and then added to a Map View in ArcGIS Pro will cause this calculation error seen by Dan. I've reported it to Esri Support Services as a BUG. More to come.

Re: 2.6.1 - field calculator with selection, dangerous bug

WWalker — Tue, 22 Apr 2025 16:25:34 GMT

I'm experiencing this issue at 3.3. No hosted feature layers. Only local FGDBs and imagery.