Query Task Fails on Lookup Table in REST

Ryan Kelley

May 03, 2014 00:41

I have a situation where both my Query Task and ComboBox are failing when trying to retrieve records from a stand alone table from a map service. I have NO issue querying for values at the REST endpoint of the same map service. I am also using False for my Return Geometry parameter in the Query Task. Additionally, querying non-stand alone tables are not an issue from the same map service via the Query Task.

Essentials 4.0.1.

Can anyone shed some light?

Not that this error reveals anything... but:

Error: Unhandled exception: 'One or more errors occurred.' in activity '1.789: QueryTask'.

 

  One or more errors occurred.

 

    Failed to execute query.

 

External Activity: 153 bytes received by client

Ryan

0

• 

  Permanently deleted user

  May 03, 2014 05:16

  Hi Ryan,

   

   A Query task activity works on an ArcGIS Server REST endpoint. You want to use an searchTableParameterQuery activity for getting this information from Geocortex Essentials Server's REST endpoint. 

  See this post for an example (Sample Workflow LA County):

  http://support.geocortex.com/SupportForums/Thread.aspx?thread=55359&mid=2&pageid=0&ItemID=20&pagenumber=1#post153728

  regards,

   

  Edmond

  0
• 

  Ryan Kelley

  May 04, 2014 20:42

  Thanks Edmond. I am a bit confused on this. The Lookup Table is in the ArcGIS Server REST endpoint, but the Query Task is failing trying to query anything from that. It seems like a big extra step to register this as a Search Table and query that, get the attribute values, etc. I was trying to look at the examples but they did not load - assuming they were built in a new version on Workflow Designer 2.20.1.3.

   

  Is a Query Task supposed to be able to retrieve records from a table 'queryable' in the ArcGIS Server REST endpoint? Seems to me like if I can get returns from the REST endpoint, the Query Task should be able to as well.

  thanks,

   

  ryan

   

   

  0
• 

  Ryan Kelley

  May 04, 2014 21:12

  Well, this was my mistake. The Query Task does now work with the said LU tables. Not sure what I was doing wrong at this point, but I decided just to rebuild the Query Task.

  Ryan

  0
• 

  Permanently deleted user

  May 05, 2014 22:43

  Hi Ryan,

   Sorry for the confusion - the wording "stand-alone" tables implied to me that the data was in a non GIS database.

  regards,

   

  Edmond

   

   

  0

Please sign in to leave a comment.