[mapserver-users] still no results for wfs getfeature request

[Holger Porath]

Hi all!

We still do not get any results for wfs 1.0.0 getfeature filter requests when using map server 6.2.0

Let me summarize what we have found out so far:

The same filter request works correctly when wfs version 1.1.0 is used (instead of 1.0.0) .
The same filter request works correctly when map server 5.6.3  is used (even when using wfs version 1.0.0).
A wfs bbox request (no filter) works correctly.
 
Here is the filter request that does not work:

http://host/ogc-sec-data.ows?service=WFS&version=1.0.0&request=getFeature&typeName=flst_gdsrvt01&Filter=%3CFilter%3E%0A%3Cand%3E%0A%3CPropertyIsLike%20wildCard%3D%22%25%22%20singleChar%3D%22%3F%22%20escape%3D%22ESC%22%3E%0A%3CPropertyName%3EFS_GKNR%3C%2FPropertyName%3E%0A%3CLiteral%3E534%3C%2FLiteral%3E%0A%3C%2FPropertyIsLike%3E%0A%3CPropertyIsLike%20wildCard%3D%22%25%22%20singleChar%3D%22%3F%22%20escape%3D%22ESC%22%3E%0A%3CPropertyName%3EFS_FLNR%3C%2FPropertyName%3E%0A%3CLiteral%3E26%3C%2FLiteral%3E%0A%3C%2FPropertyIsLike%3E%0A%3CPropertyIsLike%20wildCard%3D%22%25%22%20singleChar%3D%22%3F%22%20escape%3D%22ESC%22%3E%0A%3CPropertyName%3EFS_FSZ%3C%2FPropertyName%3E%0A%3CLiteral%3E111%3C%2FLiteral%3E%0A%3C%2FPropertyIsLike%3E%0A%3C%2Fand%3E%0A%3C%2FFilter%3E

The layer is configured as shown below:

LAYER
  DEBUG 10
       NAME         flst
       METADATA
           "wfs_title"  "flst"
           "gml_featureid" "fs_id"
           "gml_include_items"         "all" 
           "wfs_extent"        "400000.000000 5400000.000000 600000.000000 5800000.000000"
           "wfs_abstract" "Test"
       END
       DUMP TRUE

      PROJECTION
           "init=epsg:25832"
      END

      CONNECTIONTYPE oraclespatial     
       CONNECTION "user/pass at ORCLTST"
       DATA   "fs_tpo_pos from (select      fs_tpo_pos,
                                                                               fs_gknr,
                                                                               fs_flnr,
                                                                               fs_fsz,
                                                                               fs_fsn,
                                                                               fs_fsstatus,
                                                                               gk_gkbez,
                                                                               fs_id
                                                               from    nav.flst,
                                                                       nav.gmkg
                                                               where   gk_gknr=fs_gknr and
                                                                               fs_fsstatus='a')
                       USING UNIQUE fs_id NONE VERSION 9i"
       TYPE     POINT
       STATUS   ON
   END 

There is a suspicious message in the log file saying "projection library error. All points failed to reproject". Is it possible that that's the reason? What does it mean?

msProjectRect(): Projection library error. All points failed to reproject.
msOracleSpatialLayerGetPaging was called.
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst. Layer connection:/@ORCLTST
msOracleSpatialLayerOpen. Shared connection not available. Creating one.
msProjectRect(): Warning: degenerate rect {0.000000,0.000000,0.000000,0.000000}
msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: …
msOracleSpatialLayerWhichShapes. Bind values: srid:-1   minx:-2998554.423622   miny:478.980149  maxx:-2998554.423622   maxy:478.980149
msOracleSpatialLayerWhichShapes getting ordinate definition.
msOracleSpatialLayerWhichShapes converting to OCIColl.
msOracleSpatialLayerWhichShapes bind by name and object.
msOracleSpatialLayerWhichShapes name and object now bound.
msOracleSpatialLayerNextShape on layer 0x1a2ede0, row_num: 0
msOracleSpatialLayerNextShape on layer 0x1a2ede0, row_num: 1
msOracleSpatialLayerNextShape on layer 0x1a2ede0, Fetched 0 more rows (1 total)
msOracleSpatialLayerFreeItemInfo was called.
msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst. Layer connection:
msQueryByRect(): Search returned no results. No matching record(s) found.
msProjectRect(): Warning: degenerate rect {0.000000,0.000000,0.000000,0.000000}
msOracleSpatialLayerClose was called. Layer: 0x1a2ede0, Layer name: flst. Layer connection:
 

Any help is very appreciated. Thanks in advance.

Holger