nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

deleted-user-Ohz6rwd1kavx

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

Finde mehr Beiträge mit dem Tag

Accepted answers

StevenMoore1

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

All comments

StevenMoore1

deleted-user-Ohz6rwd1kavx

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

nicogis

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; 
...

deleted-user-Ohz6rwd1kavx

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

JoseThomas

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

ctalleygreenville

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

AshleyCofrin_0-1755813066393.png

deleted-user-Ohz6rwd1kavx

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

TonyCollins

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?

HaroldBostic

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.

TerryGiles

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

deleted-user-Ohz6rwd1kavx

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

TerryGiles

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

BenSainsbury1

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

raffia

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

LukeBehling

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..

TerryGiles

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.

LukeBehling

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

TerryGiles

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

JessicaLott

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.

TerryGiles

Jessica,

That's pretty close, but since DateTime.UtcNow will return a DateTime object, you'll need to convert that into something that can be put in the where clause -

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

Terry

BillyYancey

I am on 10.2.2 all updates and patches applied and JS API 3.10 and I still have the issue. even sequencing the queries will not work, nor does the "dirty" query technique. I have not been able to make JS API to use POST yet (not sure if I can) and I am on enterprise geodatabase (postgres). Two queries back to back or simultaneous, the first one always successful, the second one fails. Reordering them guarantees that there is no issue with the query itself. Extremely frustrating...

SadanandacharB1

Hi, still you have the same issue ?

ref ArcGIS Help (10.2, 10.2.1, and 10.2.2)

Sadanand.

BillyYancey

No! I am not sure how did I solve it though. IT was a long time ago.

SadanandacharB1

Even I had the same issue in Sliverlight api with server 10.2.1, FeatureLayer query fails when using date in where clause.

It works for me when change the query syntax like below:

featureLayer.Where = "SURVEY_DATE >= date '" + dpFromDate.SelectedDate.Value.ToString("yyyy-MM-dd")

+ "' and SURVEY_DATE <= date '" + dpToDate.SelectedDate.Value.ToString("yyyy-MM-dd") + "'";

ref the link for more details : ArcGIS Help (10.2, 10.2.1, and 10.2.2)

JoanneMcGraw

In case anyone else comes up against this bug working with a FeatureLayer in a dynamic workspace (which I did), I implemented the above workaround in JSAPI by adding a definitionExpression similar to above. For example:

var dirty = (new Date()).getTime();

var lyrDynamic = new FeatureLayer(

serviceurl + "/dynamicLayer"

id: "dynamicLayer"

,mode: FeatureLayer.MODE_ONDEMAND

,outFields: ["CLASS"]

,source: layerSource

,definitionExpression: dirty + "=" + dirty

}

);

Cheers,

jtm

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.