topic Re: QueryTask Error on Joined Layer in Map Service in ArcGIS REST APIs and Services Questions

QueryTask Error on Joined Layer in Map Service

ScottDavis — Wed, 09 Feb 2011 21:53:49 GMT

I have a map service with a layer that is joined to an external SDE database. When I try to perform a query through the services directory I get the error message, "Unable to perform query. Please check your parameters." The server logs two error messages, "General GeoDatabase Error." & "Method failed.HRESULT = 0x80070057 : The parameter is incorrect. ."

Here is my test:
http://172.16.17.48/ArcGIS/rest/services/OilGasMining/MapServer/0/query?text=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&where=COMPANY_NAME+%3D+'BILL+BARRETT+CORP'&returnGeometry=true&outSR=&outFields=&f=html

Just wondering if anyone else has had this problem.

Re: QueryTask Error on Joined Layer in Map Service

RaviNarayanan — Thu, 10 Feb 2011 17:13:05 GMT

Are you able to execute an identify on this layer and get the fields from the joined table?

From the error messages, this sounds like a failure in the geodatabase. Please contact ESRI Support and submit a request to investigate this further.

Re: QueryTask Error on Joined Layer in Map Service

RaviNarayanan — Mon, 14 Feb 2011 16:07:16 GMT

Scott,
Please see http://resources.arcgis.com/content/nimbus-bug?bugID=TklNMDQ1MjU5 for information on related bug report. This is marked as non reproduced in 10.0.

Re: QueryTask Error on Joined Layer in Map Service

JacobLesser — Tue, 27 Mar 2012 15:16:26 GMT

I know this is an old post. I got the same error with ArcGIS Server 10 and PostgreSQL when joining a feature class to an SDE table. The solution turned out to be that when doing a join, the column names are prepended with the original table names, so my columns look like table1.field1 and table2.field2 instead of just field1 and field2. In the case of postgresql, I actually needed to append my database and schema names, so the outfields look like database.schema.table1.field1, etc.

Just wanted to share in case anybody else stumbles on this post like I did.