topic Re: Indicator Widget Not Returning Correct Value in ArcGIS Dashboards Questions

Indicator Widget Not Returning Correct Value

mpboyle — Mon, 24 Jan 2022 15:36:27 GMT

We recently updated our Enterprise system to 10.9.1, and have noticed that indicator widgets are not always returning correct values.

I have double-checked that the layer in the web map has a refresh interval, and it does, which is set to 0.5 minutes. The table in the web map shows correct data. If I preview the table in the dashboard, the data is correct. However, the indicator value is NOT correct.

Below is an example. We have a table where I could use either the row count or max ID value to return the number of rows within the table. In this example, the value should be 18. The indicator widget does not seem to update though. If I refresh the page, the correct value will show, but if we leave the page open, the indicator value never seems to change on it's own as it should.

There are more than one indicator widgets where this seems to occur in our dashboard.

Any reason why this would no longer seem to work in 10.9.1...?

The dataset within the web map is a feature layer published from ArcGIS Server, it is not versioned, and is not archived.

I have also noticed the issue with indicators seems to be specific when using "Statistic" as the Value Type. If I use "Feature" as the Value Type, it seems to auto-refresh as expected.

Re: Indicator Widget Not Returning Correct Value

SeanRedar — Wed, 09 Feb 2022 23:57:23 GMT

Same problem here. We use a python script to routinely update the data but the indicators are not catching it. And the statistic is what we need.

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Fri, 11 Feb 2022 16:33:54 GMT

Have you had any luck resolving this issue? I am trying to create the first dashboard since updating to 10.9.1 and noticing this behavior as well.

Re: Indicator Widget Not Returning Correct Value

mpboyle — Fri, 11 Feb 2022 16:38:46 GMT

It has been logged as a bug (BUG-000146814). It's super annoying as this wasn't an issue at 10.9.

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Fri, 11 Feb 2022 16:40:50 GMT

Completely agree. Thanks for the update.

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Thu, 17 Feb 2022 16:04:01 GMT

I have been troubleshooting with support on this issue. It appears that the browser cache might be causing the issue. You might try to open your dashboard in an incognito window and see if it updates. I also tested the dashboard in Firefox and the indicators are responsive in that browser.

We also upped the max number of records returned setting in the service parameters but I dont think that had any effect on the dashboard.

Support is supposed to be following up so I can keep you posted on any updates.

Re: Indicator Widget Not Returning Correct Value

mpboyle — Thu, 17 Feb 2022 16:11:19 GMT

Incognito window doesn't work either. It will seem like it does because the cache is not present when first opening it, but it does not update as expected either.

It does seem Firefox works as expected. As pointed out in above comments, this seems to be specific to Chromium based browsers. Unfortunately, our IT has a policy against using Firefox...so...doesn't leave us with many options.

This issue has been flagged as a defect, bug number is below.

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Thu, 17 Feb 2022 16:24:27 GMT

Yeah....in the same boat with Firefox. I have added this thread to my support case so they can reference your BUG. Hopefully they can get a fix soon.

These are the notes from my support case:

When making some edits on the feature layer, the edits are not reflected on the ArcGIS Dashboard indicator widget.
Checked the feature layer in the Portal For ArcGIS and all of the new edits were added to the attribute of the feature layer.
Navigated to the ArcGIS Server manager Services>parameter.
The maximum number of records returned by the server was set to 2000, we increase the number to 10000 to include all of the records in your feature service.
Open the dashboard again by using the incognito window and the issue was resolved and all of the edits were reflected.
The issue still appeared if we didn't clear the browser cache on Google Chrome.

As we discussed I will make some further research about the browser cache and if there is any way to modify the settings of the browser cache. I will keep you updated once I have one.

Re: Indicator Widget Not Returning Correct Value

mpboyle — Thu, 17 Feb 2022 16:45:23 GMT

This issue also seems to be specific to services published from ArcGIS Server. If I use a hosted feature layer from AGO, the indicator updates as expected.

Re: Indicator Widget Not Returning Correct Value

BrianWilson3 — Wed, 23 Feb 2022 19:24:02 GMT

