topic Re: Geoprocessing Output in Geoprocessing Questions

Geoprocessing Output

JoshEpperson — Wed, 09 Jun 2010 20:28:57 GMT

I am new to geoprocessing and I am having trouble figuring out how to return data back to a web client.

I created a simple model that uses a point feature class into the "Frequency" tool. It automatically set the output as a table in the geodatabase. There is a status field with a limited number of options and I want to know how many of each there are. This feature class is updated daily and we want to be able to see statistical data on our web application.

I created a toolbox out of this model and created a geoprocessing service on arcgis server 9.3.

When I run the service on the server it creates a table in the database but does not return data back to the client.

What am I missing?

Re: Geoprocessing Output

KevinHibma — Wed, 09 Jun 2010 22:42:42 GMT

Josh,

You mentioned your client being a "web client", can you give more details on this?
A web app developed through the ADF, a javascript application, something else?

Re: Geoprocessing Output

JoshEpperson — Thu, 10 Jun 2010 12:53:52 GMT

My web application is a Flex based application, but I haven't even tried to use the service in the application yet. I was looking at the geoprocessing service in the REST API services directory. The listing does not show any output parameters and when I execute it from there it does not show any output. Which leads me into another problem. I can only execute it once. It creates a table in the database the first time, but if I try to run it again I get "Error 500." The logs show an "already exists" error.

Re: Geoprocessing Output

KevinHibma — Thu, 10 Jun 2010 15:09:23 GMT

Thanks Josh, that narrows it down a bunch. It's probably an issue in the model itself.

Could you please attach the TBX and I'll take a look?

Re: Geoprocessing Output

JoshEpperson — Thu, 10 Jun 2010 16:57:14 GMT

Please see attached.

Re: Geoprocessing Output

KevinHibma — Thu, 10 Jun 2010 18:33:39 GMT

Josh,

Changing the output path to:

%scratchworkspace%\scratch.gdb\InfoPoints_Freqency

should get around the already exist error. The %scratchworkspace% tells ArcGIS Server to handle the output, ensuring that nothing is overwritten (or nothing is attempted to be overwrote). Your results will get created at:
C:\arcgisserver\arcgisjobs\<service name>\<unique id>\scratch\scratch.gdb\InfoPoints_Frequency

You're probably already onto this, but the example here shows how results are returned to the client within the JavaScript API from a similar operation
http://resources.esri.com/help/9.3/arcgisserver/apis/javascript/arcgis/help/jssamples/gp_zonalstats.html

Re: Geoprocessing Output

JoshEpperson — Thu, 10 Jun 2010 20:53:57 GMT

Almost there!

I created a new model using your recommendations and created a new test service in Arcgis Server. An Output Parameter is now showing up, but it fails to run. I get this error in the server log:

Executing (MyFrequency): Model %scratchworkspace%\scratch.gdb\InfoPoints_Frequency Start Time: Thu Jun 10 16:44:57 2010 Executing (Frequency): Frequency \\MyServer\Database\MyDB.mdb\MyDataset\InfoPoints D:\arcgisserver\arcgisjobs\atesttools_gpserver\jb54509f6b5f846fda78bf4e4b7d4d714\scratch\scratch.gdb\InfoPoints_Frequency StatusTxt # Start Time: Thu Jun 10 16:44:58 2010 ERROR 000319: Frequency field StatusTxt does not exist A locator with this name does not exist. Failed to execute (Frequency). End Time: Thu Jun 10 16:44:59 2010 (Elapsed Time: 1.00 seconds) Failed to execute (MyFrequency). End Time: Thu Jun 10 16:44:59 2010 (Elapsed Time: 2.00 seconds)

Re: Geoprocessing Output

JoshEpperson — Thu, 10 Jun 2010 21:20:17 GMT

After playing around with it for a bit I removed the ".gdb" from the output path and was successful running it inside of arccatalog. I am still receiving a different error on the server though:

Executing (MyFrequency): Model %scratchworkspace%\scratch\scratch Start Time: Thu Jun 10 17:15:49 2010 Executing (Frequency): Frequency \\myserver\Database\MyDB.mdb\MyDataset\InfoPoints D:\arcgisserver\arcgisjobs\atool_gpserver\j3d55ce6458de4a8b98d08e2ebe651109\scratch\scratch\scratch StatusTxt # Start Time: Thu Jun 10 17:15:50 2010 ERROR 000319: Frequency field StatusTxt does not exist Item not found in this collection. Failed to execute (Frequency). End Time: Thu Jun 10 17:15:51 2010 (Elapsed Time: 1.00 seconds) Failed to execute (MyFrequency). End Time: Thu Jun 10 17:15:51 2010 (Elapsed Time: 2.00 seconds)