Recommendation for the connection pool settings with TIBCO BusinessWorks ProcessMonitor 3.0.0.x and 3.0.1.
book
Article ID: KB0093193
calendar_today
Updated On:
Products
Versions
TIBCO BusinessWorks ProcessMonitor
-
Not Applicable
-
Description
Resolution: In TIBCO BusinessWorks ProcessMonitor (BWPM) we have to set the Connection Pool Size under the JDBC settings (Administration>Connections>JDBC) to ensure enough connections are available in the connection pool and avoid the error, "Error pool empty. Unable to fetch a connection in 30 seconds".
The connection pool is used both for writing and reading data from the database. It is recommended to set this value as per a rule of thumb. With BWPM 3.0.0.x and previous versions, the value for the connection pool should be
<number of data provider threads> + 5 * < average amount of
concurrent GUI users> + 10. In BWPM version 3.0.1, the value for the connection pool size should be
set to 1.5 * <number of data provider threads> . GUI connections will not be considered while setting the connection pool size.
Issue/Introduction
Recommendation for the connection pool settings with TIBCO BusinessWorks ProcessMonitor 3.0.0.x and 3.0.1.
Additional Information
SR # 83 (https://support.integrationmatters.com/hc/en-us/requests/83?page=4 )