Skip to main content
A
Anonymous
December 20, 2011
Question

What is the reason for this "max connections" error?

  • December 20, 2011
  • 1 reply
  • 928 views

RH9 Server

On attempting a publish, the RH server is not contactable.

The Web ADmin has reported this message:

"java.sql.SQLException: Maximum possible connections are open and all the connections are busy. Kindly review the "maxload" in the server.properties file and adjust it according to the expected load."

This topic has been closed for replies.

1 reply

RoboColum_n_
RoboColum_n_
Legend
January 4, 2012

In your server.properties file there is a setting that controls the maximum number of connections that are allowed. It sounds like this number has been exceeded. Now I am not a server or database wizard so I have no idea why this is so. I've certainly not come across this scenario. Could it be that the connections are not being released when they are finished with? You'd probably need to speak to your IT or Server peeps to check this out. If all else fails the vale of your connections limit could be increased, but I don't know what implications this could have.

  The RoboColum(n)   @robocolumn   Colum McAndrew
johndaigle
johndaigle
Legend
January 4, 2012

Adding to Colum's good suggstions. I thought I'd point out that the error message thrown "server.properties" is actually robohelp_server.properties. Your server admin can find it along this path on the server machine.

C:\Program Files (x86)\Adobe\Adobe RoboHelp Server 9\WEB-INF\robohelp_server.properties

Here is the default way the attributes are installed:

DefAdminPwd=admin

DefAdminUid=admin

maxload=150

dsnuser=

reindex=true

authtype=db

ProjectsUrlBase=/robohelp/robo

substringsearch=false

DSN=

ProjectsDirBase=c:\\program files (x86)\\adobe\\adobe robohelp server 9\\robo

DatabaseType=access

dsnpwd=

So it would seem that you might experiment with increasing the maxload as shown.

Also, I'm not sure it's relevant here, but you might also check the Tomcat Administration app and its "Java Tab" properties and assure that

the admin specifies 256 as the value for both the Initial Memory Pool and Maximum Memory Pool boxes.

John Daigle

Adobe Certified RoboHelp and Captivate Instructor

Evergreen, Colorado

www.showmethedemo.com

John DaigleAdobe Certified RoboHelp and Captivate InstructorNewport, Oregon
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices