topic Re: "Accessing data failed" error message - ArcGIS Online in ArcGIS Online Questions

"Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Mon, 01 Aug 2016 21:31:59 GMT

Hi Everyone,

I recently published three layers from ArcGIS Pro (1.3) to my ArcGIS Online account. The first two came in fine. But the third did not show up. When I tried to access the table from the third layer, it gave me the error message of "Accessing data failed".

The map in question is here: http://meiamerica.maps.arcgis.com/home/webmap/viewer.html?webmap=e97c0195b842460585a85ffa8a48b5d7

The 'funny' thing is, the data source for the second and third layer is exactly the same. Could this be my issue? I don't know why it would matter, but who knows...

Thanks in advance.

Re: "Accessing data failed" error message - ArcGIS Online

RebeccaStrauch__GISP — Mon, 01 Aug 2016 21:36:47 GMT

I think for some reason it is turned off...

When I checked it it showed in the legend.

EDIT: Scratch that..the table gives me an error too. Have your checked whether there are any records being returned?

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Mon, 01 Aug 2016 21:45:55 GMT

Hi Rebecca,

Thanks for checking. I had it turned off initially. I tried having it turned on and other combos, still same result. How do you check about records being returned in AGOL? I don't see anything when I check it on, if that's what you mean.

Re: "Accessing data failed" error message - ArcGIS Online

RebeccaStrauch__GISP — Mon, 01 Aug 2016 21:51:59 GMT

My guess is to look at the developer resource traffic (fiddler, etc). I did test a query again the service, and it is returning data

http://services5.arcgis.com/mvnrDxfOCq0CsVom/arcgis/rest/services/10783_and_11442_SR18_St_George_Blvd_to_Sunset_Blvd/Fea…

even if you say json. I can't remember how to get it to spit out attributes off the top. It does seem to have the goemetry sinc eyou can zoom to the extent too. Head scratcher for me (but also didn't spend much time.)

.....

Edit...I'm seeing an access error...if that helps any.

edit2

the GET query line...

http://services5.arcgis.com/mvnrDxfOCq0CsVom/arcgis/rest/services/10783_and_11442_SR18_St_George_Blvd_to_Sunset_Blvd/Fea…

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Tue, 02 Aug 2016 06:16:19 GMT

That's interesting that it is returning data yet also throwing an access error. I am not sure what that means.

When I access the service directly and try to view it in a blank map, it does not show me anything (for that layer).

I'll keep messing around and maybe use Fiddler on it (recently Kelly Gerrow showed me how to use this and it's pretty awesome!).

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Tue, 02 Aug 2016 06:20:01 GMT

I was poking around some more and found that something similar to this has occurred a few times with no real resolution, that I can tell.

