topic Re: new problem REST query 10.1 - every other request fails (400 unable to complete oper) in ArcGIS Enterprise Questions

new problem REST query 10.1 - every other request fails (400 unable to complete oper)

deleted-user-Ohz6rwd1kavx — Thu, 13 Dec 2012 14:17:25 GMT

Hi

We are upgrading to ArcGIS Server 10.1 SP1 from 10.0.

We have noticed a new problem where REST layer queries are failing every other request. It is quite strange, but you can reproduce it by simply reissuing requests in browser or Fiddler.

Here is an example request (can use &f=html also, same result).

http://serverx/arcgis/rest/services/foldery/servicez/MapServer/0/query?where=%28%28KeyInstn+in+%28103036%29%29%29&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=102100&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=json

Every other request fails with this result (json):

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

Clue:I started looking this while tracking down possible change to how ESRI is treating OutputFields in 10.1 compared to 10.0.

Anybody else seeing this?

Any recommendations on where to check next to narrow this one down?

Thanks,

-Cory

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

StevenMoore1 — Thu, 13 Dec 2012 19:24:57 GMT

This is a known issues with 10.1 SP1, and has been logged as the following bug:

[ NIM086349 - Alternate Query (Get) requests fail in Version 10.1 SP1 ]

I don't know when this is scheduled to be fixed, but if you contact Support you can be attached to the bug. You can also check the status here:

http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDg2MzQ5

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

deleted-user-Ohz6rwd1kavx — Fri, 14 Dec 2012 12:18:22 GMT

Thanks for the reply and the link. This nimbus link worked better for me.

http://support.esri.com/en/bugs/nimbus/TklNMDg2MzQ5

We will be contacting support and requesting a fix (hopefully soon!) for this.

Do you know of any workarounds aside from issuing the request again if it fails the first time?

Thanks,

-Cory

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

nicogis — Sat, 11 Dec 2021 07:53:15 GMT

The workarounds are

you can do request in POST

or

dirty the query


var dirty = (new Date()).getTime();
var query = new esri.tasks.Query();
query.where = "MyField= " + MyValue+ " AND " + dirty + "=" + dirty; 
...

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

deleted-user-Ohz6rwd1kavx — Tue, 18 Dec 2012 17:55:04 GMT

Hi Domenico,

Thank you for the ideas, very helpful.

I have implemented your 'dirty' suggestion, and it appears to be working.

For anyone using the ESRI Silverlight API, you can set FeatureLayer.DisableClientCaching = true. This will add a unique time stamp parameter to the underlying REST request.... I found however that QueryTask does not behave this way. Thererfore, in this case, I followed the advice of generating a random time stamp and adding it to the Where.

Thanks very much again,

-Cory

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

JoseThomas — Fri, 11 Jan 2013 18:51:30 GMT

This problem occurs only when the data of the MapService is FileGDB based or data is not copied to the server while publishing.

You can workaround this using either of these
1) Choose copy data to the Server while publishing the service
2) Change to Enterprise GDB
3) Change the service configuration to set "hasStaticData": "true", if your service data doesn�??t change.
http://hostname:6080/arcgis/admin/se...MapServer/edit

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

CarmenDurham — Mon, 01 Apr 2013 19:13:59 GMT

Do you know if using map services using layers in SQL Express DB with SDE for Workgroup will work? I am trying to avoid using our current SQL Server 2005 (yes, we are stuck with this for now) for these particular map services. We were going to try to use a file gdb that is updated weekly through python.

Thanks,
Carmen

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

deleted-user-Ohz6rwd1kavx — Mon, 01 Apr 2013 19:20:27 GMT

Hi

Interesting note from josethom

The REST mapservices that I am using sit on top of both SQL Server 2008 and.... file geodatabases.

I did not investigate whether we were seeing this problem with just the file geodatabase-based services, but this could be the case.

Anyway, thanks for the reply, and I hope this additional note helps someone.

-Cory

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

TonyCollins — Mon, 03 Jun 2013 09:45:24 GMT

Has this been resolved yet?

