Sounds like more of an SDE problem than WMS. Can you query the SDE layer outside of WMS just using MapServer queries?
Steve >>> On 4/23/2009 at 3:59 PM, in message <1240520397380-2686390.p...@n2.nabble.com>, Michelle Douvil <mrdouvi...@shaw.ca> wrote: > > We have data that is in Oracle 10.2.0.2 Enterprise Edition with ArcSDE 9.1 > General Update Patch 3. > We have several spatial views that are causing us issues when GetFeatureINFO > is requested via Mapserver 5.2. The result is an SDE error. > SE_stream_fetch_row(): Invalid parameter value passed to function. (-66). > However, using Geoserver 1.7.3 to the same data the GetFeatureINFO request > is successful. Any thoughts as to why Mapserver has issues but Geoserver > does not? > > The Spatial View given in the example below is a simple view (no where > clauses or join statements). We have re-registered the Spatial view with the > sde to make sure the objectid was correct. > > Looks like Geoserver 1.7.3 doesn’t mind GetFeatureINFO on > SCHEMA.AEI_AIR_QUALITY_AOI_SVW > Whereas Mapserver 5.2 gets confused.. see examples below > > > http://server/geoserver/wms?service=wms&request=getFeatureInfo&version=1.1.1&la > yers=prod:AOIAEI&query_layers=prod:AOIAEI&width=500&height=500&SRS=EPSG:4326&BBOX= > -126.94250575451,54.5026638549918,-126.72424645805,54.6394718590618&x=200&y=200& > info_format=text/plain > > > Results for FeatureType 'AOIAEI': > -------------------------------------------- > geometry = [GEOMETRY (Polygon) with 22 points] > air_quality_aoi_id = 66 > aoi_name = Bulkley Valley / Lakes District > status = Plan Established > feature_code = FF00595000 > -------------------------------------------- > > > > http://server/mapserver/air-climate?service=wms&request=getFeatureInfo&version > =1.1.1&layers=AEI_AIR_QUALITY_AOI_O&query_layers=AEI_AIR_QUALITY_AOI_O&width=500& > height=500&SRS=EPSG:4326&BBOX=-126.94250575451,54.5026638549918,-126.7242464580 > 5,54.6394718590618&x=200&y=200&info_format=text/plain > > > > GetFeatureInfo results: > > Layer 'AEI_AIR_QUALITY_AOI_O' > Content-type: application/vnd.ogc.se_xml > > <?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?> > <!DOCTYPE ServiceExceptionReport SYSTEM > "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd"> > <ServiceExceptionReport version="1.1.1"> > <ServiceException> > msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid parameter > value passed to function. (-66) > </ServiceException> > </ServiceExceptionReport> > > > many thanks for any assistance. > > > -- > View this message in context: > http://n2.nabble.com/GetFeatureINFO-errors-in-Mapserver-not-occurring-in-Geos > erver.-tp2686390p2686390.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > > _______________________________________________ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users