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

[Lime, Steve D (MNIT)]

Any chance you could run it against a shapefile version of the data? I'm curious if this could be Oracle specific.

Steve

________________________________________
From: mapserver-users-bounces at lists.osgeo.org [mapserver-users-bounces at lists.osgeo.org] on behalf of Holger Porath [porath at web.de]
Sent: Saturday, April 20, 2013 4:59 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] still no results for wfs getfeature request

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
_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users