[mapserver-users] [Fwd: mapserver - postgis bug]
P Kishor
punk.kish at gmail.com
Mon Oct 12 16:13:53 EDT 2009
On Mon, Oct 12, 2009 at 3:00 PM, Peter Freimuth <pfreimuth at arcor.de> wrote:
>
> --
> Peter Freimuth Muskauer Str. 11 10997 Berlin
> Location:http://www.berlinonline.de/citymap/map.asp?start.x=5&plz=10997&str=Muskauer+Str.+11&grid=dedatlas10
> ========================================================================================================
> Tel:+49(0)30-69816610 Mobil:+49(0)175-8434074 Firma:+49(0)3381-8904327
> ========================================================================================================
> mailto:pfreimuth at arcor.de
> skype:pfreimuth
> msn:peter_freimuth at hotmail.com
>
>
> owsuser at map2:~> /srv/www/cgi-bin/mapserv -v
> MapServer version 5.4.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=MYGIS INPUT=SHAPEFILE
>
> MAP
> ...
> #-----------------------------------------------------------------------------------------------------------------------------------
> # Index and Raster Layer for all requested "service_products"
> # duplicate the template below and modify the Product Shortname in the sql query and rename the layer itself
> #-----------------------------------------------------------------------------------------------------------------------------------
> LAYER
> NAME "service_product_gc_idx"
> STATUS OFF
> #DEBUG ON
> TYPE POLYGON
> PROCESSING "CLOSE_CONNECTION=DEFER"
> CONNECTIONTYPE POSTGIS
> CONNECTION "user=ows_user password=xxx dbname=ows_customer_nnn host=db2 port=5432"
> DATA "wkb_geom FROM (SELECT * FROM ows_customer.tileindex_service_products tsp JOIN ows_customer.analysis_units au ON (au.unit_id=tsp.unit_id) JOIN ows_customer.service_product_types spt ON (tsp.product_type_id=spt.product_type_id) WHERE spt.name = 'GC' ) foo USING UNIQUE service_product_id USING SRID=3785"
> PROJECTION
> "init=epsg:3785"
> END
> METADATA
> "ows_title" "service_product_gc_idx"
> "wms_srs" "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 EPSG:26714 EPSG:900913" #output
> #"ows_extent" "380000 5230000 530000 5390000"
> END
> END
> # Raster Layer
> LAYER
> NAME "serv_prod_gc20090415"
> #GROUP "service_products"
> TYPE RASTER
> STATUS ON
> #DEBUG ON
> #TRANSPARENCY 70
> OFFSITE 255 255 255
> TILEITEM "location_path" #location_path is a column in above referenced POSTGIS table "tileindex_service_products" that stores the filepath to each image
> TILEINDEX "service_product_gc_idx"
> PROJECTION
> "init=epsg:3785"
> END
> METADATA
> "ows_title" "Groundcover Map - April 2009"
> #"ows_group_title" "Service Products WS 2009"
> "wms_srs" "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 EPSG:26714 EPSG:900913" #output
> #"ows_extent" "380000 5230000 530000 5390000"
> "ows_timeextent" "2009-04-15/2009-12-15"
> "ows_timeitem" "product_date" #yearmoda is our date column in shape of type date
> "ows_timedefault" "2009-04-15"
> END
> CLASS
> NAME "GCMap"
> KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
> END
> END
> LAYER
> NAME "serv_prod_gc20090515"
> #GROUP "service_products"
> TYPE RASTER
> STATUS ON
> #DEBUG ON
> #TRANSPARENCY 70
> OFFSITE 255 255 255
> TILEITEM "location_path" #location_path is a column in above referenced POSTGIS table "tileindex_service_products" that stores the filepath to each image
> TILEINDEX "service_product_gc_idx"
> PROJECTION
> "init=epsg:3785"
> END
> METADATA
> "ows_title" "Groundcover Map - May 2009"
> "wms_srs" "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 EPSG:26714 EPSG:900913" #output
> #"ows_extent" "380000 5230000 530000 5390000"
> "ows_timeextent" "2009-04-15/2009-12-15"
> "ows_timeitem" "product_date" #yearmoda is our date column in shape of type date
> "ows_timedefault" "2009-05-15"
> END
> CLASS
> NAME "GCMap"
> KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
> END
> END
> LAYER
> NAME "serv_prod_gc20090615"
> #GROUP "service_products"
> TYPE RASTER
> STATUS ON
> #DEBUG ON
> #TRANSPARENCY 70
> OFFSITE 255 255 255
> TILEITEM "location_path" #location_path is a column in above referenced POSTGIS table "tileindex_service_products" that stores the filepath to each image
> TILEINDEX "service_product_gc_idx"
> PROJECTION
> "init=epsg:3785"
> END
> METADATA
> "ows_title" "Groundcover Map - June 2009"
> "wms_srs" "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 EPSG:26714 EPSG:900913" #output
> #"ows_extent" "380000 5230000 530000 5390000"
> "ows_timeextent" "2009-04-15/2009-12-15"
> "ows_timeitem" "product_date" #yearmoda is our date column in shape of type date
> "ows_timedefault" "2009-06-15"
> END
> CLASS
> NAME "GCMap"
> KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
> END
> END
> LAYER
> NAME "serv_prod_gc20090715"
> #GROUP "service_products"
> TYPE RASTER
> STATUS ON
> #DEBUG ON
> #TRANSPARENCY 70
> OFFSITE 255 255 255
> TILEITEM "location_path" #location_path is a column in above referenced POSTGIS table "tileindex_service_products" that stores the filepath to each image
> TILEINDEX "service_product_gc_idx"
> PROJECTION
> "init=epsg:3785"
> END
> METADATA
> "ows_title" "Groundcover Map - July 2009"
> "wms_srs" "EPSG:3785 EPSG:4269 EPSG:4326 EPSG:32610 EPSG:32611 EPSG:32612 EPSG:32613 EPSG:32614 EPSG:26710 EPSG:26711 EPSG:26712 EPSG:26713 EPSG:26714 EPSG:900913" #output
> #"ows_extent" "380000 5230000 530000 5390000"
> "ows_timeextent" "2009-04-15/2009-12-15"
> "ows_timeitem" "product_date" #yearmoda is our date column in shape of type date
> "ows_timedefault" "2009-07-15"
> END
> CLASS
> NAME "GCMap"
> KEYIMAGE "/srv/www/htdocs/nnn/GroundCover.png"
> END
> END
> ...
>
> https://10.20.2.45/map2/ows/allianz_brazil?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&WIDTH=1000&HEIGHT=1000&BBOX=-52,-23.8,-50,-13.55&SRS=EPSG:4326&FORMAT=image/jpeg&STYLES=&LAYERS=serv_prod_gc20090415,service_product_gc_idx
>
>
> [Mon Oct 12 10:45:12 2009].604172 msWMSLoadGetMapParams(): WMS server error. Invalid layer(s) given in the LAYERS parameter.
> [Mon Oct 12 10:45:45 2009].724205 msPostGISLayerWhichShapes(): Query error. Error (ERROR: syntax error at or near ")"
> LINE 1: ...and date_trunc('day', product_date) = '2009-04-15') and (dat...
> ^
> ) executing query: select "product_date","location_path",encode(AsBinary(force_collection(force_2d("wkb_geom")),'NDR'),'base64') as geom,"service_product_id" from (SELECT * FROM ows_customer.tileindex_service_products tsp JOIN ows_customer.analysis_units au ON (au.unit_id=tsp.unit_id) JOIN ows_customer.service_product_types spt ON (tsp.product_type_id=spt.product_type_id) WHERE spt.name = 'GC' ) foo where wkb_geom && GeomFromText('POLYGON((-5788613.52125023 -2729056.10763308,-5788613.52125023 -1522639.17855836,-5565974.53966368 -1522639.17855836,-5565974.53966368 -2729056.10763308,-5788613.52125023 -2729056.10763308))',3785) and date_trunc('day', product_date) = '2009-04-15') and (date_trunc('day', product_date) = '2009-05-15') and (date_trunc('day', product_date) = '2009-06-15') and (date_trunc('day', product_date) = '2009-07-15'
> [Mon Oct 12 10:45:45 2009].724297 msDrawMap(): Image handling error. Failed to draw layer named 'serv_prod_gc20090415'.
>
> Kind regards,
> Peter
> --
> _______________________________________________________________________
>
> Peter Freimuth phone: +49 3381 8904327
> Product Development fax: +49 3381 8904101
> RapidEye AG email: freimuth at rapideye.de
> Molkenmarkt 30
> 14776 Brandenburg an der Havel http://www.rapideye.de
> Germany
> _______________________________________________________________________
>
> PRIVILEGE AND CONFIDENTIALITY NOTICE:
> The information in this email is intended for the named recipients
> only. It may contain privileged and confidential information. If you
> have received this communication in error, any use, copying or
> dissemination of its contents is strictly prohibited. Please erase all
> copies of the message along with any included attachments and notify
> RapidEye AG or the sender immediately by telephone at the number
> indicated on this page.
> _______________________________________________________________________
>
> RapidEye AG
> Molkenmarkt 30
> 14776 Brandenburg an der Havel
> Germany
>
> Follow us on Twitter! www.twitter.com/rapideye_ag
>
> Head Office/Sitz der Gesellschaft: Brandenburg an der Havel
> Management Board/Vorstand: Wolfgang G. Biedermann
> Chairman of Supervisory Board/Vorsitzender des Aufsichtsrates:
> Juergen Breitkopf
> Commercial Register/Handelsregister Potsdam HRB 17 796
> Tax Number/Steuernummer: 048/100/00053
> VAT-Ident-Number/Ust.-ID: DE 199331235
> DIN EN ISO 9001 certified
>
> *************************************************************************
> Diese E-Mail enthaelt vertrauliche und/oder rechtlich geschuetzte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese
> E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den
> Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie
> die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.
>
> The information in this e-mail is intended for the named recipients
> only. It may contain privileged and confidential information. If you
> have received this communication in error, any use, copying or
> dissemination of its contents is strictly prohibited. Please erase all
> copies of the message along with any included attachments and notify
> RapidEye AG or the sender immediately by telephone at the number
> indicated on this page.
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
What is the bug? Why not just tell us instead of reproducing a boat
load of inconsequential text.
As far as I can see, you have unbalanced parentheses in your query. I
leave it as an exercise for you to find out where.
--
Puneet Kishor
More information about the mapserver-users
mailing list