I found that if you open developer mode in chrome, on the network tab, check the no cache check box and then just minimize developer window it works properly. On my side it seems to be specific to data coming from our SQL server and running as a map service (haven't tested with feature services yet). I have seen that tables from sql do not seem to be affected. I also noticed that the cache ages out on my side after some extended period of time (4-6 hrs). ESRI let me know they are going to either create a new bug for the list widget, which is what i'm having trouble with but it sounds like any widget pull data this way might have issues. I have tried adding the usual pragma/no-cache headers to the main dashboard HTML but it doesn't help. Dev mode with no-cache checked and minimized is the only work around i've found for now.

Re: Indicator Widget Not Returning Correct Value

BrianWilson3 — Thu, 17 Mar 2022 17:45:42 GMT

Digging into it more i found that if you publish the server as just a map image and do not check the feature service check box, then List and Indicator seem to cache the data. If you publish with feature checked, list will now work but indicator is still cached. I found that if you use arcade to pull in the data after publishing with feature then it will refresh. Huge pain that ESRI needs to fix.

Arcade code to add in the item is as follows

FeatureSetByPortalItem(Portal('https://gis.union-power.com/portal'),'IDFromPortalGoesHere', ID of the item in the service goes here)

I set the refresh to be similar to the map i'm pullin in so they all refresh at the same time.

Hope this helps someone else

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Fri, 29 Apr 2022 19:09:22 GMT

Has anybody had any updates on this issue? Our dashboards are still not functioning. Hopefully esri can figure this out soon since it makes Dashboards useless for now.

Re: Indicator Widget Not Returning Correct Value

SeanRedar — Fri, 29 Apr 2022 19:56:10 GMT

I came up with a work around using Arcade, example follows. Note, indicators require a FeatureSet so if you expect nulls create a null feature\ feature set to return,... just in case. And Arcade can be finicky.

var nullFS = FeatureSet('{"fields":[{"alias":"objectid","name":"objectid","type":"esriFieldTypeInteger"},{"alias":"district","name":"district","type":"esriFieldTypeString"},{"alias":"project","name":"project","type":"esriFieldTypeString"},{"alias":"created_date","name":"created_date","type":"esriFieldTypeDate"}],"spatialReference":{"wkid":102100},"geometryType":"esriGeometryPoint","features":[{"geometry":{"x":-13138847.3052,"y":5875138.111400001,"spatialReference":{"wkid":102100}},"attributes":{"objectid":100,"district":"Walla Walla","project":"Temp","created_date":"2122-03-28T12:51:42-07:00"}}]}');
var fsin = FeatureSetByPortalItem(Portal('https://arcportal-ucop-corps.usace.army.mil/s0portal'), '67d897cf19244c5db57507851a3ff804', 0,['district','project','created_date']);
var q = "project_org = 'usace'";
var fs = Filter(fsin,q);
var testDT = (DateAdd(Now(),-2,"hours"));
var testDT24 = (DateAdd(Now(),-24,"hours"));
var objList = Array(0,"");
for (var f in fs){
var fDT = (f.created_date);
if (fDT < testDT){
if (fDT > testDT24){
Push(objList, f.project);
}
}
}
if (Count(objList) > 0){
var oString = "(";
for (var x of objList) {
oString = oString + ("'"+objList[x]+"'");
}
oString = oString + ")";
oString = Replace(oString,"''","','");
var q = "project IN " + oString;
Console(q);
var fssub = Filter(fs,q);
Return fssub;
} else if (Count(objList) == 0) {
Console("returning nullFS");
Return nullFS;
}

Re: Indicator Widget Not Returning Correct Value

LuisBaena1 — Thu, 12 May 2022 13:52:06 GMT

Does anyone know if ESRI is working on solving this case?.

Our boards are not working yet. Hopefully Esri can resolve this soon as it makes Dashboards useless for now.

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Wed, 18 May 2022 13:33:25 GMT

As far as I know there is still no solution. If others are experiencing this issue you need to contact support and escalate BUG-000146814.

They did post a "Workaround" on the BUG but I am not sure how we are supposed to do this for all users. "When checking the Disable Cache option in the developer tools, the data is updated successfully. In Dashboard URL in the developer tools, set the cache hint to 'Hint=True'. However, when set to 'Hint=False', the changes in the data are updated for both the List widget and the Indicator widget. In conclusion, data can be updated by either setting up the cache hint to 'True' or checking the Disable Cache option in the developer tools for map services."

Re: Indicator Widget Not Returning Correct Value

BrianWilson3 — Mon, 23 May 2022 12:47:26 GMT

Has any one checked to see if the Stale Query Patch resolves this issue? I'll be adding the patch this evening. Based on the description it looks to be similar though it doesn't specifically mention BUG-000146814. https://support.esri.com/en/download/8028

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Thu, 02 Jun 2022 16:25:07 GMT

Did you have any luck with the patch?

Re: Indicator Widget Not Returning Correct Value

LuisBaena1 — Thu, 02 Jun 2022 17:31:28 GMT

We still have no resolution, we escalate the problem to our ESRI partner. We are waiting for your answer.

Re: Indicator Widget Not Returning Correct Value

BrianWilson3 — Thu, 02 Jun 2022 18:21:03 GMT

I've been tied up with other things. I won't be able to apply the patch for probably another 2 weeks. As i'm using feature services with Arcade expressions, i'm not seeing the problem anymore so priority has dropped. I'll post back after i've patched.

Re: Indicator Widget Not Returning Correct Value

CassidyKillian — Thu, 02 Jun 2022 18:44:30 GMT

After looking at the BUG in support, it says the issue will be fixed in 11.0 so it is not included in any patches. That is great since we just updated to 10.9.1. Too bad Dashboards are useless in that release.