Latest Contributions by HeatherTaylor4

‎04-07-2019

The expression is very simple as I am literally just copying from one field in the joined table to a field in the feature service. It works fine in Pro 2.1 but not 2.2.

‎04-04-2019

Thanks Dan. The task I had set up was using a python expression (that was giving the error about multiple OIDs) and I just realised that when I ran the 'calculate field' tool manually it was defaulting to SQL. It is still failing with a python expression but giving the error 'ERROR 999999: Something unexpected caused the tool to fail. The Fields collection contained multiple OID fields' instead of the error 002536.

‎04-03-2019

I created a task in ArcGIS Pro 2.1 that updates a field in a feature service in ArcGIS online with the local government area that the point is in. The task performed a spatial join between the feature service (points where disaster impacts had occurred) and the LGA data set, joined the new feature class table back to the original service and then did a 'calculate field' to update the local government area details in the original service. This worked fine in 2.1 but when I changed to 2.2.4 the task failed. I have also tried running it manually with the separate tools and it fails on the calculate field step. The error message varies: I have had 'error 002536 - does not support or is not in a state to support SQL expressions' and error 999999 'the fields collection contained multiple OID fields'. Any suggestions?

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by HeatherTaylor4

Re: Field calculator not working in ArcGIS Pro (2.2) with a joined table

Re: Field calculator not working in ArcGIS Pro (2.2) with a joined table

Field calculator not working in ArcGIS Pro (2.2) with a joined table