GE 4.2.0: Geocortex can’t query from the “Area” field,

Permanently deleted user

23. Oktober 2014 02:14

GE 4.2.0: Geocortex can’t query from the “Area” field,

I couldn’t figure out why the Gecortex is not able to query from the “Area” field given that the layer is enterprise (SQL)

What might be the issue here?

Thank you

Best

Jamal

 

/customer/servlet/servlet.FileDownload?file=00P6000000elzpeEAA

 

/customer/servlet/servlet.FileDownload?file=00P6000000elzXuEAI

 

/customer/servlet/servlet.FileDownload?file=00P6000000elu9pEAA

0

• 

  Conner Leverett

  23. Oktober 2014 04:25

  Hi Jamal,

  Are you able to perform the query directly from the query endpoint of the ArcGIS layer? For example, something like http://{servername.domain.com}/arcgis/rest/services/{service name}/MapServer/0/query. If you can't perform the query at the endpoint, then this is an ArcGIS for Server issue and may be related to the version you are using. If you are using 10.2+, you may need to disable standardized queries in order for this to work. Note that disabling standardized queries is not recommend by Esri as it potentialy exposes you to SQL injection attacks.

  Cheers,

  -Darren

  0
• 

  Permanently deleted user

  23. Oktober 2014 05:58

  Hi Jamal,

  We have this issue as well, we reported it to our local geocortex provider and I dont think they have been able to solve it.

  The work around we use is to use the advanced query builder and replace "Shape.STArea()" with "Shape.Area" (ignore quotes) and the rest of your query and it should work.

  Would like a proper solution though.

  Cheers,

  Graeme

  0
• 

  Permanently deleted user

  24. Oktober 2014 16:03

  Many thanks Darren and Graeme for the very useful input.

  Correct. It is ArcGIS Server issue. The service that are coming from SQL feature classes don’t have “query” as allowed operation despite the fact that it is checked as allowed in the service

  I tried Graeme’s approach and it works fine.

   

  /customer/servlet/servlet.FileDownload?file=00P6000000elzTOEAY

   

  /customer/servlet/servlet.FileDownload?file=00P6000000eltqjEAA

   

  Best

  Jamal

  0
• 

  Permanently deleted user

  26. Oktober 2014 02:24

  Hi all,

  Darren solution also works, I tried disabling standardized queries, and the query went well at the ArcGIS Server level and also with simple query.

  /customer/servlet/servlet.FileDownload?file=00P6000000elzgNEAQ

   

  /customer/servlet/servlet.FileDownload?file=00P6000000em1AzEAI

  0
• 

  Permanently deleted user

  26. Oktober 2014 14:11

  Thanks Hani,

  May you please provide screenshots to show how to disable the “standardized query”?

  0
• 

  Permanently deleted user

  26. Oktober 2014 14:56

  Screenshots:

   

  1-

  /customer/servlet/servlet.FileDownload?file=00P6000000em1OXEAY

   

  2-

  /customer/servlet/servlet.FileDownload?file=00P6000000em1d8EAA

  3- 

  /customer/servlet/servlet.FileDownload?file=00P6000000elzcfEAA

   

  4- 

  /customer/servlet/servlet.FileDownload?file=00P6000000em1LsEAI

   

  5-

  /customer/servlet/servlet.FileDownload?file=00P6000000elzq8EAA

   

  6-

  /customer/servlet/servlet.FileDownload?file=00P6000000elzSVEAY

   

  0
• 

  Permanently deleted user

  26. Oktober 2014 15:28

  You have to restart ArcGIS Server Service after that to take the effect.

  0
• 

  Permanently deleted user

  26. Oktober 2014 17:41

  Many thanks Hani for the input. This is very useful.

  Best

  Jamal

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.