Calculate Attribute Rule not firing for SubnetworkName change on Update Subnetwork gp

[EstherSmith_Dev]

Hi all,

I have an Calculate Attribute Rule defined on ElectricJunctionObject table of the Electric UNM. The attribute rule sets a business attribute when valid SubnetworkName is set. Workflow is,

1. CRM to UNM System integration creates a record in ElectricJunctionObject. The record represents a new customer. A flag is set for the record as "Validation Pending".

2. UNM data editor views records with "Validation Pending" in ArcGIS Pro. User connects the record to a "Service Point" asset type in ElectricJunction feature class using Modify Association tool. This makes new customer part of the connected model.

3. User runs Update Subnetwork geoprocessing tool to ensure ElectricJunctionObject has SubnetworkName populated.

4. A Calculate Attribute Rule trigger is supposed to fire on "Update" action with SubnetworkName changing from "Unknown" to "FeederABCD". Attribute rule is defined to set a flag on  ElectricJunctionObject  to "Validation Complete". Logic is simple as, see below.

if ($feature.ISCONNECTED == 1 && $feature.SUBNETWORKNAME != 'Unknown' && IsEmpty($feature.SUBNETWORKNAME) == false)
{
return 1;
}
else {
return 0;
}

I can see that Update Subnetwork tool changed the SubnetworkName from "Unknown" to "FeederABCD" but ProcessingStatus is still 0 (Validation Pending). If I edit another trivial business attribute such as "Notes" on the ElectricJunctionObject, ProcessingStatus changes to 1 (Validation Complete) meaning trigger fired.

Is "Update Subnetwork" tool somehow stops Arcade Calculate Rule from firing? If so, how can I configure it to not prevent Calculate Rule.

@MikeMillerGIS any idea?

Thanks,

[MikeMillerGIS · Accepted solution]

Update Subnetwork sets the subnetwork name field outside edit events by default.  This is done for performance reasons and to not introduce edits in a version table.  You can change this behavior(links below).  

https://pro.arcgis.com/en/pro-app/latest/tool-reference/utility-networks/set-subnetwork-definition.h...

- Edit Mode For Default Version

- Edit Mode For Named Version

[EstherSmith_Dev]

Thanks @MikeMillerGIS 

I want to make events fire in this case. From the documentation, it looks like it will overwrite editor tracking fields as well which I don't want.

Will look into some other logic to set the flag after customers are connected to the network and are traceable for outage reporting etc. For now, changed the logic to base it on ASSOCIATIONSTATUS with bit value 32 ($feature.ASSOCIATIONSTATUS & 32 == 32). It seems to be firing.

Cheers,

Vish

[EstherSmith_Dev]

@MikeMillerGIS I have a related question. I have implemented Arcade Attribute Calculation Rule to auto-populate "OperatingVoltage" and few other attributes using asset logically or geometrically connected to it. It fires on Create and Update event.  It is all working fine.

I have another requirement now to run a trace periodically and bulk-update "OperatingVoltage" for the assets traced. I was thinking of using applyEdits once the trace completes and update the "OperatingVoltage" using "edits" parameter of applyEdits. But I suspect the Arcade Attribute Calculation expression will cause the value to be reset creating undesired outcome. Is there any way to bulk apply edits "without eventing" like Update Subnetwork? Does "Update Subnetwork" internally call applyEdits ? If not, how does it prevent edit events?

Thanks,

Vish

[MikeMillerGIS]

There is no way easy/supported way to make an edit outside the edit events.  Best option is to code your rule to exit earlier when the attribute as a value.  Then code your rule to only calculate a value when it is null.  So if you want the rule to recalculate the value, you set the field to null and the AR will run. 

[EstherSmith_Dev]

Thanks @MikeMillerGIS 

I will try to convince my client to set the auto-populated fields to null for AR to fire and not hinder bulk-updates.

[SergioOM]

Hi Everybody! 

Propagators would not help in this case?

Having a similar situation I would like to propagate a field during the "Update Subnetwork" process in default version without eventing, from certain asset when has a field like f.e "xxx_change" filled in and all the way down to the service point. This way, it will be only propagated when some changes have been done within the Subnetwork but also it will take into account all possible condition barriers for that tier. I know this is already possible using the MIN, MAX and BIWISE AND operators with pahsing for example, but could it be somehow done also "like for like" ? (So, when xxx_change = 123 then all assets downstream xyz = 123).

Thanks in advance!

[MikeMillerGIS]

There is a backlog item to support this, but I do not see it tied to a bug/enh request.  I would suggest logging a support case and require the Propagated Copy method.

You can use the batch trace for now:

Here is a post that discusses it - https://community.esri.com/t5/arcgis-utility-network-questions/using-trace-configurations-in-attribu...