[mapserver-users] GetFeatureInfo with ArcSDE9.1/Oracle10g Spatial Views - Mapserver 5.2

[Michelle Douville]

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=wms&request=getFeatureInfo&version=1.1.1&layers=BIOT_OCCR_TREES_AREA_SVW&query_layers=BIOT_OCCR_TREES_AREA_SVW&width=500&height=500&SRS=EPSG:4326&BBOX=-115.458612543896,49.1997596600283,-115.458021667689,49.2001915091176&x=200&y=200&info_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=wms&request=getFeatureInfo&version=1.1.1&layers=BIOT_OCCR_MASKED_SENS_AREA_SP&query_layers=BIOT_OCCR_MASKED_SENS_AREA_SP&width=500&height=500&SRS=EPSG:4326&BBOX=-115.295184921231,49.1055064203968,-115.241763642305,49.1445500142613&x=200&y=200&info_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 



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090220/b0d77001/attachment.html