topic Re: ArcGIS server 10.1 rest api queries fail inconsistently in ArcGIS Enterprise Questions

ArcGIS server 10.1 rest api queries fail inconsistently

karenpayne — Mon, 02 Mar 2015 22:11:06 GMT

Apologies for posting this both here and GIS.stackExchange (ArcGIS server 10.1 rest api queries fail inconsistently - Geographic Information Systems Stack Exchange)

I have a set of Map and Esri Feature Services running on a 10.1 ArcGIS Server, with SQL Server in the back end.

When I query the layers for either the geometry or OIDs using the rest interface, the query only works in certain instances.

If I query a point layer the result works as expected and I get the data
If I query a polygon layer like this, it fails: http://gistmapsdev.itos.uga.edu/arcgis/rest/services/COD_External/SYR_AR_DynamicLabeling/FeatureServer/5/query?returnGeometry=true&f=json

I get the error message

{"error":{"code":400,"message":"Unable
to complete operation.","details":["Unable to perform query
operation."]}}

The server log files show: Database error:

Operation without query criteria is not allowed.

However this query (same service, different polygon layer) works as expected and returns the feature geometry:

http://gistmapsdev.itos.uga.edu/arcgis/rest/services/COD_External/SYR_AR_DynamicLabeling/FeatureServer/6/query?returnGeometry=true&f=json

There are 2 polygon layers that I can query and get the expected result but all other polygon layers fail and for the life of me I cannot see any difference in the properties of the feature classes that fail vs those that do not.

If I dirty the query (by adding a where clause 1=1) I get the expected result; so for example, this query works:

http://gistmapsdev.itos.uga.edu/arcgis/rest/services/COD_External/SYR_AR_DynamicLabeling/FeatureServer/5/query?where=1%3D1&returnGeometry=true&f=json

What I’ve looked at:

I have not hit the max feature limit set on the server or the service
the behavior is consistent across browsers
the behavior is consistent using either get or post
I have rebuilt the spatial indices
The behavior is consistent if I ask for json or html response

I’d be grateful for any pointers or areas that I should look at.

Thanks in advance!

Message was edited by: Asrujit SenGupta

Re: ArcGIS server 10.1 rest api queries fail inconsistently

XanderBakker — Tue, 03 Mar 2015 01:06:58 GMT

Strange, all 3 URL's posted return a valid result for me...

Re: ArcGIS server 10.1 rest api queries fail inconsistently

karenpayne — Tue, 03 Mar 2015 12:09:59 GMT

Now that's interesting thanks Xander! I'll work on our outside tester this morning.

Re: ArcGIS server 10.1 rest api queries fail inconsistently

karenpayne — Tue, 03 Mar 2015 12:12:06 GMT

Actually my mistake, the first link (that doesn't work) should be

http://gistmapsdev.itos.uga.edu/arcgis/rest/services/COD_External/SYR_AR_DynamicLabeling/FeatureServer/5/query?geometryT…

Re: ArcGIS server 10.1 rest api queries fail inconsistently

XanderBakker — Tue, 03 Mar 2015 12:29:22 GMT

That URL indeed does not work (although I'm using a different network than yesterday).

I though this might be due to specifying the geometryType parameter without specifying a geometry, but when I remove it, it still does not work. When adding the 1=1 as whereclause it does work... (as you said).

Re: ArcGIS server 10.1 rest api queries fail inconsistently

XanderBakker — Tue, 03 Mar 2015 12:39:35 GMT

I see that you are using ArcGIS for Server 10.1 SP1. If I use the query on a service here using the exact same parameters it throws me this error:

{"error":{"code":400,"message":"Invalid or missing input parameters.","details":[]}}

Different from yours, but still an error. I think you can best include the where clause 1=1 or using a random number (random number = random number) to avoid it.

In case you don't want to specify a where clause you can still use the geometry with an envelope that covers the area:

http://gistmapsdev.itos.uga.edu/arcgis/rest/services/COD_External/SYR_AR_DynamicLabeling/FeatureServer/5/query?geometryT…

Re: ArcGIS server 10.1 rest api queries fail inconsistently

karenpayne — Tue, 03 Mar 2015 13:19:52 GMT

Thanks for looking at this Xander. Interesting workaround with the envelope; that's good to know. thanks again,

Re: ArcGIS server 10.1 rest api queries fail inconsistently

BrianMcAuslan — Tue, 31 Oct 2017 00:56:53 GMT

my error

{"error":{"code":400,"message":"Invalid or missing input parameters.","details":[]}}

however 1=1 worked for me. thx

not sure if related to the error i was getting but found one of the geometry features had no coords

{
"attributes": {
"Name": "sample"
},
"geometry": {
"rings": [

]
}