[mapserver-users] SDE connect but not > once

[Dylan Keon]

I think Steve's right that it's something on the SDE side.  How many 
connections does your ESRI license allow?  It's possible that the 
connections you're opening are not being closed, resulting in the 
SE_CONNECTION_CREATE error when you try to open a new connection 
(although an SE_CONNECTIONS_EXCEEDED (-7) error would seem more likely 
in that case).

One thing to check is the TCPKEEPALIVE parameter in the giomgr.defs 
file.  If you set this to TRUE, hanging connections will be killed after 
a certain amount of time (2 hours, I think...it follows the system 
TCPKEEPALIVE setting).  But you might have to do some deeper digging to 
find out why SDE connections aren't closing right at the time MapServer 
closes them, if that's actually what's happening.

As far as monitoring connections (on Unix), use something like "sdemon 
-o info -I stats" at the command line.  Not sure of the syntax on 
Windows, but it's probably the same.  There are also commercial tools 
that will monitor connections, among other things (FME, SDA, etc).

HTH,
Dylan


-- 
************************************************
  Dylan Keon
  GIS/Database Research Specialist
  Northwest Alliance for Computational
  Science and Engineering (NACSE)
  Oregon State University
  Corvallis, OR 97331
  keon at nacse.org        (541) 737-6608
************************************************


Steve Lime wrote:

> Might there be something going on with the SDE side of things? MapServer
> creates (and then closes) a connection for each SDE layer. If for some
> reason SDE itself isn't dropping the connections that could result in
> all sorts of problems. I recall seeing this here several years ago but
> not recently. I'm not an SDE admin but I thought there was a tool to
> look at incoming connections and that might help in diagnosing this
> problem.
>
> Steve
>
> Stephen Lime
> Data & Applications Manager
>
> Minnesota DNR
> 500 Lafayette Road
> St. Paul, MN 55155
> 651-297-2937
>
>
> >>>"Murray, Ross"  10/28/02 01:13PM >>>
>
> I am connecting to an SDE coverage for spatial data. When initialised,
> the
> map showing all extents loads correctly into the mapplet (although it
> is
> significantly slower than a shapefile). Then I can  do what I wish
> (zoom,
> query, pan, print); BUT ONLY ONCE. For example, I choose a map I want
> from a
> drop-down list and, presto, there is the whole map in the applet. Then
> I
> zoom in to an area; poof, there is the area. Then I attempt to query a
> polygon in the area and I get:
>
>  	msSDELayerOpen(): SDE error. SE_connection_create(): Network
> I/O
> error. (-10)
>
> >From this point the only thing that works is to go to a different map
> or
> quit. That next map will load correctly and I can pan or query or zoom,
> but
> I can't pan and query or query and zoom or whatever. Same error every
> time.
>
> Any thoughts?
>
>
>  <>