topic Re: Returning a table from Geoprocessing Service in Python Questions

Returning a table from Geoprocessing Service

JoeHershman — Sun, 08 Jul 2012 04:43:32 GMT

I think this is probably really simple to do but I cannot seem to figure out how to return a table from a Geoprocessing service. My service creates a table and I want to return that to the caller. Documentation indicates a table can be used as the return value and AGS will convert it to a FeatureSet to return. I have tried numerous incarnations of SetParameter or SetParameterAsText with different values as the return parameter and keep getting

RuntimeError>Object:Error Setting Parameter (or Parameter as Text)

Can anyone post a sample of how I would return a table from my scratch workspace as the result of a GP Service

Thanks
-Joe

Re: Returning a table from Geoprocessing Service

KevinBell — Wed, 11 Jul 2012 21:00:14 GMT

BUMP!

I'd really like a sample too! I have a table in a fgdb that needs to be graphed on the client...

Re: Returning a table from Geoprocessing Service

NilsBabel — Tue, 18 Dec 2012 14:38:11 GMT

I think this is probably really simple to do but I cannot seem to figure out how to return a table from a Geoprocessing service. My service creates a table and I want to return that to the caller. Documentation indicates a table can be used as the return value and AGS will convert it to a FeatureSet to return. I have tried numerous incarnations of SetParameter or SetParameterAsText with different values as the return parameter and keep getting

RuntimeError>Object:Error Setting Parameter (or Parameter as Text)

Can anyone post a sample of how I would return a table from my scratch workspace as the result of a GP Service

Thanks
-Joe

Hi Joe. Did you ever figure this out? I'm having the same problem. I have a script that creates a table as an output in the scratch workspace. I know the script works correctly because I can see the output table in the jobs folder. But the service will not return the table. When it gets to the final step I get an error that says the job failed because of crash or termination of the server object. I have tried setting an output parameter with a default value and GetParameterAsText, a derived table and SetParameterAsText, and a derived recordset with SetParameterAsText. I even put my script in a model and published that. Same result every time. The geprocessing service examples are nice but can you actually get GP services to work with your own solution?

Re: Returning a table from Geoprocessing Service

GrantHaynes — Mon, 18 Feb 2019 23:07:30 GMT

I stumbled upon this thread and am trying to do the same thing, has anyone here figured this out?

Re: Returning a table from Geoprocessing Service

JoeHershman — Thu, 28 Feb 2019 00:09:13 GMT

I am guessing I ended up using a non-python approach, but I can barely remember what I did Monday let alone in 2012

Re: Returning a table from Geoprocessing Service

GrantHaynes — Thu, 07 Mar 2019 23:23:54 GMT

No worries.