[mapserver-users] ArcSDE MSSQL Label Items displaying incorrectly.

[Nelson Soto]

Has anyone else run into an issue where trying to display a labelitem from SDE that it is displayed incorrectly. 

This is my map file, it is for highways...


MAP
	NAME 'Highways 2'
	SIZE 800 650
	STATUS ON
	EXTENT  34847.155991 780218.437305 329932.687407 959485.530395
	UNITS METERS
	FONTSET '../fonts/fontset.list'
	SYMBOLSET '../symbols/symbol.sym'
	TRANSPARENT TRUE
	IMAGETYPE PNG

	QUERYMAP
		STATUS ON
	END

	LEGEND
	    LABEL 
	        TYPE TRUETYPE
            FONT ARIAL
            SIZE 10
	        COLOR 0 0 0
	    END
        STATUS ON
	END
    
    LAYER
        NAME major_roads-sde
  	    CONNECTIONTYPE PLUGIN
  	    CONNECTION "GEOTS,port:5151,medway,sa,geosql1230"
  	    PLUGIN "D:\ms4w\Apache\specialplugins\msplugin_sde_92.dll"
  	    DATA "medway.DBO.fcMajRoads,SHAPE"
  	    STATUS DEFAULT
        TYPE LINE
        MAXSCALE 250000
        SYMBOLSCALE 900000
        CLASSITEM "ADMIN_TYPE"
        CLASS
            NAME "State Highway"
            EXPRESSION "3"
            STYLE
                COLOR 120 120 120
                SYMBOL 'plainline'
                SIZE 3
                MINSIZE 1
                MAXSIZE 4
            END
            STYLE
                SYMBOL 'plainline'
                SIZE 1
                MINSIZE 1
                MAXSIZE 2
                COLOR 227 159 2
            END
        END
        CLASS
            NAME "U.S. Highway"
            EXPRESSION "2"
            STYLE
                COLOR 120 120 120
                SYMBOL "plainline"
                SIZE 3
                MINSIZE 1
                MAXSIZE 4
            END
            STYLE
                COLOR 109 223 77
                SYMBOL "plainline"
                SIZE 1
                MINSIZE 1
                MAXSIZE 2
            END
        END
        CLASS
            NAME "Interstate"
            EXPRESSION "1"
            STYLE
                COLOR 120 120 120
                SYMBOL "plainline"
                SIZE 3
                MINSIZE 1
                MAXSIZE 4
            END
            STYLE
                COLOR 255 255 136
                SYMBOL "plainline"
                SIZE 1
                MINSIZE 1
                MAXSIZE 2
            END
        END
    END

    LAYER
        NAME major_roadsanno-SDE
  	    CONNECTIONTYPE PLUGIN
  	    CONNECTION "GEOTS,port:5151,medway,sa,geosql1230"
  	    PLUGIN "D:\ms4w\Apache\specialplugins\msplugin_sde_92.dll"
  	    DATA "medway.DBO.fcMajRoads,SHAPE"
  	    STATUS DEFAULT
        TYPE annotation
        MAXSCALE 2000000
        LABELITEM 'RT_NUMBER'
        LABELCACHE ON
        CLASSITEM 'ADMIN_TYPE'
        CLASS
            EXPRESSION '1'
            COLOR 0 0 0 # dummy color
            SYMBOL '../symbols/interstate.png'
            LABEL
                MINFEATURESIZE 25
                MINDISTANCE 250
                SIZE TINY
                COLOR 254 254 254
            END
        END
        CLASS
	        EXPRESSION '3'
	        COLOR 0 0 0 # dummy color
	        SYMBOL '../symbols/USHWY.png'
	        LABEL
	          MINFEATURESIZE 25
	          MINDISTANCE 200
	          SIZE TINY
	          COLOR 0 0 0
	        END
        END
        CLASS
            EXPRESSION '2'
            COLOR 0 0 0 #dummy color
            SYMBOL '../symbols/STHWY.png'
            LABEL
                MINFEATURESIZE 25
                MINDISTANCE 150
                SIZE TINY
                COLOR 0 0 0
            END
        END
    END
END

If I replace the RT_Number field for an integer field, it displays correctly. But if I use the RT_NUMBER (which the data exists as intended when checked) it looks like âê and so on.

-----Original Message-----
From: Andreas Albarello [mailto:andreas.albarello at territoriumonline.com] 
Sent: Tuesday, September 30, 2008 4:25 PM
To: Nelson Soto
Cc: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] ArcSDE 9.3 Support.


On 30 Sep 2008, at 21:56, Nelson Soto wrote:

> After tracing dependencies with Dependency Walker, I can see sde.dll  
> and
> libmap.dll aren't loading correctly when loading  
> 'msplugin_sde_92.dll'.
>
> Any ideas on how to alleviate this?

Nelson,

dynamically loaded plugin dlls which in turn require other statically  
compiled libraries is where Windows dll hell starts to get really  
ugly. Windows tries to locate your sde libraries either in one of the  
directories contained in your %PATH% (probably set by setenv.bat but I  
don't use MS4W so I can't help you there) or, preferably, in the  
application's folder. By that, if I'm not mistaken, they mean the  
directory which the main executable image of your app is launched  
from, so probably the one containing mapserv.exe (or maybe the one  
where libmap.dll resides?). It's definitely not going to work if you  
place them relative to the plugin inside your specialplugins folder as  
that dll is dynamically loaded into the main application's process  
space. What I'm saying is that Dependency Walker won't help you in  
this case if you launch it directly on msplugin_sde_92.dll, because  
what counts is what mapserver.exe/libmap.dll sees, not the plugin.

Still, if all fails, you could always just drop the sde libs into c: 
\windows\system32 but I'm sure with some trial and error you'll find a  
place where they get picked up correctly.

Best regards,
--
--------------------------------------------------------------------
Andreas Albarello
Analysis & SW Development

Territorium Online srl/GmbH
Via Buozzi/Buozzistraße 12 - I 39100 Bolzano/Bozen
email: andreas.albarello at territoriumonline.com
web:   www.territoriumonline.com
--------------------------------------------------------------------