topic Re: Attribute Rule Error on Published Feature Service in ArcGIS Pro Questions

Attribute Rule Error on Published Feature Service

JoshHellman1 — Tue, 19 Jan 2021 17:35:04 GMT

Hello,

I am applying the following Attribute Rule Arcade expression to a FC with a related table:

var table = FeatureSetByName($datastore,"Arrowhead_Ph2_Relocation_Table")

var total = 0

for (var t in table)

if (t.BLK_PRCL_NUM == $feature.BLK_PRCL_NUM) {

total = total + t.TOT_RELO_AMNT_OFRD

}

return total

I publish the FC and related table as a service, however, when I try to edit I get the error message below. If I look at the attribute rules of the published service FC, I notice it changes my Arcade expression from the related table name above to an ID number.

When I test the attribute rule directly from the GDB it works perfect.

Here is the portion of the expression in the attribute rule it changes once it's published as a feature service:

var table = FeatureSetByName($datastore,"{A2D0EBF1-2A6C-4EC2-BAE3-852F03E47EBB}")

Why does it change my arcade expression from the Table Name I input in the expression, to the ID number? When it does this it's making the expression not find the table name in the GDB and generates this error.

Thanks!

Re: Attribute Rule Error on Published Feature Service

JoeBorgione — Tue, 19 Jan 2021 18:59:42 GMT

Where is this published: to your portal or AGOL?

Is the ID number that it changes it to the correct table? Can you edit the rule once it's published? (I don't think you can....)

Re: Attribute Rule Error on Published Feature Service

JoshHellman1 — Wed, 20 Jan 2021 14:38:48 GMT

It's published to our Enterprise server.

I'm not sure where that number it assigns comes from? Or what is causing it to convert once it's a published service.

I have been editing the expression after it's published. First I stop the service from running, then I edit the expression, save the attribute rule, and publish to overwrite the service.

The attribute rule is using a field in the origin table, and when records in the related table are inserted or updated, I want to sum those totals for all matching parcels and write that total value back in the origin table.

Thanks!

Re: Attribute Rule Error on Published Feature Service

NJJLuus — Tue, 19 Oct 2021 14:02:57 GMT

Hi @JoshHellman1, have you been able to establish the source of this issue and a way to fix it?

Did you perhaps import the rules to this Feature Class oor dit you create it from scratch? I suspected that it had something to do with the fact that you copy over the whole Arcade Expression and somehow the reference to the old table (from where the code originated).

Re: Attribute Rule Error on Published Feature Service

JessicaJThompson — Thu, 06 Jan 2022 16:06:28 GMT

Have you been able to remedy this? I am working on publishing a feature service in portal and would like to use attribute rules. I know that this doesn't work in AGOL. Does it work with portal?

Thank you,

Jessica

Re: Attribute Rule Error on Published Feature Service

NJJLuus — Fri, 07 Jan 2022 07:21:50 GMT

Hi again thread-members.
@JessicaJThompson, It should work fine with an Enterprise (portal) deployment. I have been using it successfully with the issue/(bug?) that pops up every now and then. I have still not got a definitive answer to my issue but the bug seemed to be less likely to appear when I published the feature with the setting to "Allow assignment of unique numeric IDs for sharing web layers" left unchecked.

Hope this helps.

Nico

Re: Attribute Rule Error on Published Feature Service

Bio_InfoAdmin — Mon, 28 Feb 2022 02:14:37 GMT

Hi there, i am having the same issue, but the feature service i am referencing to updates overnight, and it leaves me with a random ID (so Conservation.Cons.ParkExtent, changes to a random ID) This is the code i am using at the moment. Is there anyway to solve this?

//search ParkExtent reference table
var zones = FeatureSetbyName($datastore, "CONSERVATION.CONS.ParkExtent",["SiteName"],true);

//Get a feature set of zones that intersect the address
var intersectingZones = Intersects(zones, Geometry($feature))

// Select the first record in the feature set
var matchedZone = First(intersectingZones)

// Return the SiteName value of the selected zone
return IIf(IsEmpty(matchedZone), null, matchedZone.SiteName);

Re: Attribute Rule Error on Published Feature Service

AnneSantaMaria — Thu, 05 May 2022 12:13:16 GMT

Has anyone heard anything additional about this bug/error? We are experiencing the same issue. Just curious if there have been any updates.

Re: Attribute Rule Error on Published Feature Service

JordanM_Support — Thu, 30 Mar 2023 15:55:15 GMT

Hi @AnneSantaMaria and others, please try following the steps in this technical article, which addresses this particular error message. From the article: "The error message is returned when an attribute rule is added to a feature layer and the 'Exclude from application evaluation' option is not enabled. This option allows edits to be evaluated at the database level, rather than by ArcGIS Pro, before the edits are sent to the source database."

Thanks,

Jordan

Re: Attribute Rule Error on Published Feature Service

JBeasley — Mon, 20 Nov 2023 14:58:11 GMT

Hi Josh,

Did you ever find the cause for this? Or a permanent fix?

We are experiencing the same thing. The table name we reference in an expression is being changed to a global ID looking string. The change is seemingly random. We have services published from this data source- some to Enterprise, some to AGOL. AGOL services are only used for viewing, no editing. We built the rules from scratch and can "repair" them by changing the name back to the actual table name then overwriting the services, but every few months it seems to revert to a global ID string.

Thanks!

Re: Attribute Rule Error on Published Feature Service

JBeasley — Mon, 27 Nov 2023 20:46:39 GMT

Figured out the source of our issue. We were referencing a table within a few rules that unbeknownst to us was updated every 3-6 months via a full replace- meaning the table was deleted a new one (of the same name) was imported. We have now advised the table be updated via a truncate/append method and have not seen the same behavior since switching. Hope this helps someone!

Re: Attribute Rule Error on Published Feature Service

ColeSutton — Thu, 18 Dec 2025 19:42:58 GMT

This absolutely helped me @JBeasley, thank you!

The issue occurs for me even in just a file geodatabase, nothing involving services published or AGOL etc. Say my attribute rule on an address point feature class is pulling info from an underlying parcel polygon. The rule is using:
FeatureSetByName($datastore, "Parcels"...

If I delete the Parcels feature class, I assumed I could replace it with another feature class of the same name, and the attribute rule on my address point layer would be unaffected. And it seemed to work fine at first. So I did some more testing. If I check the attribute rule immediately after deleting/replacing the Parcels fc, then the expression code still looks fine and the rule still functions normally. However, if I close the project and reopen, then the attribute rule throws an error, and when inspecting the rule expression I will find the code is changed to something like this:
FeatureSetByName($datastore, "{AEDA8ED7-1785-4D10-9C54-0DCB1F4A8A6A}"...