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

Tue Jul 27 05:07:31 EDT 2010

Actually, this is not the cause of the issue, this was because my
TOLERANCE was 0 (polygon layer).

Changing the tolerance to something like 5 creates a proper box, however
the problem persists, truncated GetFeatureInfo.

Actually, all queries (also SLD WMS, WFS) on Oracle seem to be broken in
trunk.

Best regards,
Bart

> 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
>
> _______________________________________________
> 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