[mapserver-dev] WMS GetFeatureInfo not working on Oracle in trunk

Tue Jul 27 02:46:59 EDT 2010

The strange thing is that in the bind variables minx=maxx and miny=maxy
whereas the BBOX parameter in the request has different values:

minx:158432.845251   miny:458914.635053
maxx:158432.845251   maxy:458914.635053

BBOX=122757.714116,434907.834101,204041.825055,469124.423963

Best regards,
Bart

> Hi list,
>
> trying out trunk (r10376), but WMS GetFeatureInfo is crashing on Oracle
> Spatial layers (output is truncated). Debug info is:
>
> [bart at nwr-iovl-geo002 trunk]$ ./mapserv-core
> "QUERY_STRING=map=/data/OGC_UMN_services/test_vector.map&LAYERS=ORA_POLY&FORMAT=image%2Fpng&TRANSPARENT=TRUE&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetFeatureInfo&STYLES=&EXCEPTIONS=application%2Fvnd.ogc.se_xml&SRS=EPSG%3A28992&BBOX=122757.714116%2C434907.834101%2C204041.825055%2C469124.423963&X=452&Y=129&INFO_FORMAT=application%2Fvnd.ogc.gml&QUERY_LAYERS=ORA_POLY&FEATURE_COUNT=1&WIDTH=1031&HEIGHT=434"
> [Tue Jul 27 08:34:28 2010].343306 msOracleSpatialLayerOpen called with:
> SHAPE FROM (SELECT OBJECTID, HECTARES, ZONENR, NULZONES, AREA, PERIMETER,
> SHAPE FROM GRENZEN.OV_ZONERING) USING UNIQUE OBJECTID (Layer pointer
> 0x8630840)
> [Tue Jul 27 08:34:28 2010].464171 msOracleSpatialLayerOpen. Shared
> connection not available. Creating one.
> [Tue Jul 27 08:34:28 2010].464892
> msConnPoolRegister(ORA_POLY,RWS_LEZEN/RWS_LEZEN at geodatabase.ad.rws.nl:1521/PGPR.rws.nl,0x87722b0)
> [Tue Jul 27 08:34:28 2010].478015 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Jul 27 08:34:28 2010].478734 msOracleSpatialLayerFreeItemInfo was
> called.
> [Tue Jul 27 08:34:28 2010].479369 msOracleSpatialLayerGetItems was called.
> [Tue Jul 27 08:34:28 2010].483218 msOracleSpatialLayerInitItemInfo was
> called.
> [Tue Jul 27 08:34:28 2010].484048 msOracleSpatialLayerInitItemInfo was
> called.
> [Tue Jul 27 08:34:28 2010].484806 msOracleSpatialLayerWhichShapes was
> called.
> [Tue Jul 27 08:34:28 2010].485589 msOracleSpatialLayerWhichShapes. Using
> this Sql to retrieve the data: SELECT OBJECTID, HECTARES, ZONENR,
> NULZONES, AREA, PERIMETER, rownum, SHAPE FROM (SELECT OBJECTID, HECTARES,
> ZONENR, NULZONES, AREA, PERIMETER, SHAPE FROM GRENZEN.OV_ZONERING) WHERE
> SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, :srid,
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window')
> = 'TRUE'
> [Tue Jul 27 08:34:28 2010].490377 msOracleSpatialLayerWhichShapes. Bind
> values: srid:-1   minx:158432.845251   miny:458914.635053
> maxx:158432.845251   maxy:458914.635053
> [Tue Jul 27 08:34:28 2010].491033 msOracleSpatialLayerWhichShapes getting
> ordinate definition.
> [Tue Jul 27 08:34:28 2010].494052 msOracleSpatialLayerWhichShapes
> converting to OCIColl.
> [Tue Jul 27 08:34:28 2010].495951 msOracleSpatialLayerWhichShapes bind by
> name and object.
> [Tue Jul 27 08:34:28 2010].496910 msOracleSpatialLayerWhichShapes name and
> object now bound.
> [Tue Jul 27 08:34:28 2010].521059 msOracleSpatialLayerNextShape on layer
> 0x8630840, row_num: 0
> [Tue Jul 27 08:34:28 2010].522846 msOracleSpatialLayerNextShape on layer
> 0x8630840, row_num: 1
> [Tue Jul 27 08:34:28 2010].524501 msOracleSpatialLayerNextShape on layer
> 0x8630840, Fetched 0 more rows (1 total)
> Content-type: application/vnd.ogc.gml
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
>
> <msGMLOutput
>          xmlns:gml="http://www.opengis.net/gml"
>          xmlns:xlink="http://www.w3.org/1999/xlink"
>          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
>         <ORA_POLY_layer>
> [Tue Jul 27 08:34:28 2010].528379 msOracleSpatialLayerResultGetShape():
> OracleSpatial error. msOracleSpatialLayerResultGetShape record out of
> range
> [Tue Jul 27 08:34:28 2010].529060 msOracleSpatialLayerClose was called.
> Layer: 0x8630840, Layer name: ORA_POLY. Layer connection:
> RWS_LEZEN/RWS_LEZEN at geodatabase.ad.rws.nl:1521/PGPR.rws.nl
> [Tue Jul 27 08:34:28 2010].530614 msOracleSpatialLayerClose. Cleaning
> layerinfo handlers.
> [Tue Jul 27 08:34:28 2010].531716 msOracleSpatialLayerClose. Release the
> Oracle Pool.
> [Tue Jul 27 08:34:28 2010].532320
> msConnPoolRelease(ORA_POLY,RWS_LEZEN/xxxx at geodatabase.ad.rws.nl:1521/PGPR.rws.nl,0x87722b0)
> [Tue Jul 27 08:34:28 2010].533766 freeLayer(): freeing layer at 0x8630840.
> [Tue Jul 27 08:34:28 2010].534630
> msConnPoolClose(RWS_LEZEN/RWS_LEZEN at geodatabase.ad.rws.nl:1521/PGPR.rws.nl,0x87722b0)
>
> Layer string is:
>
>     CONNECTION "RWS_LEZEN/xxx at geodatabase.ad.rws.nl:1521/PGPR.rws.nl"
>     CONNECTIONTYPE ORACLESPATIAL
>     DATA "SHAPE FROM (SELECT OBJECTID, HECTARES, ZONENR, NULZONES, AREA,
> PERIMETER, SHAPE FROM GRENZEN.OV_ZONERING) USING UNIQUE OBJECTID"
>
> Best regards,
> Bart
>
> --
> Looking for flexible support on OpenLayers or GeoExt? Please check out
> http://www.osgis.nl/support.html
>
> Bart van den Eijnden
> OSGIS
> bartvde at osgis.nl
>
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>

-- 
Looking for flexible support on OpenLayers or GeoExt? Please check out
http://www.osgis.nl/support.html

Bart van den Eijnden
OSGIS
bartvde at osgis.nl