<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML DIR=ltr><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"></HEAD><BODY>
<P dir=ltr><FONT face="Courier New" color=#000000 size=2>Hi,</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>I have a problem with MapServer
connecting to our ArcSDE server.<BR>The error logs show a "Premature
end of script headers" error.<BR>I'm using MapServer 4.8.4 and have tried
4.10.0, which also returns the same error.<BR></FONT><FONT
face="Courier New" size=2>Previously, I used MapServer 4.6.2 and have had no
problems connecting to ArcSDE.<BR></FONT><FONT face="Courier New" size=2><BR>In
all three cases (MapServer 4.8.4, 4.10.0 and 4.6.2), I used the same
mapfile.</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>The different versions of MapServer
were compiled with ArcSDE support <BR></FONT><FONT face="Courier New"
size=2>using the maptools.org "fgs" toolkit on Red Hat Linux
servers.</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>If you have used MapServer 4.8.4 or
4.10.0 connecting to ArcSDE on Red Hat Linux successfully,<BR>I'd like
to hear from you.</FONT><FONT face="Courier New"
size=2><BR><BR>ENVIRONMENT</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>We have the MapServer running on a
Linux box and ArcSDE running on a Windows box.</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>MapServer Server:<BR></FONT><FONT
face="Courier New" size=2>* MapServer 4.8.4<BR></FONT><FONT face="Courier New"
size=2>* Red Hat ES4</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>ArcSDE Server:<BR>* Windows 2003
Server.<BR>* ArcSDE </FONT><FONT face="Courier New" size=2>9.1 (Release: 91003)
[BugFix: 0]<BR>* </FONT><FONT face="Courier New" size=2>Oracle9i Build
1269</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>ERROR LOGS:</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>I turned on error logging in
MapServer and here are the results:</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>Debug Information from MapServer
4.8.4</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>[Thu Feb 15 15:31:57 2007].578336
msWMSLoadGetMapParams(): enabling non-square pixels.<BR>[Thu Feb 15 15:31:57
2007].590997 msDrawMap(): kicking into non-square pixel preserving mode.<BR>[Thu
Feb 15 15:31:57 2007].591072 msSDELayerOpen(): Layer CALM_REGIONS opened from
scratch.<BR>[Thu Feb 15 15:31:58 2007].119776
msConnPoolRegister(CALM_REGIONS,sliptest,port:5151,slip,sde,aslkzxmn,0x93d5ab8)<BR>[Thu
Feb 15 15:31:58 2007].119834 msSDELayerOpen(): Layer CALM_REGIONS specified
version SDE.DEFAULT.<BR>[Thu Feb 15 15:31:58 2007].121464 msSDEGetLayerInfo():
Looking for layer by SDE.CALM_REGIONS, SHAPE,
sliptest,port:5151,slip,sde,aslkzxmn<BR>[Thu Feb 15 15:31:58 2007].121516
msSDEGetLayerInfo(): No cached layerid found.<BR>[Thu Feb 15 15:31:58
2007].123143 msSDELCacheAdd(): Caching id for SDE.CALM_REGIONS, SHAPE,
sliptest,port:5151,slip,sde,aslkzxmn<BR>[Thu Feb 15 15:31:58 2007].124391
msSDELayerGetRowIDColumn(): Table was not registered, returning
SE_ROW_ID.<BR>[Thu Feb 15 15:31:58 2007].124620 msSDELayerGetRowIDColumn():
Table was not registered, returning SE_ROW_ID.<BR>[Thu Feb 15 15:31:58 2007]
[error] [client 172.20.249.52] Premature end of script headers:
/MapServer410/www/cgi-bin/mapserv</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>On MapServer 4.6.2, which succeeded
in returning an image, I also obtained debugging information to
compare:</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>Debug Information from MapServer
4.6.2</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>[Fri Feb 16 13:13:41
2007].3009 msWMSLoadGetMapParams(): enabling non-square
pixels.<BR>[Fri Feb 16 13:13:41 2007].12309 msDrawMap(): kicking into
non-square pixel preserving mode.<BR>[Fri Feb 16 13:13:41 2007].12389
msSDELayerOpen(): Layer CALM_REGIONS opened from scratch.<BR>[Fri Feb 16
13:13:41 2007].571953
msConnPoolRegister(CALM_REGIONS,sliptest,port:5151,slip,sde,aslkzxmn,0x82d1000)<BR>[Fri
Feb 16 13:13:41 2007].572006 msSDELayerOpen(): Layer CALM_REGIONS specified
version SDE.DEFAULT.<BR>[Fri Feb 16 13:13:41 2007].586505 msSDEGetLayerInfo():
Looking for layer by SDE.CALM_REGIONS, SHAPE,
sliptest,port:5151,slip,sde,aslkzxmn<BR>[Fri Feb 16 13:13:41 2007].586526
msSDEGetLayerInfo(): No cached layerid found.<BR>[Fri Feb 16 13:13:41
2007].593036 msSDELCacheAdd(): Caching id for SDE.CALM_REGIONS, SHAPE,
sliptest,port:5151,slip,sde,aslkzxmn<BR>[Fri Feb 16 13:13:41 2007].594426
msSDELayerGetRowIDColumn(): Table was not registered, returning
SE_ROW_ID.<BR>[Fri Feb 16 13:13:41 2007].594652 msSDELayerGetRowIDColumn():
Table was not registered, returning SE_ROW_ID.<BR>[Fri Feb 16 13:13:41
2007].729126 msDrawMap(): Layer 1 (CALM_REGIONS), 0.717s<BR>[Fri Feb 16 13:13:41
2007].729202 msDrawMap(): Drawing Label Cache, 0.000s<BR>[Fri Feb 16 13:13:41
2007].729233 msDrawMap() total time: 0.717s<BR>[Fri Feb 16 13:13:41 2007].732874
msPOSTGISLayerClose datastatement: the_geom from cadastre<BR>[Fri Feb 16
13:13:41 2007].732905 msPOSTGISLayerClose -- layerinfo is NULL<BR>[Fri Feb
16 13:13:41 2007].732923 msSDELayerClose(): Closing layer CALM_REGIONS.<BR>[Fri
Feb 16 13:13:41 2007].732962
msConnPoolRelease(CALM_REGIONS,sliptest,port:5151,slip,sde,aslkzxmn,0x82d1000)<BR>[Fri
Feb 16 13:13:41 2007].732983
msConnPoolClose(sliptest,port:5151,slip,sde,aslkzxmn,0x82d1000)</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>Here is the
mapfile LAYER definition that we tried connecting.</FONT></P>
<P dir=ltr><FONT face="Courier New"
size=2>
LAYER<BR> NAME
"CALM_REGIONS"<BR> CONNECTION
"sliptest,port:5151,slip,sde,aslkzxmn"<BR>
CONNECTIONTYPE SDE<BR> DATA
"SDE.CALM_REGIONS,SHAPE,SDE.DEFAULT"<BR>
DEBUG ON<BR> STATUS
ON<BR> GROUP
"CALM"<BR> DUMP true #required
for wfs<BR> TYPE
polygon<BR> TEMPLATE
'demo.html'<BR>
METADATA<BR>
"wms_title" "CALM -
CALM Regions"<BR>
"wms_srs"
"EPSG:4283 EPSG:4326 EPSG:28349 EPSG:28350 EPSG:28351
EPSG:28352"<BR>
"wms_extent" "112.866
-35.2419 129.001
-13.5101"<BR>
"wms_group_title"
"CALM"<BR>
"gml_include_items" "all" ## optional (serves all attributes
for layer)<BR> END
#METADATA</FONT></P>
<P dir=ltr><FONT face="Courier New"
size=2>
PROJECTION<BR>
"init=epsg:4283"<BR>
END</FONT></P>
<P dir=ltr><FONT face="Courier New"
size=2>
CLASS<BR> NAME
'CALM_Regions'<BR>
STYLE<BR> SYMBOL
"line-vertical"<BR>
COLOR 0 0 255<BR>
OUTLINECOLOR 0 0
0<BR> SIZE
5<BR> END
#STYLE<BR>
STYLE<BR> SYMBOL
"line-horizontal"<BR>
COLOR 0 0 255<BR>
OUTLINECOLOR 0 0
0<BR> SIZE
5<BR> END
#STYLE<BR> END
#CLASS<BR> END #LAYER<BR></FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>I would greatly appreciate it if
anyone can offer any help in this matter.<BR></FONT><FONT face="Courier New"
size=2><BR>Sincerely,</FONT></P>
<P dir=ltr><FONT face="Courier New" size=2>Stephen Shim<BR>SLIP Team </FONT></P>
<P dir=ltr><FONT face="Courier New" size=2></FONT> </P>
<P dir=ltr RE><FONT face="Courier New" size=2>Email: </FONT><A
href="mailto:Stephen.Shim@ca.com"><FONT face="Courier New"
size=2>Stephen.Shim@ca.com</FONT></A><BR><BR><FONT face="Courier New" size=2>CA
Phone: 9488 8193 </FONT></P>
<P dir=ltr><FONT face="Courier New" size=2></FONT> </P>
<P dir=ltr RE><FONT face="Courier New" size=2> </FONT></P>
<P dir=ltr> </P></BODY></HTML>