QueryTask failing when passed a large geometry/where clause...

[Anonymous User]

Original User: cordel

Hello,
I am running into an issue when querying using either a large where clause or complex geometry.
The query will work when less complex geometries are passed but once they reach a certain size the querytask.execute hangs (no exception thrown/ no timeout).  I have tried using the ExecuteAsync, as well, and had hoped to capture the Failed event, but it is never triggered (hangs as well). 

I had also hoped to inspect the request being sent from the QueryTask to the service using Fiddler, but it appears that something is failing before the request is sent.

I am using a proxy page and it IS working for requests with the smaller geometry/where clause, but never gets invoked when the failure occurs.

Here is a sample of the code in question (nothing complicated, very similar to ESRI samples):

    string[] outFields = new string[] {
          "PPID",
          "CADASTRAL_PPID"
         };

            ESRI.ArcGIS.Client.Tasks.QueryTask queryTask = new ESRI.ArcGIS.Client.Tasks.QueryTask("http://localhost/ArcGIS/rest/services/AGRI/AgriGrid/MapServer/7");

            if (System.Configuration.ConfigurationManager.AppSettings["proxyUrl"].ToString() != "")
            {
                queryTask.ProxyURL = System.Configuration.ConfigurationManager.AppSettings["proxyUrl"].ToString();
            }

            ESRI.ArcGIS.Client.Tasks.Query query = new ESRI.ArcGIS.Client.Tasks.Query();
            // Specify fields to return from query
            query.OutFields.AddRange(outFields);
            query.Geometry = clientPolygon;

            query.SpatialRelationship = ESRI.ArcGIS.Client.Tasks.SpatialRelationship.esriSpatialRelIntersects;
            query.Where = "EXPIRY_DATE is NULL";

            // Return geometry with result features
            query.ReturnGeometry = false;

            try
            {

                ESRI.ArcGIS.Client.Tasks.FeatureSet featureSet = queryTask.Execute(query);

                if (featureSet == null || featureSet.Features.Count < 1)
                {
                    return null;
                }

                foreach (ESRI.ArcGIS.Client.Graphic feature in featureSet.Features)
                {
                    // do business here
                }
            }
            catch (System.Exception ex)
            {
                throw ex;
            }
        }

[Anonymous User]

Original User: cordel

Here is a json snippit of a sample geometry that fails:

