GetFeatureInfo does not output any items

[bartvde@…]

I am trying to get WMS GetFeatureInfo to work on an ArcSDE layer, but I
don't get back any items/attributes. WFS GetFeature works fine. Using
4.10.1.

The request I am trying is:

http://.../services/geoservices/agi?LAYERS=waterplanten_bedekking&REQUEST=GetFeatureInfo&SERVICE=WMS&FORMAT=image%2Fpng&STYLES=default&HEIGHT=450&QUERY_LAYERS=waterplanten_bedekking&VERSION=1.1.1&SRS=EPSG:28992&WIDTH=750&BBOX=133963.010224851%2C482313.166697811%2C138375.946327149%2C484960.928359189&TRANSPARENT=TRUE&INFO_FORMAT=text/plain&X=286&EXCEPTIONS=application%2Fvnd.ogc.se_xml&Y=311

Which gives back:
GetFeatureInfo results:

Layer 'waterplanten_bedekking'
Feature 27865:

This is my LAYER defintion:

LAYER
PROCESSING "CLOSE_CONNECTION=DEFER"
CONNECTION "145.50.64.40,5152,esri_sde,AGI,AGI"
CONNECTIONTYPE SDE
DATA "BEHEERDER.waterplanten_bedekking,SHAPE,sde.DEFAULT"
DUMP TRUE
METADATA
"ows_title" "Beheerder Waterplanten bedekking"
"gml_include_items" "all"
"gml_featureid" "OBJECTID"
END
NAME "waterplanten_bedekking"
PROJECTION
"init=epsg:28992"
END
SIZEUNITS PIXELS
STATUS ON
TEMPLATE "blank.html"
TOLERANCEUNITS PIXELS
TYPE POLYGON
UNITS METERS
CLASS
NAME "0%"
EXPRESSION ([GRIDCODE] = 0)
METADATA
END
STYLE
ANGLE 360
COLOR 225 225 225
SYMBOL 0
END
END
END

[hobu]

Bart,

This appears to work for me when I request GML and no styles.


mapserv.exe
QUERY_STRING="service=WMS&request=GetFeatureInfo&layers=shppoly&version=1.1.1&map=d:/cvs/buildkit/msautotest/misc/sde_join.map&query_layers=shppoly&x=300&y=300&info_format=application/vnd.ogc.gml"


The other issue your email described but isn't in this bug is that OBJECTID is
being put in twice.  The problem is in msSDELayerGetItems, which is tacking on
the row_id_column in addition to all of the columns in the table (which already
has it).  I propose we remove this double-grab if Steve concurs.  Steve, do you
recall why we might be doing this?

Howard

[hobu]

switched off the double-grab of row_id on the 4.10 branch for now.  Holding off
on doing so for HEAD because I am adding in-database SDE join support.

[bartvde@…]

Hi Howard,

I had opened up a separate bug for the other issue, bug 2040

But styles should not make any difference for GetFeatureInfo should it? The WMS
spec says copy all parameters from the GetMap request IIRC.

Bart

[bartvde@…]

Hi Howard,

I've found my problem. The problem was that the online resource in my MAP file
was pointing to a copy of the map file which had no gml_include_items set .....
so it had nothing to do with Mapserver.

Sorry for the noise.

Glad to see the bug 2040 issue is fixed though.

Bart