Default maximum connections size is too small in IBM Business Process Manager (BPM) 7.5
The default data source maximum connection size for IBM Business Process Manager is 10. This value is too small for all installations other than a test on a laptop computer. This setting is resolved in IBM Business Process Manager V8.0 and later
You might see one or more of the following messages in the SystemOut.log file:
Caused by: com.lombardisoftware.client.delegate.BusinessDelegateException: Could not get JDBC Connection; nested exception is com.ibm.websphere.ce.cm.ConnectionWaitTimeoutException: Connection not available, Timed out waiting for 180150
A related FFDC entry has the following text:
FFDC Exception:com.ibm.websphere.ce.j2c.ConnectionWaitTimeoutException SourceId:Max connections reached
[full stack trace omitted]
Maximum number of connections has been reached, and the connection request has been waiting longer than:ConnectionWaitTime. Two possible solutions : increase the max number of connections, or increase the:ConnectionWaitTime.:
Maximum Connections = :10
Current number of connections = :10
Connection Wait Timout = :180
The maximum connections for default data sources is too low.
Resolving the problem
To resolve this issue, complete the following steps in the WebSphere Administrative Console:
- Open a web browser and go to http://server_name:9060/ibm/console (default) where server_name is the name of your server.
- Navigate to Resources -> JDBC -> Data sources.
- Click each data source and check the Connection pool properties value, which is on the right side of the page.
- Change the maximum value to 100.
- Click OK.
- Click Save directly to the master configuration.
- Repeat the previous steps for each Business Process Manager data source.
- Restart the Business Process Manager servers to enable the settings take effect.
This recommended database connection maximum value comes from the way the event manager works. The default value for <max-thread-pool-size> is 50. This value is a summation of the <sync-queue-capacity>, <async-queue-capacity>, <bpd-queue-capacity>, and <system-queue-capacity> values from the 80eventmanager.xml file. If the configured values of individual queues increases, the <max-thread-pool-size> value needs to increase. The corresponding JDBC data source database connections need to be twice this value, so it is set to 100.
|Business Integration||IBM Business Process Manager Advanced||Installation / Configuration||AIX, Linux, Windows||7.5.1, 184.108.40.206, 7.5|
More support for:
IBM Business Process Manager Standard
Installation / Configuration
Software version: 7.5, 220.127.116.11, 7.5.1
Operating system(s): AIX, Linux, Windows
Reference #: 1573982
Modified date: 02 December 2011