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

[Michelle Douvil]

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 500000
    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 3000000
    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.