[mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape no results

Nolte, Tim Tim.Nolte at ipcswirelessinc.com
Wed Dec 16 09:15:07 EST 2009


Here is some more information that may help to find the problem:

Items used to generate the Query file via PHP MapScript-

	layers	on_air,in_construction,in_acquisition
	mapname	ipcs_cell_sites
	maxfeatures	-1
	session	4b28e96a69286
	spatialfilter	POLYGON((-86.158228860555 44.564298461849, -85.987273183566 44.564298461849, -85.987273183566
		44.729555616272, -86.158228860555 44.729555616272, -86.158228860555 44.564298461849))
	variant	INTERSECTS

CGI Call Parameters:

	imgext	-86.545728395062 43.584152580449 -84.807679012346 45.182588160291
	imgx	305
	imgxy	610 561
	imgy	280.5
	layers	in_acquisition in_construction on_air
	map	/tmp/sess_4b28e96a69286/ipcs_cell_sites.map
	map_imagetype	PNG
	map_size	610 561
	mapext	-86.545728395062 43.584152580449 -84.807679012346 45.182588160291
	mode	map
	queryfile	/tmp/sess_4b28e96a69286/ipcs_cell_sites_query.qy
	session	4b28e96a69286
	ts	1260972533510

I have also attached the generated Query file. Thanks.

- Tim

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

Sprint Nextel
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office:  616-656-5163
PCS:     616-706-2438
Support: 616-929-0289
Fax:     616-554-6484


-----Original Message-----
From: Lime, Steve D (DNR) [mailto:Steve.Lime at state.mn.us] 
Sent: Tuesday, December 15, 2009 10:20 AM
To: Nolte, Tim; mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query,msQueryByShape no results

The query file format has changed. It had to as part of RFC 52. It may depend on how PHP/MapScript creates that file. May need to get
Paul Spencer in on this...

Steve

________________________________________
From: mapserver-users-bounces at lists.osgeo.org [mapserver-users-bounces at lists.osgeo.org] On Behalf Of Nolte, Tim [Tim.Nolte at ipcswirelessinc.com]
Sent: Monday, December 14, 2009 11:30 PM
To: Lime, Steve D (DNR); mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query,  msQueryByShape no results

Sorry, just got back into work today and as most Mondays seem to go I had a lot to take care of first. I'll try to provide more details tomorrow. I can say this, that this is partly being setup and called by the MapGuide Fusion framework. There is a PHP script being called with the query parameters, this uses PHP MapScript to generate a .qry file. This .qry file is being used in the call to the mapserv CGI. The PHP MapScript process is returning list results for the objects selected, however the map image is failing to generate. The MODE that is being requested of the CGI is 'map'. I will send an example of the full URL as well as the contents of the .qry file. I don't currently have a similar data set in Shapefile format, only within the Oracle database. Also, the 3 layers in question are Oracle VIEWS and not direct table-based layers. The layers work just fine in all cases but this.

- Tim

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

iPCS Wireless, Inc.
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office: 616-656-5163
PCS: 616-706-2438
Fax: 616-554-6484
Web: www.ipcswirelessinc.com



-----Original Message-----
From: Lime, Steve D (DNR) [mailto:Steve.Lime at state.mn.us]
Sent: Mon 12/14/2009 5:35 PM
To: Lime, Steve D (DNR); Nolte, Tim; mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query,msQueryByShape no results

Tim: Any more on this? I looked into the source over the weekend but didn't see any logic errors that would cause what you're seeing. Not that they aren't there, it's that nothing was obvious...

Steve

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Lime, Steve D (DNR)
Sent: Friday, December 11, 2009 3:50 PM
To: Nolte, Tim; mapserver-users at lists.osgeo.org
Subject: RE: [mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape no results

Does the behavior hold true with shapefiles or is this just Oracle, or can't you test that.

The queryfile (foo.qf) caches the query parameters itself, not the results. The pre-5.6 cached the results but it was really expensive to retrieve them with certain types of data providers, primarily databases. Are you using query files?

A sample query or two would help. Also, how are you presenting the results (template, querymap or ???)

Steve


-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Nolte, Tim
Sent: Friday, December 11, 2009 1:12 PM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] MapServer CGI + Oracle + Query, msQueryByShape no results

I have a web client that makes calls to the MapServer (5.6.0rc1) CGI. I'm requesting the results of a query. The issue I am having is that if one of the layers specified has no results the whole process fails with:

        msQueryByShape(): Search returned no results. No matching record(s) found.

If I run the same query but only pass a single layer that does have results then it works. Additionally if I run the same query again and have results in both of say 2 layers searched, I only get the layer that is searched first to be highlighted rather than all of the results of all layers. It seems like the logic that is used for querying is flawed. Was the design of using a query file only designed to be used with 1 layer at a time? I really need help as this is breaking the web client and causing users to get unexpected results. Thanks.

- Tim

----
Timothy J Nolte - tnolte at ilpcs.com
Network Planning Engineer

Sprint Nextel
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office: 616-656-5163
PCS:    616-706-2438
Fax:    616-554-6484

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users




-------------- next part --------------
A non-text attachment was scrubbed...
Name: ipcs_cell_sites_query.qy
Type: application/octet-stream
Size: 266 bytes
Desc: ipcs_cell_sites_query.qy
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20091216/a8f438aa/ipcs_cell_sites_query.obj


More information about the mapserver-users mailing list