topic Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008 in ArcGIS JavaScript Maps SDK Questions

Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

S_Ector — Mon, 04 Apr 2011 14:59:58 GMT

I have ArcGIS Server Enterprise with ArcSDE/PostgreSQL running on one windows XP machine. All queries, including spatial queries are working as expected. Then I moved the data and maps to another installation of ArcGIS Server Enterprise on Windows 2008 Server 64bit with ArcSDE/PostgreSQL on a separate Windows 2008 Server 64bit. I can re-run the javascript against the new installation and all of the spatial queries return an error:

TypeError: _297 is null
(undefined="null", undefined="[object Object]")arcgis?v=2.2 (line 48)
(undefined="null")arcgis?v=2.2 (line 14)
_144()arcgis?v=2.2 (line 14)
_142(undefined="null")arcgis?v=2.2 (line 14)
(undefined="null")arcgis?v=2.2 (line 14)
_144()arcgis?v=2.2 (line 14)
_142(undefined="[object Object]")arcgis?v=2.2 (line 14)
[Break On This Error]

If I comment out the code that includes the spatial query, the data is returned just fine. Here is the code where I am having problems. The query results are never returned and the inline function does not get executed:

    pquery.returnGeometry = false;
    pquery.outFields = ["*"];
    pquery.geometry = geometry;
    pquery.spatialRelationship = query.SPATIAL_REL_CONTAINS;
pquery.where = "length (huc_id) = 8";
    hucCtrFeatureLayer.selectFeatures(pquery, esri.layers.FeatureLayer.SELECTION_NEW, function (features) {
        if (features.length > 0) {
            dojo.byId("messages").innerHTML = "HUC 8 Features found: " + features.length;
        } else {
            dojo.byId("messages").innerHTML = "No HUC 8 features found.";
        }
    }, displayErr);

If I comment out these 2 lines, the query works just fine:
    pquery.geometry = geometry;
    pquery.spatialRelationship = query.SPATIAL_REL_CONTAINS;

This same error is occurring for all spatial queries regardless of the layers. I checked for spatial indexing and the layers being queried are showing they have a spatial index.

Any ideas? Thanks.

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

HemingZhu — Thu, 07 Apr 2011 18:11:08 GMT

I have ArcGIS Server Enterprise with ArcSDE/PostgreSQL running on one windows XP machine. All queries, including spatial queries are working as expected. Then I moved the data and maps to another installation of ArcGIS Server Enterprise on Windows 2008 Server 64bit with ArcSDE/PostgreSQL on a separate Windows 2008 Server 64bit. I can re-run the javascript against the new installation and all of the spatial queries return an error:

TypeError: _297 is null
(undefined="null", undefined="[object Object]")arcgis?v=2.2 (line 48)
(undefined="null")arcgis?v=2.2 (line 14)
_144()arcgis?v=2.2 (line 14)
_142(undefined="null")arcgis?v=2.2 (line 14)
(undefined="null")arcgis?v=2.2 (line 14)
_144()arcgis?v=2.2 (line 14)
_142(undefined="[object Object]")arcgis?v=2.2 (line 14)
[Break On This Error]

If I comment out the code that includes the spatial query, the data is returned just fine. Here is the code where I am having problems. The query results are never returned and the inline function does not get executed:

    pquery.returnGeometry = false;
    pquery.outFields = ["*"];
    pquery.geometry = geometry;
    pquery.spatialRelationship = query.SPATIAL_REL_CONTAINS;
pquery.where = "length (huc_id) = 8";
    hucCtrFeatureLayer.selectFeatures(pquery, esri.layers.FeatureLayer.SELECTION_NEW, function (features) {
        if (features.length > 0) {
            dojo.byId("messages").innerHTML = "HUC 8 Features found: " + features.length;
        } else {
            dojo.byId("messages").innerHTML = "No HUC 8 features found.";
        }
    }, displayErr);

If I comment out these 2 lines, the query works just fine:
    pquery.geometry = geometry;
    pquery.spatialRelationship = query.SPATIAL_REL_CONTAINS;

This same error is occurring for all spatial queries regardless of the layers. I checked for spatial indexing and the layers being queried are showing they have a spatial index.

Any ideas? Thanks.

have you add your new services directory to your proxy.config. When you do a spatial query, it usually involved geometry-huge querysting!. That means that most likely your query have to go throug POST not GET...

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

S_Ector — Thu, 07 Apr 2011 19:28:57 GMT

have you add your new services directory to your proxy.config. When you do a spatial query, it usually involved geometry-huge querysting!. That means that most likely your query have to go throug POST not GET...

I've been wondering about that, too since I can run the query using the REST query form. But, still no luck figuring it out.

Here is my proxy.config file.

<?xml version="1.0" encoding="utf-8" ?>

