How to increase the connection pool size for 'system' data source in TIBCO Data Virtualization?
Article ID: KB0072128
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
This article provides the configuration details on the system data source, if the following error is encountered in TIBCO Data Virtualization (TDV):
Caused by: java.sql.SQLException: Timeout 30 seconds to obtain a connection from pool 'systemTables'. All 50 connections are in use.
Environment
All Supported Operating Systems
Resolution
Follow the below steps to increase the connection pool size:
(1) Login to TDV Studio, browse to "Administration > Configuration Panel" and search for ' Pool Maximum Size' in the find dialog box, .
(2) Update the value of 'Pool Maximum Size (On Server Restart)' that is present under System Pool and System Table Pool. You may increase this value to 200 or more as per the requirement.
Screenshot for reference:
(3) Restart the TDV Server for the changes to take effect.
(4) Once TDV Server is restarted, the value under 'Pool Maximum Size (Current)' should be updated to the newer value.
Here is a screenshot for reference:
(1) Login to TDV Studio, browse to "Administration > Configuration Panel" and search for ' Pool Maximum Size' in the find dialog box, .
(2) Update the value of 'Pool Maximum Size (On Server Restart)' that is present under System Pool and System Table Pool. You may increase this value to 200 or more as per the requirement.
Screenshot for reference:
(3) Restart the TDV Server for the changes to take effect.
(4) Once TDV Server is restarted, the value under 'Pool Maximum Size (Current)' should be updated to the newer value.
Here is a screenshot for reference:
Issue/Introduction
How to increase the connection pool size for 'system' data source in TIBCO Data Virtualization?
Feedback
Yes
No
Powered by
