Re: [mapserver-users] GetFeatureInfo with ArcSDE9.1/Oracle10g Spatial Views - Mapserver 5.2
Hello Michelle, Michelle Douvil mrdouvi...@shaw.ca, [20090220 - 15:34:34] Additional debugging info.. [Fri Feb 20 15:18:05 2009].241000 msSDELayerOpen(): Layer BIOT_OCCR_TREES_AREA_SVW specified version SDE.DEFAULT. [Fri Feb 20 15:18:05 2009].241000 msSDEGetLayerInfo(): Looking for layer by WHSE_TERRESTRIAL_ECOLOGY.BIOT_OCCR_TREES_AREA_SVW, GEOMETRY, server,port:port,sde,username,password [Fri Feb 20 15:18:05 2009].241000 msSDEGetLayerId(): Matched layer to id 896. [Fri Feb 20 15:18:05 2009].241000 Getting all column information in msSDELayerInitItemInfo [Fri Feb 20 15:18:05 2009].241000 msSDELayerGetRowIDColumn(): Table was not registered, returning SE_ROW_ID. Make sure that your Layer is registerd properly in our ArcSDE, otherwise you will not be able to fetch the GetFeatureInfo. [...] [Fri Feb 20 15:18:05 2009].241000 msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid parameter value passed to function. (-66) [Fri Feb 20 15:18:05 2009].241000 mapserv request processing time (msLoadMap not incl.): 0.016s [Fri Feb 20 15:18:05 2009].241000 msFreeMap(): freeing map at 010B4548. [Fri Feb 20 15:18:05 2009].241000 msSDELayerCloseConnection(): Closing connection for layer BIOT_OCCR_TREES_AREA_SVW. [...] Best Stephan -- Stephan Holl stephan.h...@intevation.de | Tel.: +49 (0)541-33 508 3663 Intevation GmbH, Neuer Graben 17, 49074 OS | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner signature.asc Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] GetFeatureInfo with ArcSDE9.1/Oracle10g Spatial Views - Mapserver 5.2
I am wondering if anyone else has come across this while using the ArcSDE Datastore: I am trying to get a text/plain result from a getFeatureInfo. I get two types of results depending on whether the sde layer is an actual spatial layer or a spatial view (based on a join within oracle). Here is a request to a spatial view.. http://server/mapserver520/terrestrial_ecology520?service=wmsrequest=getFeatureInfoversion=1.1.1layers=BIOT_OCCR_TREES_AREA_SVWquery_layers=BIOT_OCCR_TREES_AREA_SVWwidth=500height=500SRS=EPSG:4326BBOX=-115.458612543896,49.1997596600283,-115.458021667689,49.2001915091176x=200y=200info_format=text/plain And this is the result: Layer 'BIOT_OCCR_TREES_AREA_SVW' 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 When doing a getFeatureInfo on a spatial layer, such as this.. http://server/mapserver520/terrestrial_ecology520?service=wmsrequest=getFeatureInfoversion=1.1.1layers=BIOT_OCCR_MASKED_SENS_AREA_SPquery_layers=BIOT_OCCR_MASKED_SENS_AREA_SPwidth=500height=500SRS=EPSG:4326BBOX=-115.295184921231,49.1055064203968,-115.241763642305,49.1445500142613x=200y=200info_format=text/plain I get this.. GetFeatureInfo results: Layer 'BIOT_OCCR_MASKED_SENS_AREA_SP' Feature 1278361: Are there limitations on how mapserver can handle spatial views in ArcSDE/Oracle? This is similar to http://trac.osgeo.org/mapserver/ticket/536 Many thanks, Michelle ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] GetFeatureInfo with ArcSDE9.1/Oracle10g Spatial Views - Mapserver 5.2
Additional debugging info.. [Fri Feb 20 15:18:05 2009].241000 msSDELayerOpen(): Layer BIOT_OCCR_TREES_AREA_SVW specified version SDE.DEFAULT. [Fri Feb 20 15:18:05 2009].241000 msSDEGetLayerInfo(): Looking for layer by WHSE_TERRESTRIAL_ECOLOGY.BIOT_OCCR_TREES_AREA_SVW, GEOMETRY, server,port:port,sde,username,password [Fri Feb 20 15:18:05 2009].241000 msSDEGetLayerId(): Matched layer to id 896. [Fri Feb 20 15:18:05 2009].241000 Getting all column information in msSDELayerInitItemInfo [Fri Feb 20 15:18:05 2009].241000 msSDELayerGetRowIDColumn(): Table was not registered, returning SE_ROW_ID. [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for OCCR_AREA_SP_ID [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for GEOMETRY [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for OBJECTID [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for FEATURE_CODE [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for SHAPE_ID [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for SCI_NAME_F [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for SCI_NAME [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for ENG_NAME_F [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for ENG_NAME [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for OCCR_ID [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for EL_TYPE [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for DATA_SENS [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for SURV_SITE [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for DIRECTIONS [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for FIRST_OBS [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for LAST_OBS [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for OCCR_DATA [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for GEN_DESC [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for VEG_ZONE [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for HABITAT [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for BGC [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for REFERENCES [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for VERS_DATE [Fri Feb 20 15:18:05 2009].241000 msSDELayerInitItemInfo(): getting info for EST_RA [Fri Feb 20 15:18:05 2009].241000 msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid parameter value passed to function. (-66) [Fri Feb 20 15:18:05 2009].241000 mapserv request processing time (msLoadMap not incl.): 0.016s [Fri Feb 20 15:18:05 2009].241000 msFreeMap(): freeing map at 010B4548. [Fri Feb 20 15:18:05 2009].241000 msSDELayerCloseConnection(): Closing connection for layer BIOT_OCCR_TREES_AREA_SVW. Mapfile layer: LAYER NAME 'BIOT_OCCR_TREES_AREA_SVW' CONNECTIONTYPE sde CONNECTION server,port,sde,username,password DATA 'WHSE_TERRESTRIAL_ECOLOGY.BIOT_OCCR_TREES_AREA_SVW,GEOMETRY,SDE.DEFAULT' # PROCESSING OBJECTID=SHAPE_ID LABELITEM 'SHAPE_ID' LABELMAXSCALE 50 CLASS NAME 'CDC Big Trees' STYLE SYMBOL 'square' COLOR 215 194 158 SIZE 5 END #end style LABEL COLOR 0 0 0 FONT arial TYPE truetype SIZE 8 PARTIALS FALSE BUFFER 1 OUTLINECOLOR 254 254 254 END #end label END #end class TYPE polygon MINSCALE 0 MAXSCALE 300 STATUS ON PROJECTION init=EPSG:3005 END #projection METADATA wms_title Big Trees - Non Sensitive Occurrences wms_metadataurl_format html wms_metadataurl_href wms_metadataurl_type TC211 wfs_title CDC Big Trees # gml_geometries geom gml_geom_type polygon gml_include_items all # gml_exclude_items GEOMETRY,OBJECTID ows_include_items all gml_featureid OBJECTID ows_feature_id OBJECTID # wms_feature_info_mime_type text/plain END #metadata PROCESSING CLOSE_CONNECTION=DEFER DEBUG 5 DUMP TRUE TEMPLATE foo.html END #end layer -- View this message in context: http://n2.nabble.com/GetFeatureInfo-with-ArcSDE9.1-Oracle10g-Spatial-Views---Mapserver-5.2-tp2361707p2361946.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