Wednesday, December 14, 2005
ArcSDE 9.0
Posted on Wednesday, December 14, 2005 7:14:01 PM (Mountain Standard Time, UTC-07:00)  Comments [0] | 
Categories: ArcSDE | ESRI
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.
<img alt=" src="http://localhost/ad/smilies/openmouth.gif">


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.

Comments are closed.