This is clearly a massive bug that you can't use FGDB based services IF you want to perform queries?

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

HaroldBostic — Fri, 02 Aug 2013 02:02:41 GMT

This issue have been resolved in 10.2, for those at 10.1 using the Flex API, you can use the hack listed here http://help.arcgis.com/en/webapi/flex/help/index.html#//017p00000016000000 by which you can set the token paramenter to anything in order to force a POST request.

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

TerryGiles — Thu, 29 Aug 2013 16:30:52 GMT

This issue pops up when you add a feature layer to a map too (using JSAPI at least). In that case, how would I add a time stamp to alter the query string ?

Thanks, TG

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

deleted-user-Ohz6rwd1kavx — Thu, 29 Aug 2013 18:13:11 GMT

Hi Terry

Does this property (or something similar) exist on the java script FeatureLayer?

FeatureLayer.DisableClientCaching = true

This was one solution to this problem in the Silverlight world. Works for us here anyway.

After setting this property, we checked Fiddler and found that the esri framework was adding a timestamp to the 'query' request underlying the client-side FeatureLayer. This makes each the request unique and works around the issue being discussed.

-Cory

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

TerryGiles — Thu, 29 Aug 2013 19:02:54 GMT

Cory,

Thanks for the idea but there's no equivalent to disableClientCaching in the JS API. I've used that in the SL api in the past to make sure data from a feature layer based on a query layer (pulling lat/longs from SQL server) would refresh after the underlying DB was updated.

TG

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

BenSainsbury1 — Wed, 18 Sep 2013 19:46:32 GMT

Pathetic! not upgrading to 10.2 to fix this....

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

raffia — Thu, 05 Dec 2013 00:46:01 GMT

Hello;

Any updates to this thread? It is driving me crazy how can one simply upgrade from 10.0 to 10.1 an just because of that all hell breaks loose. I am using a file GDB and Flex API and the apps are throwing errors left and right

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

LukeBehling — Fri, 31 Jan 2014 19:19:10 GMT

Cory,

Thanks for the idea but there's no equivalent to disableClientCaching in the JS API. I've used that in the SL api in the past to make sure data from a feature layer based on a query layer (pulling lat/longs from SQL server) would refresh after the underlying DB was updated.

TG

Terry, did you ever get anything for this in the JS API? Or did you force it to use a POST, if so how did you go about doing that? I as well can't upgrade to 10.2 for this..

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

TerryGiles — Fri, 31 Jan 2014 19:30:28 GMT

Luke,

I moved the data for that service from a file geoDB into SDE and it seemed to solve the problem. But I found out the other day that our SDE license expired so I had to switch back to the file geoDB and every other request failure. Haven't moved to 10.2 yet so cannot say for sure that'll fix it. I'm lucky though as the service is just for an internal demonstration site.

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

LukeBehling — Wed, 05 Feb 2014 11:29:07 GMT

That worked - I moved the table back into SDE and now I do not get the error.

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

TerryGiles — Mon, 10 Feb 2014 20:42:32 GMT

Update -

Esri released a Quality Improvement Patch for 10.1 SP1 (desktop, engine, & server) at the end of January 2014. You can find it in the Support -> Patches and Service Packs pages here. In the 15 pages of issued addressed is NIM086349 which SKMoore identified above as the problem.

Hope this helps, seems to have fixed the issue on my server.

Terry

Re: new problem REST query 10.1 - every other request fails (400 unable to complete o

JessicaLott — Sat, 11 Dec 2021 07:53:18 GMT

The workarounds are

you can do request in POST

or

dirty the query


var dirty = (new Date()).getTime();
var query = new esri.tasks.Query();
query.where = "MyField= " + MyValue+ " AND " + dirty + "=" + dirty; 
...

Is this how I would accomplish this in C#?

 var dirty = DateTime.UtcNow;
            Query query = new Query();
            query.ReturnGeometry = true;
            query.OutFields.Add("*");
            query.Where = QueryParametersTextbox.Text + " AND " + dirty + "=" + dirty;

Thanks in advance.