topic Re: ArcGIS Data Access Failure in ArcGIS Enterprise Questions

ArcGIS Data Access Failure

DaveTenney — Mon, 09 Apr 2018 00:59:36 GMT

All,

i have seen discussions here and there about this similar issue, but i wanted to ask it again...

we are seeing this following error in both 10.2.2 environments as well as our newer 10.5.1 environments:

ExecuteError: Data access failure, layer = Image, error string = Could not access data for layer or table Image during drawingÂ§TilesWorker: Data access failure, layer = Image, error string = Could not access data for layer or table Image during drawingÂ§TilesWorker: Data access failure, layer = Image, error string = Could not access data for layer or table Image during drawing

we see this when using our python scripts to update our map services. we have two maps: one with just vector data and one with vector and raster data. our scripts get through the vector only map just fine but when its time to update the map with the raster data we get the above error.

it seems like a fairly straight forward error...well kind of. it would appear to be a data access issue, but the odd thing is we haven't changed the data or where its located or the permissions of said location. so i'm a bit perplexed on this issue, and any help would be greatly appreciated.

thanks a bunch!

dave

Re: ArcGIS Data Access Failure

JonathanQuinn — Wed, 11 Apr 2018 18:34:32 GMT

Can you describe what the script is doing? Do you update the mxd and then overwrite the service?

Re: ArcGIS Data Access Failure

DaveTenney — Wed, 08 May 2019 17:45:00 GMT

Jonathan,

we are seeing this issue again.

our python script is running the ManageMapServerCacheTiles GP Tool to rebuild new tiles based upon a delta check that we do to see what data is new.

Dave

Re: ArcGIS Data Access Failure

MichaelVolz — Wed, 08 May 2019 17:53:31 GMT

Are you updating your production cache? If so, are you using exploded or compact cache?

If you have a dev and/or test environment, have you tried running the python script on that cache and then just copy the updated tiles from the dev/test location to the production location?

Re: ArcGIS Data Access Failure

DaveTenney — Wed, 08 May 2019 18:02:11 GMT

1) this is a production environment

a. this process passed in our own internal environment and pre-Production environment.

b. same script, same data

2) we have always used compact cache

3) we build the cache manually first within ArcMAP using GP Tools

a. once this process is completed, we run the script to only update tiles where data has changed

dave

Re: ArcGIS Data Access Failure

MichaelVolz — Wed, 08 May 2019 18:04:40 GMT

How often does this script run (e.g. daily, weekly, monthly, other)?

Does the script run at a time when no one would be accessing the cache in either a desktop or web application?

Re: ArcGIS Data Access Failure

DaveTenney — Wed, 08 May 2019 18:07:36 GMT

The script is set to run once a week and will run late at night unless I force the script to run. Also, this process all happens on a machine we call the maintenance server. no one is accessing anything on this machine, I am the only one running the process.

Re: ArcGIS Data Access Failure

MichaelVolz — Wed, 08 May 2019 18:18:18 GMT

What kind of raster data are you using that gets updated on a weekly basis? I ask because my org has aerial photos that do not change plus we use an Image Server role of ArcGIS Server that is sourced from raster mosaic datasets (RMDs). Are you using RMDs for your imagery?

Re: ArcGIS Data Access Failure

DaveTenney — Wed, 08 May 2019 18:21:53 GMT

the imagery is only updated once a year, it is the vector data that is updated on a weekly basis.

yes, we create a RMD from the jpeg2000 raw tiles.

Re: ArcGIS Data Access Failure

MichaelVolz — Wed, 08 May 2019 18:51:44 GMT

Have you ever thought of just removing the raster data from the mxd that is cached and just supply the RMD from an image service? With this architectural change, you remove the raster liability from your python script as it is the raster data that seems to be the root cause of the error. Image services are very efficient at supplying raster data and are equal if not faster than a cache from my experience.

Re: ArcGIS Data Access Failure

DaveTenney — Wed, 08 May 2019 18:55:22 GMT

My biggest concern would be of bandwidth...

1) current setup where the vector and raster are together, you are only requesting the data once

2) separate services, now you are requesting the data twice(1 request for vector, 1 request for raster)

Im not sure if Esri has looking into this or not but that would be the main hesitation on my end.

Re: ArcGIS Data Access Failure

DaveTenney — Thu, 16 May 2019 18:31:18 GMT

after opening a ticket with esri support we seem to be making some head way...

i am very concerned about the behavior of ArcGIS Server, please see below:

i currently have the server set to a max of 2 instances of CachingTools. the two instances of .GPServerSync are crippling our machine! i have never seen this behavior before and the only thing that has changed on our machine is an upgrade from 10.2.2 to 10.5.1

Machine Specs:

Windows Server 2012 R2

16 GB Ram

Intel Xeon CPU E5-4620 v2

thoughts?

dave