Mapserver SDE 9.2 Question

[Josh Hevenor]

My installation is working well. I really appreciate all your help :)

I had a quick question about symbolization for SDE layers. I made a sample map file based on my applications existing map file. I update a couple background layers to use our SDE services. Two of three of these layers work well and the third does not draw. This third layer (REGDIV) has a CLASSITEM set and a number of CLASSES defined. There is no error displayed, even with the -map_debug or -all_debug flags set. If I change the layer to use just one default class then the layer draws. 

I tried updating my CLASSITEM to use a full path, for example DIVID became GIS.DBO.REGDIV.DIVID but I received the following error:

	C:\ms4w\apps\sdedemo>shp2img -m gp.map -o gp.png
	msDrawMap(): Image handling error. Failed to draw layer named 	'REGDIV'. <br>
	msSDELayerInitItemInfo(): SDE error. A specified CLASSITEM, 	FILTERITEM, or expression key cannot be found <br>

My Layer looks like this

	LAYER   
	    NAME 'REGDIV'        
	    STATUS on
	    TYPE POLYGON
	    CONNECTIONTYPE PLUGIN
	    PLUGIN "c:/ms4w/apache/specialplugins/msplugin_sde_92.dll"
	    CONNECTION "matata,port:5252,GIS,sa,sa"
	    PROCESSING 'CLOSE_CONNECTION=DEFER'

	    DATA "GIS.DBO.REGDIV,Shape,dbo.DEFAULT"

	    TOLERANCE 12
	    TRANSPARENCY 75

	    CLASSITEM 'GIS.DBO.REGDIV.DIVID'	
	    
	    CLASS
	      NAME 'West'
	      EXPRESSION 'West'
	      TEMPLATE 'null'
	      STYLE
	        COLOR 204 204 204
	        OUTLINECOLOR 5 5 5
	      END  #STYLE
	    END #CLASS
	
	    CLASS
	      NAME 'Ontario'
	      EXPRESSION 'Ontario'
	      TEMPLATE 'null'
	      STYLE
	        COLOR 204 204 204
	        OUTLINECOLOR 5 5 5
	      END  #STYLE
	    END #CLASS
		
	    CLASS
	      NAME 'Québec'
	      EXPRESSION 'Québec'
	      TEMPLATE 'null'
	      STYLE
	        COLOR 204 204 204
	        OUTLINECOLOR 5 5 5
	      END  #STYLE
	    END #CLASS
	
	    CLASS
	      NAME 'Atlantic'
	      EXPRESSION 'Atlantic'
	      TEMPLATE 'null'
	      STYLE
	        COLOR 246 197 103
	        OUTLINECOLOR 5 5 5
	      END  #STYLE
	    END #CLASS
	
	    PROJECTION
	      "init=epsg:4326"
	    END
	  END  #LAYER

What am I missing?

Thanks again,

Josh

-----Original Message-----
From: Howard Butler [mailto:hobu.inc at gmail.com] 
Sent: Tuesday, September 11, 2007 11:43 AM
To: Josh Hevenor
Cc: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: Mapserver SDE 9.2 Question

No, the 9.1 ArcSDE SDK dlls are not sufficient to connect to 9.2 with  
the 9.2 plugin.    The plugins are linked against each specific  
version of the ArcSDE SDK and have to be matched.  The use of plugins  
makes this less obnoxious than it was in the past, which required  
swapping out the entire libmap.dll, but it is still some hassle.

The rules for ArcSDE MapServer connections are as follows:
- If you have to connect to both ArcSDE X.1 and X.2 servers, use the  
X.2 version of the ArcSDE SDK.  You can usually connect to a X.1  
version server with X.2 version client DLLs without ill effect.
- To connect to X.2 servers, you *have* to use X.2 versions of the  
ArcSDE SDK.
- Do not use both the X.1 and X.2 versions of the plugins in the same  
MapServer map if you have to connect to both X.1 and X.2 version  
servers.  Just use X.2.

Howard

On Sep 11, 2007, at 10:21 AM, Josh Hevenor wrote:

> I had a quick question on using the msplugin_sde_92.dll to connect  
> to an SDE service from mapserver. The SDE Notes from the README  
> file state the following:
>             As of Map Server 5.0 (including betas and release  
> candidates), the following applies:
>
> Steps to Enable SDE 9.1 and 9.2 Support in MS4W's Map Server
>
> ***********************************************************
>
> 1.    Make sure the ArcSDE? SDK dlls for 9.1 are available on... But  
> it doesn't mention arcSDE 9.2 SDK dll's for connecting to a 9.2  
> service. Are the 9.1 dll's sufficient? I'm just working through my  
> setup and thought I should clear this up as I go along.  Thanks,
>
>
> Josh Hevenor
> Application Developer
> ____________________________________________
> 5230 South Service Road
> Burlington, Ontario
> L7L 5K2  Canada
> Phone: 905-333-4544 ext. 19
> Fax: 905-333-0455
> Cell: 905-320-7525
> Email: josh.hevenor at dpra.com
> Internet: http://www.dpra.com
> <image001.jpg>
>
>
>
>
>
>
> Attention:
> Privileged/Confidential Information may be contained in this  
> message. Disclosure to any person other than the named recipient is  
> unauthorized. If you are not the intended recipient, please delete  
> all copies of this information and kindly notify the sender by  
> reply email. Opinions, conclusions and other information in this  
> message that do not relate to the official business of DPRA shall  
> be understood as neither given nor endorsed by it. DPRA and any of  
> its subsidiaries reserve the right to monitor all e-mail  
> communications through its networks. Thank you.
>
>
>
>