[mapserver-users] Oracle layer partially drawn

[Geograma]

Hello,

With MapServer for Windows (3.0.6 updated to MapServer 6.2.0-beta4), I’m
writing a “.map” that uses data from an Oracle 11g schema. All looks OK but,
when a map is requested, only some features are drawn. In the log there is
no error or warning. Anybody knows what is happening? (any suggestion will
be appreciated)

Attached are two images, one with the map that should be got (data in a
PostGis server), another with the map got from Oracle and the “.map” used to
generate the second image.

<http://osgeo-org.1560.x6.nabble.com/file/n5159828/oracle.png> 

<http://osgeo-org.1560.x6.nabble.com/file/n5159828/postgis.png> 

Tha ".map" file is as  follows:

MAP
   NAME TEST
   EXTENT -1450047 2763292 2122072 5658922
  SYMBOLSET "symbols.sym"
  FONTSET "font.list"
   LEGEND
      IMAGECOLOR -1 -1 -1
      LABEL
         FONT "vera"
         ANGLE FOLLOW
         COLOR 0 0 0
         ENCODING "UTF-8"
         TYPE truetype
         SIZE 8
      END
      STATUS ON
      TRANSPARENT ON
   END   
   WEB
      METADATA
         "wms_encoding" "UTF-8"
         "wms_title" "title"
         "wms_abstract" ""
         "wms_srs" "epsg:23030 epsg:4326"
         "wms_enable_request" "*"
         "wms_onlineresource"
"http://v-0049:8080/fcgi-bin/mapserv.exe?map=C:\\ms4w\\maps\\test.map"
         labelcache_map_edge_buffer "-10"
      END
   END
   PROJECTION
      "init=epsg:23030"
   END
   
   #CONFIG MS_ERRORFILE "c:\\ms4w_3_0_6\\maps\\logs\\test.log"
   #DEBUG 5
   
   IMAGECOLOR 153 179 204

   OUTPUTFORMAT
	  NAME png
	  DRIVER "AGG/PNG"
	  MIMETYPE "image/png"
	  IMAGEMODE RGB
	  EXTENSION "png"
	  FORMATOPTION QUALITY=100
	  FORMATOPTION "INTERLACE=OFF"

   END
      
   LAYER
      NAME "geo_r3_500K-1M"
      STATUS ON
      TYPE LINE
      CONNECTIONTYPE oraclespatial
      CONNECTION "user/pass at service"
      DATA "geom from geo_r3 using unique id srid 23030"
	  MAXSCALEDENOM 749210
      MINSCALEDENOM 149750
      TRANSPARENCY 100
      SIZEUNITS pixels
	  DUMP TRUE
      PROJECTION
         "init=epsg:23030"
      END
      CLASS
         STYLE 
            INCLUDE 'defs/roundedline.def'
            COLOR 170 170 170
            WIDTH 5
         END
         STYLE 
            INCLUDE 'defs/roundedline.def'
            COLOR 255 255 115
            WIDTH 2
         END
         NAME "default"
      END
      METADATA
         "wms_title" "public.geo_r3_500K-1M"
         "wms_abstract" "Capa del Servicio WMS"
         "wms_extent" "-971136.125 3134652.25 1051167.75 4846924.0"
         "gml_include_items" "all"
      END
      PROCESSING "CLOSE_CONNECTION=DEFER"
   END # Layer
END # Map File



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-layer-partially-drawn-tp5159828.html
Sent from the Mapserver - User mailing list archive at Nabble.com.