topic Re: arcade calculate expression - Unknown Error in ArcGIS Field Maps Questions

arcade calculate expression - Unknown Error

SarahRijneke — Fri, 08 Sep 2023 15:13:57 GMT

I created a field maps app several months ago that includes an arcade expression to calculate the DueDate field for features that are added to the app. I used the FeatureSetByName($map...) function to access attributes in a static road feature service (i.e. a copy of our roads feature layer). Recently, someone in my organization added a new roads feature service that reflects our 'live' data i.e. it updates as features are edited in our SDE geodatabase. This layer was added to portal and the portal item was added to ArcGIS Online with stored credentials. When I try to reference the new layer in my expression I receive the following error: Test execution error: Unknown Error. Verify test data. I have also tried to use the FeaturesetByPortalItem function and receive this error: Test exection error: Invalid variable assignment.. Verify test data. Does anyone know why I cannot use the same expression to access attributes in the 'live' roads feature service?

Re: arcade calculate expression - Unknown Error

DavidPike — Fri, 08 Sep 2023 19:01:31 GMT

Is it a feature service or map service (I'm guessing you're trying this on a map service)? have you tried FeatureSetByPortalItem()? What does the url look like for this 'live' item.

Re: arcade calculate expression - Unknown Error

SarahRijneke — Mon, 11 Sep 2023 12:14:27 GMT

the info I am tryin to access is from a Feature layer. I also tried FeatureSetByPortalItem and get the following error: Test execution error: Unknown Error. Verify test data

Re: arcade calculate expression - Unknown Error

SarahRijneke — Mon, 25 Sep 2023 15:52:14 GMT

The arcade expression works in field maps now using FeatureSetByName($map...).

I have a model in ArcGIS pro that connects to the same datasets. The model calculates the DueDate field in a similar way and I would like it to reference this new feature service as well. When I use the FeatureSetByPortalItem function I see an Invalid expression. Portal item not found error. Is it possible to use a portal items to calculate fields for features that are stored in a geodatabase?

Re: arcade calculate expression - Unknown Error

JustinReynolds — Mon, 25 Sep 2023 18:44:56 GMT

It should work based on the documentation.

The field calculate Arcade Profile lists "Portal Access" as one of its function bundles. The FeatureSetByPortalItem function is a member of the "Portal Access" function bundle. This function has been around since Arcade 1.8 and ArcGIS Pro 2.4.

The error you specify above seems to suggest that you are not pointing to the correct portal or it is having issues authenticating. I don't really use model builder but you may need to sign-in to the portal of interest in the model... https://community.esri.com/t5/arcgis-pro-questions/setting-a-portal-connection-in-modelbuilder-in/td-p/1142868