Any chance you could run it against a shapefile version of the data? I'm curious if this could be Oracle specific.
Steve ________________________________________ From: [email protected] [[email protected]] on behalf of Holger Porath [[email protected]] Sent: Saturday, April 20, 2013 4:59 AM To: [email protected] 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@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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
