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