[Geomoose-users] Problem with query, GM 2.6

[Bistrais, Bob]

A bit more success-
I tested with a shapefile version of my Barriers data and was able to get query results.  But when switching back to the GDB version of it, I get the problem of no query results.  Looking at the error log, I see two clues that maybe somebody has some insight on:

Parsing error near (Town):(line 228)

-and-

General error message. Cannot evaluate expression, no item index defined.

-So there must be some issue with querying the personal GDB?  Maybe my expressions have to be formed differently than for shapefiles?


-----Original Message-----
From: geomoose-users-bounces at lists.osgeo.org [mailto:geomoose-users-bounces at lists.osgeo.org] On Behalf Of Bistrais, Bob
Sent: Tuesday, June 26, 2012 4:23 PM
To: eadam at co.lincoln.or.us
Cc: geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Problem with query, GM 2.6

Having a bit of luck, back in the original application but with a different layer.  Enough that I'm getting results on a simple layer.  Guess I have to dissect this operation with the Barriers layer.

-----Original Message-----
From: Eli Adam [mailto:eadam at co.lincoln.or.us]
Sent: Monday, June 25, 2012 6:57 PM
To: Bistrais, Bob
Cc: geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] Problem with query, GM 2.6

Bob,

On Mon, Jun 25, 2012 at 1:39 PM, Bistrais, Bob <Bob.Bistrais at maine.gov> wrote:
> I'm trying to get the query service working with my own data.  It 
> works with the demo data, but when I try it with my own data I get an
> error- "no results found".  As far as I can tell, the configuration is 
> good.  Looking at the error log I see this message:
>
>
>
> [Mon Jun 25 16:31:37 2012].816000 getSymbol(): Symbol definition error.
> Parsing error near (Town):(line 228)

One of your .map files probably references a symbol that is not in /maps/symbols/symbol.sym

>
> [Mon Jun 25 16:31:37 2012].972000 msQueryByRect(): Search returned no 
> results. No matching record(s) found.

This is QueryByPoint with a similar error, http://www.mapserver.org/errors.html#msquerybypoint-search-returned-no-results.
 Not sure if it is applicable to QueryByRect.

>
> [Mon Jun 25 16:31:37 2012].987000 msEvalExpression(): General error message.
> Cannot evaluate expression, no item index defined.

There may be some hints for the "Cannot evaluate expression, no item index defined." message in this thread, http://lists.osgeo.org/pipermail/mapserver-users/2010-February/064572.html

> The layer is a personal Geodatabase and it works well otherwise, 
> including with Identify.

You may also want to up the level of debug output to 5 to get more detail, and look at the actual query sent to the datasource.
Sometimes seeing what is actually sent shows something obviously incorrect and then you can focus on why that parameter is incorrect.

HTH, Eli

>
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
>
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geomoose-users