<ProxyConfig mustMatch="true">
<serverUrls>
    
    <serverUrl url="http://myhost.com/arcgis/rest/services/"
               matchAll="true"></serverUrl>
</serverUrls>

</ProxyConfig>

I can access the map layer query service by this url (host name is changed):

http://myhost.com/proxy/proxy.ashx?http://myhost.com/ArcGIS/rest/services/test/huc_centerpts/MapServer/0/query

Looking at the NET traffic, it appears this is what is being requested, but I am seeing this error:

Error: Unable to load http://myhost.com/proxy/proxy.ashx?http://myhost.com/ArcGIS/rest/services/test/huc_centerpts/MapServer/0/query status:0

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

HemingZhu — Thu, 07 Apr 2011 20:14:01 GMT

I've been wondering about that, too since I can run the query using the REST query form. But, still no luck figuring it out.

Here is my proxy.config file.

<?xml version="1.0" encoding="utf-8" ?>

<ProxyConfig mustMatch="true">
<serverUrls>
    
    <serverUrl url="http://myhost.com/arcgis/rest/services/"
               matchAll="true"></serverUrl>
</serverUrls>

</ProxyConfig>

I can access the map layer query service by this url (host name is changed):

http://myhost.com/proxy/proxy.ashx?http://myhost.com/ArcGIS/rest/services/test/huc_centerpts/MapServer/0/query

Looking at the NET traffic, it appears this is what is being requested, but I am seeing this error:

Error: Unable to load http://myhost.com/proxy/proxy.ashx?http://myhost.com/ArcGIS/rest/services/test/huc_centerpts/MapServer/0/query status:0

Have you check to see if your ArcGISWebSerivces acount has the access of your services directory folder? Usually in C:\Inetpub\wwwroot\ArcGIS\rest. This is the acount that access your services or cache through web...

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

S_Ector — Thu, 07 Apr 2011 20:34:53 GMT

I checked the folder C:\Inetpub\wwwroot\ArcGIS\rest and did not see the arcgiswebservices user listed in the permissions, so I went ahead and added it. Unfortunately, I am still getting the same error!

I am also seeing this error under the XML tab of the request (in firebug NET tab):

XML Parsing Error: no element found Location: moz-nullprincipal:{a3df32b9-85a8-4045-8239-c16f41c90f1c} Line Number 1, Column 1:

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

HemingZhu — Fri, 08 Apr 2011 12:43:57 GMT

I checked the folder C:\Inetpub\wwwroot\ArcGIS\rest and did not see the arcgiswebservices user listed in the permissions, so I went ahead and added it. Unfortunately, I am still getting the same error!

I am also seeing this error under the XML tab of the request (in firebug NET tab):

XML Parsing Error: no element found Location: moz-nullprincipal:{a3df32b9-85a8-4045-8239-c16f41c90f1c} Line Number 1, Column 1:

Do you include this script tag in your page?

<script type="text/javascript"> var djConfig = { parseOnLoad: true };</script>

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

S_Ector — Fri, 08 Apr 2011 13:06:18 GMT

Do you include this script tag in your page?

<script type="text/javascript"> var djConfig = { parseOnLoad: true };</script>

Yes, it is there. This same code runs on my windows xp machine that has arcgis server enterprise and postgresql installed. Thanks for asking. I am hoping you'll think of something for me to check that finds the problem!

I walked through the setup of the proxy code again yesterday. I had forgotten to set up the proxy folder as an application on the windows server 2008 machine. I did that step yesterday morning, but it did not fix the issue.

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

S_Ector — Fri, 08 Apr 2011 13:25:56 GMT

I'm not sure if this helps, but here is a screenshot of the request that is failing.

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

HemingZhu — Fri, 08 Apr 2011 13:40:20 GMT

Yes, it is there. This same code runs on my windows xp machine that has arcgis server enterprise and postgresql installed. Thanks for asking. I am hoping you'll think of something for me to check that finds the problem!

I walked through the setup of the proxy code again yesterday. I had forgotten to set up the proxy folder as an application on the windows server 2008 machine. I did that step yesterday morning, but it did not fix the issue.

Try to use a very simple geometry like a extent (rectangle) to do you spatial query. Doing this you by pass the proxy POST to see if it works. From what you described and the message, it seems to me that either query request is not parsed correctly to the server or it do not parsed at all (more like the last). There is related post that might help you: http://forums.arcgis.com/threads/12690-Unable-to-load-proxy

Re: Spatial Queries quit working on ArcGIS Enterprise Server on Windows Server 2008

S_Ector — Fri, 08 Apr 2011 14:01:51 GMT

I just fround the problem from reading this thread: http://forums.arcgis.com/threads/27686-Trouble-with-buffer-query-not-returning-results

I was not running the web page from the web server directory. After moving it there, I am now getting the results back!

hzhu, thanks for your help!