So I upgraded our internal development
ArcSDE serverfrom 8.3 to 9.0 (so it would be running on my EDN licenses
and we could drop the “commercial” license). Anyhow, all went well, and
I moved on to other issues (ArcGIS Server development, Ajax-ifying our
GeoPortal etc). However, yesterday I noticed that one of our demo sites
(http://dev.sanborn.com/kls) decided it was not going to make maps anymore.
Thus I followed the usual ArcIMS problem solving technique:
Step 1: Restart ArcIMS
Step 2: Re-boot the server.
Step 3: swear and threaten to kick the box
Actually
step 3 was look at the logs, which non-specifically (I was only logging
errors) indicated the issue was with a map service using ArcSDE. Thus I
tried to connect to the instance from ArcCatalog, when low and behold -
it popped up with a “No Connections Availible” message.
Luckily, I’d been roaming the GIS blogosphere, and recalled a post over at the ROKTechnologies developers blog about this very thing.
Apparently
when you upgrade to 9.0, it handily sets the maximum number of
connections to 48. I’m sure that this is noted somewhere in the release
notes or elsewhere that any experienced ArcSDE person would completely
ignore. Since this is a pretty critical item (i.e. your system will not
work as it used to) I’d suggest that ESRI puts this on it’s own dialog
at the end of the install in bright red – i.e.
NOTICE: WE HAVE SET THE MAX CONNECTIONS TO 48. IF YOU CURRENTLY
USE MORE THAN 48 CONNECTIONS TO ARCSDE, YOU MUST CHANGE THIS SETTING
Anyhow, here’s the quick solution:
Step 1: Open the SDE_SERVER_CONFIG table,
Step 2: set the CONNECTIONS value to whatever you want.
Step 3: Restart ArcSDE
This is easier than foolin with loading a defs file etc.
