[mapserver-users] Expression and nquery with sde issue

[Mario Franco]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110715/8c79f7e7/attachment.htm>