[Mapserver-users] NQUERY Internal Server Error

Düster Horst Horst.Duester at bd.so.ch
Mon Mar 15 06:57:49 PST 2004


I'm a little bit confused about a query problem I'm faced with. Today I did
the upgrade from MS 3.6.7 to MS 4.0.1. I made all the necessary migration
steps (I hope). NQUERY with the most layers work fine, but one layer
produces an "Internal Server Error". Apache error_log says "Premature End of
Header". After some modifications of the concerned layer I found out a
strange fact. Take a look at the attached Mapfile snippet. 
 
Some layer information:
The underlaying data are stored in a Postgres-7.2.4/PostGIS-0.8.1 DB with
4500 recs. 
The values of the attribute o_art are between 100 and 41500. 
 
with   
DATA "wkb_geometry from (select oid,* from arp_ripl_poly where o_art >= 1000
and o_art < 30412) as foo usinng SRID=-1"
NQUERY works
 
with   
DATA "wkb_geometry from (select oid,* from arp_ripl_poly where o_art >= 1000
and o_art < 30413) as foo usinng SRID=-1"
NQUERY does not work -> Internal Server Error

with   
DATA "wkb_geometry from arp_ripl_poly"
NQUERY does not work -> Internal Server Error
 
 
LAYER
  NAME basdat #Grundnutzung#Legende#
  TYPE Polygon
  STATUS ON
  TOLERANCE 10
  MAXSCALE 80000
  DATA "wkb_geometry from (select oid,* from arp_ripl_poly where o_art >=
1000 and o_art < 30412) as foo usinng SRID=-1"
  CONNECTIONTYPE POSTGIS
  CONNECTION "dbname=xxx host=xxx user=xxx"
  TEMPLATE "qry_tpl.html"
  CLASS
    EXPRESSION ([o_art]=5000)
    NAME "<table><tr><td valign=top>   -</td><td> dem Landwirtschaftsgebiet
überlagert</td></tr></table>"
    COLOR 255 255 0
    OUTLINECOLOR 0 0 0
    SYMBOL "simple-line"
  END  # CLASS
END  

I would be appreciative about any hint.
 
With best regards
 
Dr. Horst Düster 
GIS-Koordinator
 
Amt für Geoinformation
Abteilung SO!GIS Koordination
Werkhofstr. 65
4509 Solothurn 

Tel.: 032 627 25 32 
Fax: 032 627 22 14

horst.duester at bd.so.ch <mailto:horst.duester at bd.so.ch> 
www.sogis.so.ch <http://www.sogis.so.ch/> 

 




More information about the MapServer-users mailing list