topic Re: ArcGIS Dashboards Arcade Data Expression not working after update in ArcGIS Dashboards Questions

ArcGIS Dashboards Arcade Data Expression not working after update

LJackson29 — Wed, 13 Nov 2024 14:45:30 GMT

Hello -

I am working in ArcGIS Dashboards and have a data expression that is no longer working after the update last night. I am getting this error "Test execution error: layerId=1 provided for Map Service item. Verify test data." It is not clear what this error is - the layerid is correct. I am using a map image service pulled in from Enterprise Portal that has 3 layers. See my code below.

var port = Portal('https://www.arcgis.com'); var fs = filter(FeatureSetByPortalItem( port,'xxxxxxxxxxxxxxxx', 1, ['PH_PROJECTID', 'PH_PHASEID', 'PH_PHASENAME', 'PH_COMPLDATE', 'PH_STATUS', 'PH_PHASETYPE', 'PH_STREAMRESTORED_LFT', 'PH_WETLAND_AC', 'PH_FLOODPLAIN_AC', 'PH_CULVERTREPAIRED_FT', 'PH_SEDIMENTREMOVED_CY', 'PH_BASINSTORAGE_ACFT', 'PH_TREESPLANTED', 'PH_WAC', 'PH_SUBWATERSHED', 'PH_COMMUNITY1'], false), "PH_STATUS='07. Completed' AND (PH_PHASETYPE='1. DesCon' OR PH_PHASETYPE='2. SWIM' OR PH_PHASETYPE='3. Partner' OR PH_PHASETYPE='4. Parcel Acquisition')" ); var out_dict = { fields: [ {name: 'projectid', type: 'esriFieldTypeString'}, {name: 'phaseid', type: 'esriFieldTypeString'}, {name: 'phasename', type: 'esriFieldTypeString'}, {name: 'phasetype', type: 'esriFieldTypeString'}, {name: 'complyear', type: 'esriFieldTypeString'}, {name: 'status', type: 'esriFieldTypeString'}, {name: 'stream', type: 'esriFieldTypeDouble'}, {name: 'wetland', type: 'esriFieldTypeDouble'}, {name: 'floodplain', type: 'esriFieldTypeDouble'}, {name: 'culvert', type: 'esriFieldTypeDouble'}, {name: 'sediment', type: 'esriFieldTypeDouble'}, {name: 'basin', type: 'esriFieldTypeDouble'}, {name: 'trees', type: 'esriFieldTypeInteger'}, {name: 'wac', type: 'esriFieldTypeString'}, {name: 'subwatershed', type: 'esriFieldTypeString'}, {name: 'community1', type: 'esriFieldTypeString'}, {name: 'streamcat', type: 'esriFieldTypeString'}, {name: 'wetlandcat', type: 'esriFieldTypeString'}, {name: 'floodplcat', type: 'esriFieldTypeString'}, {name: 'culvertcat', type: 'esriFieldTypeString'}, {name: 'sedimentcat', type: 'esriFieldTypeString'}, {name: 'basincat', type: 'esriFieldTypeString'}, {name: 'treescat', type: 'esriFieldTypeString'}, ], geometryType: '', features: [] } // Iterate over each feature in the layer for (var f in fs){ Push( out_dict['features'], {attributes: { projectid: Text(f['PH_PROJECTID']), phaseid: Text(f['PH_PHASEID']), phasename: Text(f['PH_PHASENAME']), phasetype: Text(f['PH_PHASETYPE']), complyear: Year(f['PH_COMPLDATE']), status: Text(f['PH_STATUS']), stream: Number(f['PH_STREAMRESTORED_LFT']), wetland: Number(f['PH_WETLAND_AC']), floodplain: Number(f['PH_FLOODPLAIN_AC']), culvert: Number(f['PH_CULVERTREPAIRED_FT']), sediment: Number(f['PH_SEDIMENTREMOVED_CY']), basin: Number(f['PH_BASINSTORAGE_ACFT']), trees: Number(f['PH_TREESPLANTED']), wac: Text(f['PH_WAC']), subwatershed: Text(f['PH_SUBWATERSHED']), community1: Text(f['PH_COMMUNITY1']), streamcat: IIF(f['PH_STREAMRESTORED_LFT']>0, 'Yes', 'No'), wetlandcat: IIf(f['PH_WETLAND_AC']>0, 'Yes', 'No'), floodplcat: IIf(f['PH_FLOODPLAIN_AC']>0, 'Yes', 'No'), culvertcat: IIf(f['PH_CULVERTREPAIRED_FT']>0, 'Yes', 'No'), sedimentcat: IIf(f['PH_SEDIMENTREMOVED_CY']>0, 'Yes', 'No'), basincat: IIf(f['PH_BASINSTORAGE_ACFT']>0, 'Yes', 'No'), treescat: IIf(f['PH_TREESPLANTED']>0, 'Yes', 'No'), } } ) } //Return populated out_dict as FeatureSet var mos = FeatureSet(Text(out_dict)) return mos

Re: ArcGIS Dashboards Arcade Data Expression not working after update

Stephanie_F — Wed, 13 Nov 2024 15:01:40 GMT

Hi @LJackson29 I suggest working with Technical Support to report this https://support.esri.com/en-us/contact/report-bug

Re: ArcGIS Dashboards Arcade Data Expression not working after update