This thread had the error but seemed to get around it by trying the table again immediately (which didn't work for me):

AGOL: Attribute Populates in Table, Doesn't Show in Pop-Up When Selected as Parameter

This thread saw the table initially but then it was lost when trying to access it again:

Accessing data failed (Show Table)

This recent thread is having the issue after using Survey123. Though it seems to have a similar issue to what I'm seeing:

Accessing data failed

The most similar case is this thread:

"Accessing data failed" Error in ArcGIS Online

Still, the one thing they all have in common is the error message and no resolution (or any replies)

Re: "Accessing data failed" error message - ArcGIS Online

RebeccaStrauch__GISP — Tue, 02 Aug 2016 13:28:23 GMT

Have you contacted tech support yet? It would be worth getting them involved since with so many similar problems, maybe it us a bug, or maybe it is unreported AGOL health issue. Point them to thus thread where you've already down the search for similar issues...might save sound time. My suggestion at this point.

Re: "Accessing data failed" error message - ArcGIS Online

KellyGerrow — Tue, 02 Aug 2016 15:59:43 GMT

Hey Adrian,

I also recommend contacting Esri Technical Support. This service seems to be having some issues returning attributes. Analysts can help look into the issue on this service.

Thanks,

Kelly

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Wed, 03 Aug 2016 04:49:23 GMT

Thanks Kelly and Rebecca. Tech support got a hold of me. One of their suggestions was checking and repairing the geometry. Repairing the geometry actually repaired one polygon and checking it (afterwards) showed no errors. I republished and did not have success. So I'm waiting to hear more suggestions.

Re: "Accessing data failed" error message - ArcGIS Online

ChrisWhitmore — Wed, 03 Aug 2016 15:30:42 GMT

Adrian, the issue is that some of the field names in the layer are too long. Perpetual_Easement_65_value_estimate for example. Usually field names like this are transparently truncated (with the field alias maintained). Pro 1.3 should be doing this but doesn't seem to be in your case. Possible to share the SD file generated in my content when published from Pro? Can send to me @ cwhitmore@esri.com or share privately via group in AGOL (username cwwhitmore).

Thanks,

Chris

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Wed, 03 Aug 2016 15:39:18 GMT

Chris,

That is interesting. I just sent you an email with the .sd file. Let me know what you find out. (I wish these field names could be shorter but trying to comply with engineers, surveyors, project managers, etc. all at one time is not conducive to productivity....).

Thanks,

Adrian

Re: "Accessing data failed" error message - ArcGIS Online

RebeccaStrauch__GISP — Wed, 03 Aug 2016 15:43:21 GMT

Adrian, would messing with, or swapping fieldname and an alias work? Just a thought on a way to shorted/abbreviate the required field names.

Re: "Accessing data failed" error message - ArcGIS Online

ChrisWhitmore — Wed, 03 Aug 2016 19:58:43 GMT

Adrian Welsh thanks for sending the sd file. Confirmed it's an issue with the field length. Unfortunately the only workaround really is to publish with shorter field names (32 characters or less) . This will be fixed on the Online side in the next release (currently planned for September). There also seems to be an issue with this in Pro with shortening the field names when publishing (essentially both Pro and Online should automatically truncate the longer field names but didn't in your specific case).

This info was sent over to the support analyst you talked to - they're writing these issues up, etc so you'll likely be hearing from them soon.

Thanks,

Chris

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Wed, 03 Aug 2016 20:55:03 GMT

Thanks Chris. I shortened the field names and it publishes normally. Silly ArcGIS Pro to ArcGIS Online conversion..... Well, I'm glad that it was an 'easy' fix. I'm going to have to crack down on these land survey people more about field-names-that-are-really-really-ridiculously-too-long.

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Tue, 23 Aug 2016 15:12:16 GMT

I completely forgot to add the new BUGS that Esri filed for this case.

BUG-000098341 : The process of publishing to ArcGIS Online should truncate long field names even if the client application (ArcGIS Pro, ArcMap, etc.) doesn't.
BUG-000098339 : ArcGIS Online Error: "Accessing data failed" -> data with field names that have over 32 characters fail to publish correctly when published to ArcGIS Online from ArcMap, only if there are multiple layers that reference the same database in the service
BUG-000098311 : ArcGIS Online Error: "Accessing data failed" -> data with field names that have over 32 characters fail to publish correctly when published to ArcGIS Online from ArcGIS Pro, only if there are multiple layers that reference the same database in the service.
Furthermore here are the workarounds that I have found:
Workaround 1:
Publish each layer individually from ArcMap/ArcGIS Pro
Workaround 2:
Make sure all of the field name lengths are less than 32 characters
Workaround 3:
Make sure the layers in the map document/Pro Project are all from different sources

Re: "Accessing data failed" error message - ArcGIS Online

AdrianWelsh — Wed, 19 Sep 2018 15:07:19 GMT

These bugs have all been 'resolved' since they cannot be reproduced anymore, allegedly.

BUG-000098341: The process of publishing to ArcGIS Online must trun..

BUG-000098339: Data with field names that have over 32 characters w..

BUG-000098311 is a duplicate of 000098339, supposedly.