Hi,
I get this error "
Service started with errors
Data_xxxxx.MapServer:
GIS-PROD2.BUCKNELL.EDU
Instance of service 'Data_xxxx.MapServer' started with errors. Maximum number of connections to instance exceeded
GIS-PROD.BUCKNELL.EDU
Instance of service 'Data_xxx.MapServer' has been successfully created.
" when I change the "Maximum number of instances per machine" via server manager.
I am not sure if it is because we hit the max connection to the sde? If yes, how do we calculate the connections to the sde? And why do I get the error on one machine -"GIS-PROD2" instead of failing on two of the machines?
Or this is something else?
Thanks
Luyang
Solved! Go to Solution.
You can check the Process_Information table for the total number of connections to the geodatabase when you get the error. It will give you more details as to where the connections are coming from.
The Connections limit also depends on the type of SDE geodatabase that you are using:
64 (starting from 10.1 sde gdb)
This parameter is set in the Server_config table in the database.
You can check the Process_Information table for the total number of connections to the geodatabase when you get the error. It will give you more details as to where the connections are coming from.
The Connections limit also depends on the type of SDE geodatabase that you are using:
64 (starting from 10.1 sde gdb)
This parameter is set in the Server_config table in the database.
Thank you Asrujit! This is helpful. It turned out that we do hit the limit of the connection. I heard 10.3 has no limitation on the sde and we are 10.2.2. So we plan to upgrade in the summer.
But, I sitll don't understand why only one server gave me this error and another one was fine with it.
Yes, starting from 10.3, the limit is by default set to 999999 (if I recall correctly).
However, you can increase this limit in 10.2.2 sde geodatabase as well. You do not need to upgrade the sde gdb, if this is the only requirement.
Also check this other thread: