topic Re: Why I get the message "maximum number of connections to instance exceeded"? in Data Management Questions

Why I get the message "maximum number of connections to instance exceeded"?

JamalNUMAN — Sun, 11 Jul 2010 14:17:07 GMT

Why I get the message "maximum number of connections to instance exceeded"

Please, see the attached image that shows my question

Re: Why I get the message "maximum number of connections to instance exceeded"?

VinceAngelo — Sun, 11 Jul 2010 21:53:49 GMT

All ArcSDE instances have a limit on the number of concurrent users. If you reach the limit
you will get that message. If you have an Enterprise license, you can change CONNECTIONS
to a larger value (see the 'sdeconfig' command documentation), though you will eventully
start getting Windows errors instead of SE_CONNECTIONS_EXCEEDED if you set it too high.

Note: The non-interactive desktop heap OS connection limit is only on Windows server hosts,
and applies only to application server connections (not Direct Connect).

- V

Re: Why I get the message "maximum number of connections to instance exceeded"?

KimPeter — Mon, 12 Jul 2010 17:46:01 GMT

Just a tip: Some of the ArcSDE messages have been documented in the help topic ArcSDE error messages:

http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/ArcSDE_error_messages/009300001656000000/

This may help you get a little more information on an error message you get back from ArcSDE.

Hope this helps,

Kim

Re: Why I get the message "maximum number of connections to instance exceeded"?

StevenRehbaum — Tue, 13 Jul 2010 11:35:24 GMT

I was going to add that often times connections get hung. If you haven't changed the kill time in the config file, I would make the change. God luck.

Re: Why I get the message "maximum number of connections to instance exceeded"?

GaryBarden — Wed, 27 Apr 2011 13:38:37 GMT

Just wondering if there is a way to determine where the connections came from? Maybe a log file somewhere so we could determine what application/users were causing this error to be reported.

Thanks!

Re: Why I get the message "maximum number of connections to instance exceeded"?

RobertHu — Wed, 27 Apr 2011 14:45:11 GMT

"sdemon -o info -I users" will tell where a connection is from (machine/OS). If you can see the SDE system table, the information is in SDE_process_information table.

The GDBT tool should also give you some info.

Re: Why I get the message "maximum number of connections to instance exceeded"?

KenGalliher1 — Thu, 28 Apr 2011 20:18:40 GMT

Try this command:

sdeconfig -o list -P CONNECTIONS -D <Database Name> -i <Service> -s <Server Name> -u <SDE Username> -p <SDE Password>

This will show you how many connections you have available now. ArcSDE allows 48 by default.

Use this to change it:

sdeconfig -o alter -P CONNECTIONS=60 -D <Database Name> -i <Service> -s <Server Name> -u <SDE Username> -p <SDE Password>

the quantity can be of your choosing and make sure you have the administrative rights to alter the configuration. See this link for more details.

http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/support_files/admincmdref.htm

Re: Why I get the message "maximum number of connections to instance exceeded"?

PaulSprague — Fri, 29 Apr 2011 19:29:06 GMT

I am getting this same error with a new Workgroup Standard installation of 10.0 with sqlexpress. I did not have these issues on our 9.3 server.
Any ideas are appeciated.