"Accessing data failed" show table error (AGOL)

2047
5
10-19-2018 04:04 AM
K_Rocks
New Contributor III

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.

0 Kudos
5 Replies
MikeMinami
Esri Notable Contributor

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

0 Kudos
K_Rocks
New Contributor III

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.

0 Kudos
DarrylKlassen1
Occasional Contributor II

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.

0 Kudos
Scott_Harris
Esri Regular Contributor

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?

0 Kudos
DarrylKlassen1
Occasional Contributor II

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