RE: [mapserver-users] Problems labelling using Halo option
Assefa, Sorry for my late response, I've been working in something else. I've checked the file C:/ms4w/Apache/htdocs/ogcservices/tmp/4ca47709_100_1._sld.map LAYER CONNECTION "user=postgres password= dbname=VITICOLA_IMPRESIONES host=192.168.1.161 port=5432" CONNECTIONTYPE POSTGIS DATA "the_geom FROM vinedos using unique gid using SRID=23030" DUMP TRUE METADATA "wms_srs" "EPSG:23030" "wms_extent" "47 470 61 482" "wms_transparent" "true" "wms_name""vinedos" "wms_format" "image/gif" "gml_include_items" "all" "wms_server_version" "1.1.1" "wms_title" "vinedos" END NAME "vinedos" PROCESSING "LABEL_NO_CLIP=ON" PROJECTION "init=epsg:23030" END STATUS ON TYPE POLYGON UNITS METERS CLASS NAME "Unknown" EXPRESSION ( ([provincia] = 1) And ( ([municipio] = 43) And ( ([poligono] = 4) And ( ([parcela] = 880) And ([recinto] = 1) ) ) ) ) LABEL ANGLE AUTO ANTIALIAS TRUE FONT "times-bold" MAXSIZE 256 MINSIZE 4 SIZE 18 TYPE TRUETYPE BUFFER 0 COLOR 255 255 255 FORCE FALSE MINDISTANCE -1 MINFEATURESIZE -1 OFFSET 0 0 OUTLINECOLOR 255 255 255 OUTLINEWIDTH 0 PARTIALS TRUE POSITION CC END STYLE ANGLE 360 OPACITY 100 OUTLINECOLOR 0 0 0 SIZE 2 SYMBOL "sld_line_symbol_dash" END TEXT ([poligono]-[parcela]-[recinto]) END END OUTLINEWIDTH shouldn't be greater than 0?? What do you think? By the way, I forgot to mention that I'm working with MS4W 2.3.1 which includes MapServer 5.2.1. About the font issue, it's like if MapServer, when it doesn't the font I specify in FONSET, it takes a default font and it applies the HALO correctly, but when I try to change the size, it doesn't work, the returned image has the same font size. Maybe is something related with the SLD. It's difficult to explain. Un saludo, ·· David Alda Fernández de Lezea Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad IKT Granja Modelo s/n · 01192 · Arkaute (Araba) ·· Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 ·· email: da...@ikt.esweb: www.ikt.es ·· -Mensaje original- De: Yewondwossen Assefa [mailto:yass...@dmsolutions.ca] Enviado el: jueves, 30 de septiembre de 2010 14:21 Para: David Alda Fernandez de Lezea CC: mapserver-users@lists.osgeo.org Asunto: Re: [mapserver-users] Problems labelling using Halo option Hi, Check the file C:/ms4w/Apache/htdocs/ogcservices/tmp/4ca47709_100_1._sld.map and the layer where the sld is applied, the label object should have the outlinecolor set if it worked properly. Is that the case? I am not sure I understand the font issue, but you can also see what font was set fir that label object. regards, On 30/09/2010 7:43 AM, David Alda Fernandez de Lezea wrote: > Assefa, > > Yes, it's valid. It works, but not with desired behaviour. It draws the > polygons with the labels but without the Halo effect. > > I forgot to put xml headers in the previous email. > > >xsi:schemaLocation="http://www.opengis.net/sld > StyledLayerDescriptor.xsd" xmlns="http://www.opengis.net/sld"; > xmlns:ogc="http://www.opengis.net/ogc"; > xmlns:xlink="http://www.w3.org/1999/xlink"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> > > I also forgot to mention that if I put name="font-family">Verdana for example, and Verdana does not > exist in my fontset, it does the labelling properly (including Halo), but > it's like if mapserver gets some default values, because the size has changed > and even though I change it in th e SLD, the size keeps the same. > > > > WMS Log > > [Thu Sep 30 13:39:53 2010].513000 CGI Request 1 on process 256 [Thu > Sep 30 13:39:53 2010].685000 msApplySLD(): Map file after SLD was applied > C:/ms4w/Apache/htdocs/ogcservices/tmp/4ca47709_100_1._sld.map[Thu Sep 30 > 13:39:53 2010].826000 msDrawRasterLayerLow(orto0): entering. > [Thu Sep 30 13:40:02 2010].216000 msDrawMap(): Layer 4 (orto0), 8.390s > [Thu Sep 30 13:40:03 2010].606000 msDrawMap(): Layer 0 > (vinedos_sigpac), 1.390s [Thu Sep 30 13:40:04 2010].122000 > msDrawMap(): Layer 3 (vinedos_disolve_bn), 0.516s [Thu Sep 30 13:40:04 > 2010].513000 msDrawMap(): Layer 2 (vinedos_disolve), 0.391s [Thu Sep > 30 13:40:05 2010].919000 msDrawMap(): Layer 1 (vinedos), 1.406s [Thu > Sep 30 13:40:07 2
[mapserver-users] syntax of setConnectionType for postgis
hello how should the syntax of setConnectionType for postgis in java-mapscript ? I have a confusion of this: jeolayer.setConnectionType(?, MS_POSTGIS); regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Using mapserver on windows in production
I have gotten my app working using MS4W, but it is coming time to deploy our application and I'm looking for ideas on whats the best route to take. I need to stick with windows as thats the platform thats available at my work. Is using MS4W acceptable in a production environment? How can I apply security patches / etc with a prebuilt binary? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: How to get some part extents in polygon within complete polygon
I am not too sure of your requirement. However you can always iterate through concerned number of points and can calculate extents of selected points. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/How-to-get-some-part-extents-in-polygon-within-complete-polygon-tp5587629p5599475.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Using mapserver on windows in production
we are using mapserver to develop desktop and web applications and using them successfully in various projects. I would recommend you to put your all mapserver dll's and other dependency in one single folder. All your application executables should not be part of this folder. You may use one environment variable which may point towards mapserver directory. Thus you will be sure to use which version of mapserver you may want to use. -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/Using-mapserver-on-windows-in-production-tp5599047p5599492.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] OpenLayers, WFS, Postgis and SWEREF99 TM
Hello all, We have a number of points (reference system SWEREF99TM/epsg:3006) in a Postgres db with PostGIS, that we want to display as choosable vector features on a web map, with the help of MapServer. E.g., if you hover over or click on a point, you will get a popup window with link to more info read from the database. The problem is that we don't know yet how to create this functionality in the best possible way. We are trying to use OpenLayers, connected to a WFS generated by MapServer. I've noticed a lack of examples of this combination of software and since we are new to WFS and OpenLayers and no real experts on MapServer either, we don't know if perhaps we're on the wrong track. We are bumping into problem after problem, and I just want to make sure that what we are trying to do is even feasible. Is this the right method to solve our basic problem, or is there a better way (for example not using OpenLayers or not using WFS, but something else)? How many points is the optimal amount to visualise with WFS/OpenLayers ? Can WFS/OpenLayers handle our reference system SWEREF99 TM (epsg:3006)? Are there problems showing PostGIS data through WFS, that we are unaware of? Kind regards, Sofia___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Using mapserver on windows in production
I'm sorry, but I think i'm not even there yet. I can get ms4w working in the default configuration (older version of apache and and old version of php), but I want to make it work with the latest version of IIS / php. I have been trying unsuccessfully to get IIS7.5 to talk to the older version of php...It only seems to work when i point a mapping to C:\ms4w\Apache\cgi-bin\php5isapi.dll. This gets me up to the point where I try to dl('php_mapscript.dll') but i get a warning about not being able to do that in IIS. When i add php_mapscript.dll to the extensions in php.ini, nothing happens. I think i may be missing a dependency or soemthing? Running php in cgi mode results in this error: HTTP Error 502.2 - Bad Gateway The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are "". I"m feeling quite frustrated right now. What is the best way to be able to use php/mapscript in production in windows? On Mon, Oct 4, 2010 at 10:55 AM, Sumit Sharma wrote: > > we are using mapserver to develop desktop and web applications and using them > successfully in various projects. > I would recommend you to put your all mapserver dll's and other dependency > in one single folder. All your application executables should not be part of > this folder. You may use one environment variable which may point towards > mapserver directory. Thus you will be sure to use which version of mapserver > you may want to use. > > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/Using-mapserver-on-windows-in-production-tp5599047p5599492.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Re: Using mapserver on windows in production
While I personally had a ton of issues attempting to get MS4W working with IIS7.5 under Windows 7, if you're willing to use IIS6 instead, this guide is terrific for getting that setup: http://www.geomoose.org/docs/install_ms4w.html If you do manage to get it working under 7.5, please share the steps! These steps may more or less transfer over, but I had long given up on my 7.5 ambitions by the time I had found this guide. There is more documentation available for MS4W under IIS6 which is what our production systems are currently running anyways. Hope that helps, Dan Bowerman Business Applications Solutions Directorate | Direction des applications d'affaires et solutions Chief Information Officer Branch | Direction du dirigeant principal de l'information Environment Canada | Environnement Canada 867 Lakeshore Road | 867, rue Lakeshore Burlington (ON) L7R-4A6 | Burlington (ON) L7R-4A6 dan.bower...@ec.gc.ca Telephone | Téléphone 905-315-5215 Facsimile | Télécopieur 905-336-4610 Government of Canada | Gouvernement du Canada -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of joel collins Sent: Monday, October 04, 2010 1:46 PM To: Sumit Sharma Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Re: Using mapserver on windows in production I'm sorry, but I think i'm not even there yet. I can get ms4w working in the default configuration (older version of apache and and old version of php), but I want to make it work with the latest version of IIS / php. I have been trying unsuccessfully to get IIS7.5 to talk to the older version of php...It only seems to work when i point a mapping to C:\ms4w\Apache\cgi-bin\php5isapi.dll. This gets me up to the point where I try to dl('php_mapscript.dll') but i get a warning about not being able to do that in IIS. When i add php_mapscript.dll to the extensions in php.ini, nothing happens. I think i may be missing a dependency or soemthing? Running php in cgi mode results in this error: HTTP Error 502.2 - Bad Gateway The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are "". I"m feeling quite frustrated right now. What is the best way to be able to use php/mapscript in production in windows? On Mon, Oct 4, 2010 at 10:55 AM, Sumit Sharma wrote: > > we are using mapserver to develop desktop and web applications and using them > successfully in various projects. > I would recommend you to put your all mapserver dll's and other dependency > in one single folder. All your application executables should not be part of > this folder. You may use one environment variable which may point towards > mapserver directory. Thus you will be sure to use which version of mapserver > you may want to use. > > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/Using-mapserver-on-windows-in-production-tp5599047p5599492.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Using mapserver on windows in production
Joel, I know your frustration. I've implemented mapserver under IIS 6, IIS 7 and IIS 7.5 with each one being harder and more frustrating than the previous. And if your Windows web server happens to also be domain controller heaven help you! Can you use Apache? It's much easier. The initial learning curve might seem steeper than IIS because Apache lacks the fancy (confusing) graphical user interface for configuration, but Apache offers far more flexible access control, aliases and redirection. If you have to connect to a Microsoft SQL Server database, I'd recommend PHP 5.2 over 5.3 as 5.3 doesn't come with SQL Server drivers (or at least didn't the last time I looked). Just my $0.02. Rich On Mon, Oct 4, 2010 at 11:45 AM, joel collins wrote: > I'm sorry, but I think i'm not even there yet. > > I can get ms4w working in the default configuration (older version of > apache and and old version of php), but I want to make it work with > the latest version of IIS / php. > > I have been trying unsuccessfully to get IIS7.5 to talk to the older > version of php...It only seems to work when i point a mapping to > C:\ms4w\Apache\cgi-bin\php5isapi.dll. This gets me up to the point > where I try to dl('php_mapscript.dll') but i get a warning about not > being able to do that in IIS. > When i add php_mapscript.dll to the extensions in php.ini, nothing > happens. I think i may be missing a dependency or soemthing? > > Running php in cgi mode results in this error: > HTTP Error 502.2 - Bad Gateway > The specified CGI application misbehaved by not returning a complete > set of HTTP headers. The headers it did return are "". > > I"m feeling quite frustrated right now. What is the best way to be > able to use php/mapscript in production in windows? > > On Mon, Oct 4, 2010 at 10:55 AM, Sumit Sharma wrote: >> >> we are using mapserver to develop desktop and web applications and using them >> successfully in various projects. >> I would recommend you to put your all mapserver dll's and other dependency >> in one single folder. All your application executables should not be part of >> this folder. You may use one environment variable which may point towards >> mapserver directory. Thus you will be sure to use which version of mapserver >> you may want to use. >> >> -- >> View this message in context: >> http://osgeo-org.1803224.n2.nabble.com/Using-mapserver-on-windows-in-production-tp5599047p5599492.html >> Sent from the Mapserver - User mailing list archive at Nabble.com. >> ___ >> mapserver-users mailing list >> mapserver-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Using mapserver on windows in production
Thank you all for the responses. Perhaps I am overthinking my problem. Lets say my only requirement was to get mapserver running with the latest versions of PHP and apache. How would I go about accomplishing this? Would I download ms4w, apache, and php, and try to get them all to talk to each other? Or does ms4w have some special configuration that only the version of apache that comes bundled with it will work out of the box? On Mon, Oct 4, 2010 at 3:18 PM, Richard Greenwood wrote: > Joel, > > I know your frustration. I've implemented mapserver under IIS 6, IIS 7 > and IIS 7.5 with each one being harder and more frustrating than the > previous. And if your Windows web server happens to also be domain > controller heaven help you! Can you use Apache? It's much easier. The > initial learning curve might seem steeper than IIS because Apache > lacks the fancy (confusing) graphical user interface for > configuration, but Apache offers far more flexible access control, > aliases and redirection. > > If you have to connect to a Microsoft SQL Server database, I'd > recommend PHP 5.2 over 5.3 as 5.3 doesn't come with SQL Server drivers > (or at least didn't the last time I looked). > > Just my $0.02. > Rich > > > On Mon, Oct 4, 2010 at 11:45 AM, joel collins wrote: >> I'm sorry, but I think i'm not even there yet. >> >> I can get ms4w working in the default configuration (older version of >> apache and and old version of php), but I want to make it work with >> the latest version of IIS / php. >> >> I have been trying unsuccessfully to get IIS7.5 to talk to the older >> version of php...It only seems to work when i point a mapping to >> C:\ms4w\Apache\cgi-bin\php5isapi.dll. This gets me up to the point >> where I try to dl('php_mapscript.dll') but i get a warning about not >> being able to do that in IIS. >> When i add php_mapscript.dll to the extensions in php.ini, nothing >> happens. I think i may be missing a dependency or soemthing? >> >> Running php in cgi mode results in this error: >> HTTP Error 502.2 - Bad Gateway >> The specified CGI application misbehaved by not returning a complete >> set of HTTP headers. The headers it did return are "". >> >> I"m feeling quite frustrated right now. What is the best way to be >> able to use php/mapscript in production in windows? >> >> On Mon, Oct 4, 2010 at 10:55 AM, Sumit Sharma wrote: >>> >>> we are using mapserver to develop desktop and web applications and using >>> them >>> successfully in various projects. >>> I would recommend you to put your all mapserver dll's and other dependency >>> in one single folder. All your application executables should not be part of >>> this folder. You may use one environment variable which may point towards >>> mapserver directory. Thus you will be sure to use which version of mapserver >>> you may want to use. >>> >>> -- >>> View this message in context: >>> http://osgeo-org.1803224.n2.nabble.com/Using-mapserver-on-windows-in-production-tp5599047p5599492.html >>> Sent from the Mapserver - User mailing list archive at Nabble.com. >>> ___ >>> mapserver-users mailing list >>> mapserver-users@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/mapserver-users >>> >> ___ >> mapserver-users mailing list >> mapserver-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> > > > > -- > Richard Greenwood > richard.greenw...@gmail.com > www.greenwoodmap.com > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Using mapserver on windows in production
On 10-10-04 10:11 AM, joel collins wrote: I have gotten my app working using MS4W, but it is coming time to deploy our application and I'm looking for ideas on whats the best route to take. I need to stick with windows as thats the platform thats available at my work. Is using MS4W acceptable in a production environment? How can I apply security patches / etc with a prebuilt binary? Hi Joel, Yes MS4W is used in thousands of production deployments around the world. (and at this year's FOSS4G event in Barcelona we found that MS4W battles with MapServer-Unix for being one of the fastest WMS servers in many situations: http://www.slideshare.net/gatewaygeomatics.com/wms-performance-shootout-2010) If you run into any walls please contact me directly, and my team can assist your group with your deployment of MS4W. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Using mapserver on windows in production
On Mon, Oct 4, 2010 at 2:01 PM, joel collins wrote: > Thank you all for the responses. Perhaps I am overthinking my problem. > > Lets say my only requirement was to get mapserver running with the > latest versions of PHP and apache. How would I go about accomplishing > this? Would I download ms4w, apache, and php, and try to get them all > to talk to each other? Or does ms4w have some special configuration > that only the version of apache that comes bundled with it will work > out of the box? As Jeff noted, you can just use MS4W and that's surely the path of least resistance. Or you can download and install Apache and PHP separately and just use the mapserv binaries in cgi-bin from the MS4W distribution, and maybe the http*.conf files as guidance for your own setup. Having setup a lot of MapServers over the last 10 years it is my personal experience that Apache is easier to setup and maintain than IIS. I'm not sure why MS4W has the warnings that it is primarily for development and not hardened for production use, but I wouldn't let those warnings discourage you from using it on a production server. Rich -- Richard Greenwood richard.greenw...@gmail.com www.greenwoodmap.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Using mapserver on windows in production
On 10-10-04 5:53 PM, Richard Greenwood wrote: As Jeff noted, you can just use MS4W and that's surely the path of least resistance. Or you can download and install Apache and PHP separately and just use the mapserv binaries in cgi-bin from the MS4W distribution, and maybe the http*.conf files as guidance for your own setup. Having setup a lot of MapServers over the last 10 years it is my personal experience that Apache is easier to setup and maintain than IIS. I'm not sure why MS4W has the warnings that it is primarily for development and not hardened for production use, but I wouldn't let those warnings discourage you from using it on a production server. Great points from Rich. Just one additional note: recent versions of MS4W don't have these 'not for production' warnings. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] msOracleSpatialLayerResultGetShape() could not fetch specified record
Hi, After migrating to mapserver 5.6.5, one of our two ms oracle spatial queries no longer works. Here's the query that works: Using this Sql to retrieve the data: SELECT ID, ID, SITE_ID, SITE_CODE, CITY, ARRAY_CODE, NAME, SHAPE FROM (select s.id as id,s.site_id as site_id,upper(s.site_code) as site_code,s.shape,nvl(s.city,'n/a') as city,sa.array_code as array_code,nvl(s.site_name,'n/a') as name from site s, site_affiliation sa where s.site_id = sa.site_id and sa.end_date is null and s.site_type_code = 'CONGPS') [Fri Oct 1 18:19:50 2010].881984 msOracleSpatialLayerWhichShapes. Bind values: srid:8307 minx:-11 4.139531 miny:34.485321 maxx:-112.696645 maxy:35.928207 [Fri Oct 1 18:19:50 2010].882013 msOracleSpatialLayerWhichShapes getting ordinate definition. [Fri Oct 1 18:19:50 2010].883487 msOracleSpatialLayerWhichShapes converting to OCIColl. [Fri Oct 1 18:19:50 2010].883626 msOracleSpatialLayerWhichShapes bind by name and object. [Fri Oct 1 18:19:50 2010].883632 msOracleSpatialLayerWhichShapes name and object now bound. [Fri Oct 1 18:19:51 2010].26025 msOracleSpatialLayerNextShape on layer 0x13665770, row_num: 0 [Fri Oct 1 18:19:51 2010].732440 msOracleSpatialLayerNextShape on layer 0x13665770, row_num: 8245 [Fri Oct 1 18:19:51 2010].732662 msOracleSpatialLayerNextShape on layer 0x13665770, Fetched 0 more rows (8250 total) [Fri Oct 1 18:19:51 2010].733278 msOracleSpatialLayerResultGetShape was called. Using the record = 5185 of 1. (shape: 0 should equal pkey: 6274) [Fri Oct 1 18:19:51 2010].733287 msOracleSpatialLayerResultGetShape: Fetching result from DB start: 8192 end:8191 record: 5185 [Fri Oct 1 18:19:51 2010].794501 mapserv request processing time (loadmap not incl.): 1.034s This query does not: [Fri Oct 1 18:19:38 2010].152059 msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: SELECT ID, ID, SITE_ID, SITE_CODE, CITY, ARRAY_CODE, NAME, INTERVAL, LAST, SINCE, SHAPE FROM (select s.id as id,s.site_id as site_id,upper(s.site_code) as site_code,s.shape,nvl(s.city,'n/a') as city,sa.array_code as array_code,nvl(s.site_name,'n/a') as name,src.sample_interval_in_seconds as interval,to_char(round(((SYSDATE - last_updated) * 24 * 60),0),'9') as last, src.start_date as since from site s, realtime_gps_data_src src, site_affiliation sa where src.end_date is null and src. site_id = s.site_id and s.site_id = sa.site_id) [Fri Oct 1 18:19:38 2010].152065 msOracleSpatialLayerWhichShapes. Bind values: srid:8307 minx:-114.864628 miny:33.584442 maxx:-113.421743 maxy:35.027328 [Fri Oct 1 18:19:38 2010].152107 msOracleSpatialLayerWhichShapes getting ordinate definition. [Fri Oct 1 18:19:38 2010].153257 msOracleSpatialLayerWhichShapes converting to OCIColl. [Fri Oct 1 18:19:38 2010].153386 msOracleSpatialLayerWhichShapes bind by name and object. [Fri Oct 1 18:19:38 2010].153392 msOracleSpatialLayerWhichShapes name and object now bound. [Fri Oct 1 18:19:38 2010].222071 msOracleSpatialLayerNextShape on layer 0x18b9bdd0, row_num: 0 [Fri Oct 1 18:19:38 2010].226113 msOracleSpatialLayerNextShape on layer 0x18b9bdd0, row_num: 167 [Fri Oct 1 18:19:38 2010].226464 msOracleSpatialLayerNextShape on layer 0x18b9bdd0, Fetched 0 more rows (167 total) [Fri Oct 1 18:19:38 2010].226984 msOracleSpatialLayerResultGetShape was called. Using the record = 92 of 1. (shape: 415777808 should equal pkey: 2507) [Fri Oct 1 18:19:38 2010].227002 msOracleSpatialLayerResultGetShape: Fetching result from DB start: 0 end:-1 record: 92 [Fri Oct 1 18:19:38 2010].883468 msOracleSpatialLayerResultGetShape: OracleSpatial error. ORA-03113 : end-of-file on communication channel Process ID: 19745 Session ID: 59 Serial number: 36067 [Fri Oct 1 18:19:38 2010].883478 msOracleSpatialLayerResultGetShape(): OracleSpatial error. msOracleSpatialLayerResultGetShape could not fetch specified record. In mapserver 5.2.0, the second query above worked: [Mon Oct 4 16:58:41 2010].791000 msOracleSpatialLayerFreeItemInfo was called. [Mon Oct 4 16:58:41 2010].791007 msOracleSpatialLayerGetItems was called. [Mon Oct 4 16:58:41 2010].792022 msOracleSpatialLayerInitItemInfo was called. [Mon Oct 4 16:58:42 2010].87922 msOracleSpatialLayerGetShape was called. Using the record = 62392. [Mon Oct 4 16:58:42 2010].87940 msOracleSpatialLayerGetShape. Sql: SELECT ID, SITE_ID, SITE_CODE, CITY, ARRAY_CODE, NAME, INTERVAL, LAST, SINCE, SHAPE FROM (select s.id as id,s.site_id as site_id,upper(s.site_code) as site_code,s.shape,nvl(s.city,'n/a') as city,sa.array_code as array_code,nvl(s.site_name,'n/a') as name,src.sample_interval_in_seconds as interval,to_char(round(((SYSDATE - last_upda ted) * 24 * 60),0),'9') as last, src.start_date as since from site s, realtime_gps_data_src src, site_affiliation sa where src.end_date is null and src.site_id = s.site_id and s.site_id = sa.site_id) WHERE ID = 62392 I've seen the RFC-52 note regarding msLayerResultsGetShape() in the mapserver 5.4 to 5.6 migrati