topic Re: Python geoprocessing script published as service doesn't use the Data Store in Geoprocessing Questions

Python geoprocessing script published as service doesn't use the Data Store

TomSellsted — Wed, 19 Nov 2014 00:16:10 GMT

Greetings,

I have a simple python script that buffers a parcel and returns a CSV of parcels within a specified distance of the original parcel. This is published as a service and seems to work very well. My problem is that when I publish this script as a service, the publishing tool makes a complete (unnecessary) copy of my parcel geodatabase. Then continues to use the copied file geodatabase rather than the registered geodatabase. The script was published in March 2014, so the data is getting somewhat stale. I do have the parcel geodatabase registered in the data store, but when published it does not recognize it.

How do I publish a script to use the geodatabase and not make a copy? I would appreciate any help!

Re: Python geoprocessing script published as service doesn't use the Data Store

TomSellsted — Thu, 20 Nov 2014 00:15:59 GMT

This is a known issue logged as NIM104122 [If the input data to a geoprocessing service is resides in a SQL Server Express database, the data is copied to the ArcGIS input folder and the task only run on that static data.]

The workaround is to stop the service and copy fresh data in to the file geodatabase. This problem is supposed to be fixed at version 10.3.

Re: Python geoprocessing script published as service doesn't use the Data Store

Anonymous User — Sat, 13 Dec 2014 00:22:10 GMT

This bug was logged when I was working with ESRI in August. We've been waiting with bated breath for 10.3 and the fix....and it is not fixed. It in fact states "Closed: Will Not be Addressed".

I called ESRI and will have follow-up on Monday but this is a serious let down if it has been dismissed.

Re: Python geoprocessing script published as service doesn't use the Data Store

TomSellsted — Sat, 13 Dec 2014 00:29:08 GMT

Sarah,

You are correct! I was also hopeful. I too installed ArcGIS Server 10.3 today and republished my service and it again copies my entire parcel feature class to a file geodatabase for use with the service instead of using my geodatabase. I already have another ticket open with ESRI support. No contact yet, just the automatic replies...

Best Regards,

Tom

Re: Python geoprocessing script published as service doesn't use the Data Store

Anonymous User — Mon, 22 Dec 2014 22:22:16 GMT

Hi Tom.

I finally heard back and I think I have it working. The trick is to create a Database Connection in ArcCatalog, and then when you add the data to the map for publishing it should be from the Database Connection, not the Database Server connection. I changed my map and when I checked on the server it had copied over the connection file rather than the data, and downloads worked!

Sarah

Re: Python geoprocessing script published as service doesn't use the Data Store

TomSellsted — Mon, 22 Dec 2014 22:38:30 GMT

Sarah,

Excellent! I am glad you have it working. In my case I am publishing the geoprocessing service directly in ArcCatalog. I run the tool in ArcCatalog from my toolbox and then publish the successful result as a service. It isn't a tool published as part of a ArcMap project. I am still waiting to hear back from ESRI support...

Best Regards,

Tom