Hi,

I having two issues with mapserver if anyone can help me I would be appreciated.

The first has to do with an Expression in a class:

I have a shape with an attribute with the 172060.0937 but when add to the class:

EXPRESSION ( [AREA] = 172060.0937 )

The problem is that this expression returns false because mapserver is rounding the double value from the database. If I compare with:

EXPRESSION ( [AREA] = 172060)

it works. There is any way to turn this off or to increase the precision?



The second issue is:

I'm using this url (http://localhost:82/cgi-bin/mapserv.exe?map=D%3a\projects\Inag\InterSIG+II\InterSIG+Website\Trunk\InterSIG+ASP.NET\Maps%2fintersig_281.map&qlayer=Concelhos&layers=Concelhos&MAPSIZE=629%20467&MINX=-232614.525612302&MINY=-49761.6088409424&MAXX=676601.080299802&MAXY=625284&mode=NQUERY&MAPSHAPE=POLYGON%28%28-232614%20-49761,%20-232614%20625284,%20676601%20625284,%20676601%20-49761,%20-232614%20-49761%29%29) to execute a nquery but I always get the error "msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid parameter value passed to function. (-66) "

The log doesn't help that much:

[Fri Jul 15 10:47:19 2011].20000 msSDELayerOpen(): Layer Concelhos opened from scratch. [Fri Jul 15 10:47:23 2011].35000 msConnPoolRegister(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0) [Fri Jul 15 10:47:23 2011].35000 msSDELayerOpen(): Layer Concelhos specified version SDE.DEFAULT. [Fri Jul 15 10:47:23 2011].42000 msSDEGetLayerInfo(): Looking for layer by SDE.CONCELH_PTCONT_2008_0_596, SHAPE, ydinag2,port:5151,sde,sde,sde [Fri Jul 15 10:47:23 2011].42000 msSDEGetLayerInfo(): No cached layerid found. [Fri Jul 15 10:47:23 2011].63000 msSDELCacheAdd(): Caching id for SDE.CONCELH_PTCONT_2008_0_596, SHAPE, ydinag2,port:5151,sde,sde,sde [Fri Jul 15 10:47:23 2011].72000 Getting all column information in msSDELayerInitItemInfo [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for DICO [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for CONCELHO [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for DI [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for DISTRITO [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for CCDR [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT3 [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT3_NOME [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT2 [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for NUT2_NOME [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for AREA2008_1 [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for objectid [Fri Jul 15 10:47:23 2011].79000 msSDELayerInitItemInfo(): getting info for SHAPE [Fri Jul 15 10:47:23 2011].79000 Column information has already been gotten... returning from msSDELayerInitItemInfo [Fri Jul 15 10:47:43 2011].122000 msSDELayerGetShape(): SDE error. SE_stream_fetch_row(): Invalid parameter value passed to function. (-66)
[Fri Jul 15 10:47:43 2011].126000 msFreeMap(): freeing map at 01D3EFE8.
[Fri Jul 15 10:47:43 2011].126000 msSDELayerCloseConnection(): Closing connection for layer Concelhos. [Fri Jul 15 10:47:43 2011].126000 msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,01D6BCC0) [Fri Jul 15 10:47:43 2011].126000 msConnPoolClose(ydinag2,port:5151,sde,sde,sde,01D6BCC0) [Fri Jul 15 10:47:43 2011].156000 msSDELayerClose(): Closing layer Concelhos. [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(Concelhos,ydinag2,port:5151,sde,sde,sde,00000000) [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): Unable to find handle for layer 'Concelhos'. [Fri Jul 15 10:47:43 2011].156000 msConnPoolRelease(): General error message. Unable to find handle for layer 'Concelhos'.


Here part of my configuration:
        LAYER
            NAME "Concelhos"
            METADATA
                "wms_title"    "Concelhos"   # required
                "wfs_title"    "Concelhos"   # required
                "gml_featureid" "ID" ## REQUIRED
                        "gml_geometries" "geom"
                        "gml_geom_type" "polygon"
                        "gml_include_items" "all"  # Optional (serves all 
attributes for layer)
                        "gml_exclude_items" "GEOMETRY,OBJECTID"
                        "ows_include_items" "all"
                        "ows_exclude_items" "GEOMETRY,OBJECTID"     
            END
                DUMP true
            TOLERANCE 10
                TOLERANCEUNITS meters
        
            TYPE polygon
        
            #CONNECTIONTYPE SDE
CONNECTIONTYPE PLUGIN PLUGIN "D:/ms4w/Apache/specialplugins/msplugin_sde_92.dll"
            CONNECTION "ydinag2,port:5151,sde,sde,sde"
        
            DATA "SDE.CONCELH_PTCONT_2008_0_596,SHAPE,SDE.DEFAULT"
PROJECTION
            "init=EPSG:3763" #--sistema de coordenadas desta layer na origem
            END
STATUS ON
            OPACITY 100
                TEMPLATE '../Templates/Identify/t.html'

I'm using Mapserver 5.6.3, I know it's not the latest but I didn't updated yet.

Any help would be useful and thx in advance.

Mário Franco

_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to