topic Re: Attribute rule error on python updatecursor in Attribute Rules Questions

Attribute rule error on python updatecursor

JimmyBowden — Mon, 13 Dec 2021 21:47:25 GMT

In ArcGIS Pro 2.8.3 when trying to update a feature using Python update cursor an error occurs (see below). This error occurs in our enterprise implementation of the Water Utility Network Solution and also when using the sample Naperville data provided in a file geodatabase. Editing workflows in the ArcGIS Pro UI work fine for this type of edit. These attribute rules were provided as part of the Water Utility Network Solution. If I disable the attribute rule it will fail on another rule (Water Line - MeasuredLength From Shape), when both are disabled the edit occurs without error. Here is a simplified snippet of code:

import arcpy aprx = arcpy.mp.ArcGISProject("CURRENT") m = aprx.listMaps()[0] idFeature = [] for lyr in m.listLayers(): lyrdesc = arcpy.Describe(lyr) if lyr.isFeatureLayer: fi = lyrdesc.fieldInfo obj = lyrdesc.FIDSet if obj: wc = "OBJECTID in ({0})".format(obj.replace(";",",")) print(wc) with arcpy.da.UpdateCursor(lyr, ["OID@", "NOTES"],wc) as cursor: for row in cursor: row[1] = "TEST" cursor.updateRow(row)

RuntimeError: Failed to evaluate Arcade expression. [
Rule name: Water Line - Cathodic Protection Traceability,
Triggering event: Update,
Class name: WaterLine,
GlobalID: ,
Arcade error: Field not found cptraceability,
Script line: 25]

Re: Attribute rule error on python updatecursor

HusseinNasser2 — Mon, 13 Dec 2021 22:51:23 GMT

This is happening because the AR tried to use a field that was not fetched by python.

Two solutions,

you can wrap the python call with arcpy.da.Editor(str(workspacepath)) which will give the editor context.

or you can include all the fields that the AR require in the UpdateCursor call (cptraceability) in this case.

Re: Attribute rule error on python updatecursor

JoeBorgione — Mon, 13 Dec 2021 23:20:48 GMT

Or turn the rule off when you are running the update cursor....

Re: Attribute rule error on python updatecursor

VinceE — Thu, 17 Nov 2022 21:39:39 GMT

Is there a means of programmatically (ArcPy) getting a list of all fields that are involved in Attribute Rule Calculations? It appears that it is possible to use arcpy.da.Describe with the ['attributeRules'] key to obtain the names of the fields that have calculations applied, but that will not include fields that might be part of the calculation. For example, you can get the name of Field3 where the calculation is applied, but I don't see a means of getting the names of Field1 and Field2 that are used to calculate a sum, for example, to be populated in Field3.

Re: Attribute rule error on python updatecursor

geopamplona — Tue, 21 Feb 2023 10:59:37 GMT

@HusseinNasser2

in my case I am doing same edit against a feature service

it seems as if from arcpy it is indicated to do edits against database, and not against services

to make edits against a feature service I should use arcpy or arcgis for python. How could I get the same result using ArcGIS API for Python?