{"spatialReference":{"wkid":2957},"rings":[[{"spatialReference":{"wkid":2957},"x":550560.47845779359,"y":5947444.1996372035},{"spatialReference":{"wkid":2957},"x":550725.57878799434,"y":5947393.3995356029},{"spatialReference":{"wkid":2957},"x":550725.57878799434,"y":5947393.3995356029},{"spatialReference":{"wkid":2957},"x":550801.77894039464,"y":5947363.7661430025},{"spatialReference":{"wkid":2957},"x":550869.51240919484,"y":5947287.5659906026},{"spatialReference":{"wkid":2957},"x":550869.51240919484,"y":5947240.9992308021},{"spatialReference":{"wkid":2957},"x":550856.81238379481,"y":5947198.6658128025},{"spatialReference":{"wkid":2957},"x":550831.41233299475,"y":5947101.2989514014},{"spatialReference":{"wkid":2957},"x":550814.47896579467,"y":5946961.5986720016},{"spatialReference":{"wkid":2957},"x":550835.64567479468,"y":5946859.9984688},{"spatialReference":{"wkid":2957},"x":550894.912459995,"y":5946792.2650000006},{"spatialReference":{"wkid":2957},"x":551060.01279019564,"y":5946699.1314804},{"spatialReference":{"wkid":2957},"x":551195.47972779616,"y":5946639.8646952},{"spatialReference":{"wkid":2957},"x":551352.11337439681,"y":5946572.1312264},{"spatialReference":{"wkid":2957},"x":551589.18051519769,"y":5946495.931073999},{"spatialReference":{"wkid":2957},"x":551775.44755439844,"y":5946436.6642887993},{"spatialReference":{"wkid":2957},"x":551927.847859199,"y":5946419.7309215991},{"spatialReference":{"wkid":2957},"x":552042.14808779955,"y":5946419.7309215991},{"spatialReference":{"wkid":2957},"x":552143.74829099991,"y":5946423.9642633991},{"spatialReference":{"wkid":2957},"x":552262.28186140046,"y":5946423.9642633991},{"spatialReference":{"wkid":2957},"x":552393.51545720093,"y":5946436.6642887993},{"spatialReference":{"wkid":2957},"x":552482.41563500126,"y":5946445.1309723994},{"spatialReference":{"wkid":2957},"x":552528.98239480145,"y":5946462.0643396},{"spatialReference":{"wkid":2957},"x":552579.78249640169,"y":5946470.5310232},{"spatialReference":{"wkid":2957},"x":552655.982648802,"y":5946483.2310486},{"spatialReference":{"wkid":2957},"x":552749.11616840237,"y":5946491.697732199},{"spatialReference":{"wkid":2957},"x":552850.71637160273,"y":5946504.3977575991},{"spatialReference":{"wkid":2957},"x":552918.449840403,"y":5946512.8644411992},{"spatialReference":{"wkid":2957},"x":552977.71662560327,"y":5946521.3311247993},{"spatialReference":{"wkid":2957},"x":553083.55017060367,"y":5946534.0311501995},{"spatialReference":{"wkid":2957},"x":553180.9170320041,"y":5946550.9645174},{"spatialReference":{"wkid":2957},"x":553219.01710820431,"y":5946576.3645682},{"spatialReference":{"wkid":2957},"x":553248.65050080442,"y":5946622.931328},{"spatialReference":{"wkid":2957},"x":553290.98391880456,"y":5946724.5315312007},{"spatialReference":{"wkid":2957},"x":553295.21726060461,"y":5946804.9650254007},{"spatialReference":{"wkid":2957},"x":553278.28389340453,"y":5946889.6318614008},{"spatialReference":{"wkid":2957},"x":553248.65050080442,"y":5946953.1319884015},{"spatialReference":{"wkid":2957},"x":553159.750323004,"y":5947025.0987990014},{"spatialReference":{"wkid":2957},"x":553066.61680340359,"y":5947088.5989260022},{"spatialReference":{"wkid":2957},"x":552956.54991660325,"y":5947126.6990022017},{"spatialReference":{"wkid":2957},"x":552850.71637160273,"y":5947152.099053002},{"spatialReference":{"wkid":2957},"x":552761.8161938024,"y":5947156.332394802},{"spatialReference":{"wkid":2957},"x":552622.11591440183,"y":5947156.332394802},{"spatialReference":{"wkid":2957},"x":552469.71560960123,"y":5947164.7990784021},{"spatialReference":{"wkid":2957},"x":552291.91525400057,"y":5947177.4991038023},{"spatialReference":{"wkid":2957},"x":552080.24816399976,"y":5947202.8991546026},{"spatialReference":{"wkid":2957},"x":551987.11464439938,"y":5947215.5991800018},{"spatialReference":{"wkid":2957},"x":551889.747782999,"y":5947232.532547202},{"spatialReference":{"wkid":2957},"x":551766.98087079846,"y":5947245.2325726021},{"spatialReference":{"wkid":2957},"x":551656.913983998,"y":5947262.1659398023},{"spatialReference":{"wkid":2957},"x":551601.88054059783,"y":5947274.8659652025},{"spatialReference":{"wkid":2957},"x":551512.98036279739,"y":5947287.5659906026},{"spatialReference":{"wkid":2957},"x":551343.64669079671,"y":5947308.7326996028},{"spatialReference":{"wkid":2957},"x":551246.2798293964,"y":5947334.1327504022},{"spatialReference":{"wkid":2957},"x":551170.0796769961,"y":5947355.2994594024},{"spatialReference":{"wkid":2957},"x":551064.24613199569,"y":5947397.6328774029},{"spatialReference":{"wkid":2957},"x":551026.14605579549,"y":5947427.2662700033},{"spatialReference":{"wkid":2957},"x":551047.31276479561,"y":5947461.1330044027},{"spatialReference":{"wkid":2957},"x":551089.64618279575,"y":5947465.3663462028},{"spatialReference":{"wkid":2957},"x":551187.01304419618,"y":5947465.3663462028},{"spatialReference":{"wkid":2957},"x":551381.74676699692,"y":5947461.1330044027},{"spatialReference":{"wkid":2957},"x":551606.11388239777,"y":5947414.5662446031},{"spatialReference":{"wkid":2957},"x":551682.31403479807,"y":5947393.3995356029},{"spatialReference":{"wkid":2957},"x":551762.74752899841,"y":5947393.3995356029},{"spatialReference":{"wkid":2957},"x":551860.11439039884,"y":5947389.1661938028},{"spatialReference":{"wkid":2957},"x":551923.61451739911,"y":5947393.3995356029},{"spatialReference":{"wkid":2957},"x":552029.44806239952,"y":5947406.099561003},{"spatialReference":{"wkid":2957},"x":552274.98188680049,"y":5947439.9662954034},{"spatialReference":{"wkid":2957},"x":552626.34925620188,"y":5947490.7663970031},{"spatialReference":{"wkid":2957},"x":552905.749815003,"y":5947490.7663970031},{"spatialReference":{"wkid":2957},"x":553036.98341080348,"y":5947473.8330298029},{"spatialReference":{"wkid":2957},"x":553130.11693040386,"y":5947435.7329536034},{"spatialReference":{"wkid":2957},"x":553180.9170320041,"y":5947414.5662446031},{"spatialReference":{"wkid":2957},"x":553312.15062780457,"y":5947380.6995102027},{"spatialReference":{"wkid":2957},"x":553430.68419820513,"y":5947346.8327758024},{"spatialReference":{"wkid":2957},"x":553511.11769240547,"y":5947304.4993578028},{"spatialReference":{"wkid":2957},"x":553625.41792100586,"y":5947253.6992562022},{"spatialReference":{"wkid":2957},"x":553697.38473160611,"y":5947207.1324964026},{"spatialReference":{"wkid":2957},"x":553731.25146600627,"y":5947143.6323694019},{"spatialReference":{"wkid":2957},"x":553748.18483320635,"y":5947037.7988244016},{"spatialReference":{"wkid":2957},"x":553777.81822580646,"y":5946859.9984688},{"spatialReference":{"wkid":2957},"x":553824.38498560665,"y":5946673.7314296},{"spatialReference":{"wkid":2957},"x":553866.71840360679,"y":5946487.4643904},{"spatialReference":{"wkid":2957},"x":553807.45161840657,"y":5946326.5974019989},{"spatialReference":{"wkid":2957},"x":553650.81797180593,"y":5946233.4638823988},{"spatialReference":{"wkid":2957},"x":553473.01761620527,"y":5946174.1970971981},{"spatialReference":{"wkid":2957},"x":553261.35052620445,"y":5946174.1970971981},{"spatialReference":{"wkid":2957},"x":552990.4166510033,"y":5946165.730413598},{"spatialReference":{"wkid":2957},"x":552761.8161938024,"y":5946195.3638061984},{"spatialReference":{"wkid":2957},"x":552435.84887520107,"y":5946195.3638061984},{"spatialReference":{"wkid":2957},"x":552114.1148983998,"y":5946195.3638061984},{"spatialReference":{"wkid":2957},"x":551682.31403479807,"y":5946140.3303627977},{"spatialReference":{"wkid":2957},"x":551170.0796769961,"y":5946182.6637807982},{"spatialReference":{"wkid":2957},"x":550945.71256159514,"y":5946237.6972241988},{"spatialReference":{"wkid":2957},"x":550746.74549699435,"y":5946195.3638061984},{"spatialReference":{"wkid":2957},"x":550543.54509059351,"y":5946241.9305659989},{"spatialReference":{"wkid":2957},"x":550488.51164719334,"y":5946271.5639585983},{"spatialReference":{"wkid":2957},"x":550158.310986792,"y":5946402.7975543989},{"spatialReference":{"wkid":2957},"x":550107.51088519185,"y":5946474.764365},{"spatialReference":{"wkid":2957},"x":550077.87749259174,"y":5946546.7311756},{"spatialReference":{"wkid":2957},"x":549904.310478791,"y":5946618.6979861995},{"spatialReference":{"wkid":2957},"x":549891.610453391,"y":5946720.2981894007},{"spatialReference":{"wkid":2957},"x":549942.4105549911,"y":5946919.2652540011},{"spatialReference":{"wkid":2957},"x":549912.777162391,"y":5946974.2986974008},{"spatialReference":{"wkid":2957},"x":549900.077136991,"y":5947029.3321408015},{"spatialReference":{"wkid":2957},"x":549963.57726399123,"y":5947152.099053002},{"spatialReference":{"wkid":2957},"x":550001.67734019144,"y":5947245.2325726021},{"spatialReference":{"wkid":2957},"x":549895.84379519091,"y":5947346.8327758024},{"spatialReference":{"wkid":2957},"x":549933.94387139112,"y":5947448.4329790035},{"spatialReference":{"wkid":2957},"x":550513.9116979934,"y":5947456.8996626027},{"spatialReference":{"wkid":2957},"x":550560.47845779359,"y":5947444.1996372035}]]}