[mapserver-users] Oracle layer partially drawn

[Geograma]

Hello Tike,

First, thanks for your help!

- Checked that the layer has all the data (the same records in PostGis and
Oracle).
- DEBUG 5 is on
- Cannot try ORG connection (it gives me an error, I do not know why)
- Scaledoms, transparency, wms_extent and spatial index recreated in Oracle
removed but no change

- The test you suggested:

   · Downloaded:
http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_places.zip
   · Loaded info to Oracle using ogr2ogr -f oci oci:user/pass at orcl
ne_10m_populated_places.shp
   · New "NE_10M_POPULATED_PLACES.map", as follows:
-------------------------------------------------------
MAP
   NAME TEST
   EXTENT -180 -90 180 90
   SYMBOLSET "symbols.sym"
   FONTSET "fonts.txt"
   DEBUG ON 
   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" "WMS"
         "wms_abstract" ""
         "wms_srs" "epsg:4326 epsg:23030"
		 "wms_enable_request" "*"
         "wms_onlineresource"
"http://v-0049:8080/fcgi-bin/mapserv.exe?map=C:\ms4w\maps\NE_10M_POPULATED_PLACES.map"
         labelcache_map_edge_buffer "-10"
      END
   END
   PROJECTION
      "init=epsg:4326"
   END
   
   CONFIG MS_ERRORFILE "c:\ms4w_3_0_6\maps\logs\NE_10M_POPULATED_PLACES.log"
   DEBUG 5
   CONFIG "CPL_DEBUG" "ON"
   CONFIG "PROJ_DEBUG" "ON"
   
   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 "NE_10M_POPULATED_PLACES"
      STATUS ON
      TYPE POINT
      CONNECTIONTYPE oraclespatial
      CONNECTION "FONDO_2014_06/FONDO_2014_06 at orcl"
      DATA "ora_geometry from NE_10M_POPULATED_PLACES using unique ogr_fid
srid 4326"
      SIZEUNITS pixels
      LABELITEM "name"
      PROJECTION
         "init=epsg:4326"
      END
            TYPE truetype
      CLASS
         STYLE 
            COLOR 254 0 0
            SIZE 1
         END
         SYMBOL "circle"
         NAME "default"
         LABEL
            FONT "arial"
            ANGLE 0
            COLOR 0 0 0
            TYPE truetype
            SIZE 10
            POSITION Auto
            PARTIALS FALSE
            FORCE FALSE
            OUTLINECOLOR 254 254 254
         END
	  END
      METADATA
         "wms_title" "public.smaltown_point_500k"
         "wms_abstract" "Capa del Servicio WMS"
         #"wms_extent" "-180 -90 180 90"
         "wms_layer_group" "/TINSAMaps"
         "gml_include_items" "all"
      END
      PROCESSING "CLOSE_CONNECTION=DEFER"
   END # Layer

END # Map File
-------------------------------------------------------

   · Request made:
http://v-0049:8081/fcgi-bin/mapserv.exe?map=C:\ms4w_3_0_6\maps\NE_10M_POPULATED_PLACES.map&LAYERS=NE_10M_POPULATED_PLACES&TRANSPARENT=TRUE&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&FORMAT=image%2Fpng&SRS=EPSG%3A4326&BBOX=-180,-90,180,90&WIDTH=768&HEIGHT=384&d

   · Log got:
-------------------------------------------------------
[Wed Sep 03 12:57:47 2014].724000 CGI Request 1 on process 5764
[Wed Sep 03 12:57:47 2014].740000 msDrawMap(): rendering using outputformat
named png (AGG/PNG).
[Wed Sep 03 12:57:47 2014].740000 msOracleSpatialLayerOpen called with:
ora_geometry from NE_10M_POPULATED_PLACES using unique ogr_fid srid 4326
(Layer pointer 02E88CB8)
[Wed Sep 03 12:57:48 2014].490000 msOracleSpatialLayerOpen. Shared
connection not available. Creating one.
[Wed Sep 03 12:57:48 2014].490000
msConnPoolRegister(NE_10M_POPULATED_PLACES,user/pass at orcl,02EB1D08)
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerFreeItemInfo was
called.
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerInitItemInfo was
called.
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes was
called.
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT name, ogr_fid,rownum, ora_geometry
FROM NE_10M_POPULATED_PLACES WHERE SDO_FILTER( ora_geometry,
MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
'TRUE'
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes. Bind
values: srid:4326   minx:-179.765625   miny:-89.765625  maxx:179.765625  
maxy:89.765625 
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes getting
ordinate definition.
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes converting
to OCIColl.
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes bind by
name and object.
[Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes name and
object now bound.
[Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerFreeItemInfo was
called.
[Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerClose was called.
Layer: 02E88CB8, Layer name: NE_10M_POPULATED_PLACES. Layer connection:
user/pass at orcl
[Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerClose. Cleaning
layerinfo handlers.
[Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerClose. Release the
Oracle Pool.
[Wed Sep 03 12:57:48 2014].896000
msConnPoolRelease(NE_10M_POPULATED_PLACES,user/pass at orcl,02EB1D08)
[Wed Sep 03 12:57:48 2014].896000 msDrawLabelCache():
labelcache_map_edge_buffer = 10
[Wed Sep 03 12:57:49 2014].130000 msOracleSpatialLayerClose was called.
Layer: 02E88CB8, Layer name: NE_10M_POPULATED_PLACES. Layer connection:
user/pass at orcl
-------------------------------------------------------

   · Image got:

<http://osgeo-org.1560.x6.nabble.com/file/n5159854/NE_10M_POPULATED_PLACES.png> 

As you can see, the result is not correct.



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