IBM Support

Default maximum connections size is too small in IBM Business Process Manager (BPM) 7.5

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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


Cause

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:

  1. Open a web browser and go to http://server_name:9060/ibm/console (default) where server_name is the name of your server.

  2. Navigate to Resources -> JDBC -> Data sources.

  3. Click each data source and check the Connection pool properties value, which is on the right side of the page.

  4. Change the maximum value to 100.

  5. Click OK.

  6. Click Save directly to the master configuration.

  7. Repeat the previous steps for each Business Process Manager data source.

  8. Restart the Business Process Manager servers to enable the settings take effect.

If you perform load tests on your application and you run out of connections, you might need to change these values to a higher value. A maximum of one hundred (100) is a good starting value.

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.


Cross reference information
Segment Product Component Platform Version Edition
Business Integration IBM Business Process Manager Advanced Installation / Configuration AIX, Linux, Windows 7.5.1, 7.5.0.1, 7.5

Document information

More support for: IBM Business Process Manager Standard
Installation / Configuration

Software version: 7.5, 7.5.0.1, 7.5.1

Operating system(s): AIX, Linux, Windows

Reference #: 1573982

Modified date: 02 December 2011