nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data source is not accessible

BenStaud

I have two, nearly identical, data sources. One is hosted by a third party on their Arc Server. The second is hosted by AGOL. Both are feature services.
I have two operational views. One using the Arc Server data source and one using the AGOL version.
The Operational View using the Arc Server hosted data works great. However, the Operational View using the AGOL data displays fine in map view but, when you attempt to add a Widget for Summary or Query (other might also have this problem) I get partially through the Widget setup and I get the orange "Data source is not accessible" message icons. Sometimes I can get the Widgets setup quickly enough that I can close the dialog and the Widget is completed. But the Widget never display's any data. And when I go back to configure the Widget again the data source is flagged with the orange icon.
I am logged in as the administrator for the AGOL and Operational Views so sharing should not be an issue.
This has been happening for over a week now.
Any help?

Find more posts tagged with

Accepted answers

All comments

Kylie

Could you try setting your layer to be a static instead of dynamic (in the map widget configuration), and see if you still see the issue?

BenStaud

It did not help. I still get the orange icons. The count routine in summary will work but, the statistics in summary will not calculate and the query set-up dialog crashes almost upon opening.

Kylie

Could you share your hosted service and your op view using it with me? The easiest way is to create a group, share the service and op view with the group, and invite my ArcGIS Online user kylie_org to that group.

HiranZani2

I noticed the same issue. The bug seems to be associate with specific AGOL accounts rather than the feature service. The crash happens when an query or statitical widget is added...

Kylie

Hi Hiran -- Could you give me some more information about the accounts you are and aren't seeing it with? Also, could you share a map, the services, and an operation view with me (kylie_org) where I might be able to repro this? The easiest way to share is create a group, share the items with the group, and invite my user to the group.

Kylie

Hi Ben -- I just saw you did share some content with me... however, it looks like it is the map and op views, but not the hosted services. Could you share the services with me as well so that I can try and repro?

HiranZani2

Hi Kyle - I have shared with you both the OP View and the feature service. The error persists even with the OD 10.2 update. As I told you, works normally in old AGOL accounts. But when I add a query or a statics widget it suddenly disconnect the data source. I appreciate your help. Many thanks.

DanielStauning

Hiran,

This behavior is being caused by a setting in the ArcGIS Online organization "Allow only standard SQL queries." If you disable this setting it will resolve your issue; My Organization > Edit Settings > Security > uncheck the box for "Allow only standard SQL queries." You'll have to be an administrator to do so.

The underlying problem is the 'where' parameter of 1=1 being invalid for query operations when executed with Output Statistics with this setting enabled. 1=1 is often used in the 'where' parameter to return all records when querying a dataset; this is how Operations Dashboard automatically formats the request for widgets that use statistics like sum and average. The fact that the widget configuration is failing because of this setting I consider to be a bug which I will document.

I hope this resolves your issue, please feel free to follow up to let us know if this work around does the trick.

- Daniel

HiranZani2

Daniel - problem solved!

I appreciate your assistance in this matter.

Regards

DavinShokes1

Wow, this has been a serious headache. Thank you for identifying the work around.

They should really have this documented in the resources Standardized SQL functions in ArcGIS Online.

Turning on this setting was highly recommended, but I find no documentation that states Operations Dashboard uses Non-standardized SQL.

Thanks,
Davin

DougMorgenthaler

This issue should be resolved. A fix was made to ArcGIS Online hosted services earlier this week that addressed issues with these types of queries when Allow only standard SQL queries is enabled.

mahmoudfadel2

Hi Kylie Donia,

i need to extend the functionality of "Layers filter map tool" in dashboard by js api .

what i need to change in the default behavior is to have the abilty to filter more than one layer in the same time , also to make the condition between filters AND not OR

Could you help ?

Thanks

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.