LJackson29 — Wed, 13 Nov 2024 15:02:43 GMT

@Stephanie_F Thanks - will do

Re: ArcGIS Dashboards Arcade Data Expression not working after update

RandyBonds_Jr_ — Wed, 13 Nov 2024 22:46:41 GMT

We are having the same issue! I have opened a ticket with support, but wanted to let you know that you're not alone 🙂

My code for comparison:

//get featureset from portal item

var fs = FeatureSetByPortalItem(
    Portal("https://gis.yakimawa.gov/portal/"),
    "ITEM_ID",
    0,
    [
      "CleanupDate",
      "ShoppingCart",
      "Tires",
      "Furniture",
      "Mattresses",
      "Appliances",
      "Electronics",
      "Graffiti",
      "Miscellaneous",
      "PressureWash",
      "Vacuum",
      "Incompletes"
    ],
    false
  );

  var choicesDict = {
    fields: [
      { name: "cleanupDate", type: "esriFieldTypeDate" },
      { name: "sumCategories", type: "esriFieldTypeDouble" }
    ],
    geometryType: "",
    features: []
  };

  // Split comma separated hazard types and store in dictionary.
  var i = 0;

  for (var ccfeature in fs) {
    choicesDict.features[i++] = {
      attributes:
        {
          cleanupDate: ccfeature["Cleanupdate"],
          sumCategories:
            ccfeature["ShoppingCart"] +
            ccfeature["Furniture"] +
            ccfeature["Mattresses"] +
            ccfeature["Appliances"] +
            ccfeature["Electronics"] +
            ccfeature["Tires"] +
            ccfeature["Graffiti"] +
            ccfeature["Miscellaneous"] +
            ccfeature["PressureWash"] +
            ccfeature["Vacuum"] +
            ccfeature["Incompletes"]
        }
    };
  }

  return FeatureSet(Text(choicesDict));

The error when I try to test:

 Test execution error: layerId=0 provided for Map Service item. Verify test data.

Re: ArcGIS Dashboards Arcade Data Expression not working after update

LJackson29 — Thu, 14 Nov 2024 13:05:22 GMT

@RandyBonds_Jr_ Thanks for sharing - it always helps that there are others experiencing the same issue!

Re: ArcGIS Dashboards Arcade Data Expression not working after update

KathrynWalker — Thu, 14 Nov 2024 14:47:10 GMT

Hi @LJackson29 and @RandyBonds_Jr_,

Thank you for reporting this behavior. An official bug has been logged for this: "BUG-000172239: Map Services are no longer able to be used as the reference item for Arcade's FeatureSetByPortalItem function in Map Viewer pop-ups or Dashboard data expressions following the ArcGIS Online November 2024 update". Please request that your cases be attached to this bug.

An identified short-term workaround is to add the map service's sublayer(s) individually as items to ArcGIS Online and reference their item IDs in the Arcade expression.

Thank you,
Katie

Re: ArcGIS Dashboards Arcade Data Expression not working after update

RandyBonds_Jr_ — Thu, 14 Nov 2024 15:52:07 GMT

Thanks, the support person added it to my request yesterday.

Re: ArcGIS Dashboards Arcade Data Expression not working after update

LJackson29 — Thu, 14 Nov 2024 18:42:36 GMT

@KathrynWalker Thanks - I will have the support person add the bug when I we talk. Is there any timeline for a fix?

Re: ArcGIS Dashboards Arcade Data Expression not working after update

KerryKang — Thu, 14 Nov 2024 22:37:30 GMT

my data expression seems working using 'FeatureSetByPortalItem' in the preview and editing mode, but not in the view mode. There are multiple widgets/ URL parameter working together with my data expression so I am not sure where the issue is coming from exactly.

Re: ArcGIS Dashboards Arcade Data Expression not working after update

LJackson29 — Fri, 15 Nov 2024 12:40:02 GMT

@KerryKang The bug described above is specific to map image layers, so if you are using a feature service, your issue might be something different.

Re: ArcGIS Dashboards Arcade Data Expression not working after update

KathrynWalker — Mon, 18 Nov 2024 12:57:22 GMT

@LJackson29 this bug should now be fixed. Please let us know if you see behavior otherwise!

Re: ArcGIS Dashboards Arcade Data Expression not working after update

LJackson29 — Mon, 18 Nov 2024 13:20:54 GMT

@KathrynWalker Yes, it is working again. Thanks so much for the quick turn around on this. 😊

Re: ArcGIS Dashboards Arcade Data Expression not working after update

RandyBonds_Jr_ — Mon, 18 Nov 2024 16:05:40 GMT

Yes! I have confirmed it's working for us as well. Thanks for the quick attention to this issue.

Re: ArcGIS Dashboards Arcade Data Expression not working after update

JessicaLott_Dymaptic — Thu, 19 Dec 2024 19:23:32 GMT

Hello!

We are starting to see this error as well. Could the bug have been reintroduced?

Thanks!

Re: ArcGIS Dashboards Arcade Data Expression not working after update

RandyBonds_Jr_ — Thu, 19 Dec 2024 19:53:04 GMT

I'm not seeing it on my dashboard... it's working correctly

Re: ArcGIS Dashboards Arcade Data Expression not working after update

LJackson29 — Fri, 20 Dec 2024 12:50:33 GMT

Our dashboards with data expressions are working as well.