topic Re: "Accessing data failed" show table error (AGOL) in ArcGIS Online Questions

"Accessing data failed" show table error (AGOL)

K_Rocks — Fri, 19 Oct 2018 11:04:04 GMT

Hi,

I'm having a problem with showing tables while creating an ArcGIS Online Web Map. The services are visible and features can be individually queried but clicking on Show Table returns an "Accessing data failed" error.

I know that similar questions were asked 5-6 years ago (https://community.esri.com/message/89965 and https://community.esri.com/message/89965) but they seem to remain unanswered. A response to the same query here suggests that it was due to a field name length problem for some people, but all of my fields are shorter than 32 characters.

ArcGIS Server 10.2.2 has been used to publish the services.

Thanks for any help.

Re: "Accessing data failed" show table error (AGOL)

MikeMinami — Thu, 25 Oct 2018 21:22:48 GMT

Can you share your web map? I'm also assuming the services are publicly accessible.

Alternatively, you might try opening the web browser developer tools that track network requests. You might get a more informative error message when you look at the request that is failing.

Mike

Re: "Accessing data failed" show table error (AGOL)

K_Rocks — Fri, 26 Oct 2018 14:58:49 GMT

Thank for your response Mike.

Prior to your suggestion, I carried out a version upgrade of ArcGIS Server (and Web Adaptor), which looks to have resolved the problem. I'm unsure why but the tables work now.

Re: "Accessing data failed" show table error (AGOL)

DarrylKlassen1 — Tue, 05 Mar 2019 20:02:17 GMT

I am having the same issue. I can query my rest end point data, but I get the same error when trying to look at the table in AGOL.

Rest End Point:

Layer: GIS.GIST_MTI_TICKETS_1_WEEK (ID: 6)

AGOL Map:

https://kamloops.maps.arcgis.com/home/webmap/viewer.html?webmap=49a3513d70294b72ae2f588379d7d5e1

Any help is appreciated.

Re: "Accessing data failed" show table error (AGOL)

Scott_Harris — Tue, 05 Mar 2019 20:44:00 GMT

I get "Failed to execute query." when querying at REST:

Query: GIS.GIST_MTI_TICKETS_1_WEEK (ID: 6)

Perhaps because the table is missing an OBJECTID field?

Re: "Accessing data failed" show table error (AGOL)

DarrylKlassen1 — Tue, 05 Mar 2019 21:22:22 GMT

Thanks Scott Harris. That worked. Should have thought of it.
Darryl