[MS4W-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/n5159829/postgis.png> 

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

The ".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-tp5159829.html
Sent from the ms4w-users mailing list archive at Nabble.com.