How to resolve the Connection Pool error when querying the system tables in TIBCO Data Virtualization?
Article ID: KB0070970
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
When a user tries to query a system table in TDV using the Studio or from a client tool, they may come across the following error:
=============
Caused by: com.compositesw.cdms.datasource.IafException: Unable to obtain a connection from the connection pool for data source
"/system/datasources/repository". [data-2911001]
Caused by: com.compositesw.common.pool.PoolExhaustedException: Timeout 30 seconds to obtain a connection from pool 'systemTables'. All 50 connections are in use.
=============
Screenshot for reference taken from a client tool:
=============
Caused by: com.compositesw.cdms.datasource.IafException: Unable to obtain a connection from the connection pool for data source
"/system/datasources/repository". [data-2911001]
Caused by: com.compositesw.common.pool.PoolExhaustedException: Timeout 30 seconds to obtain a connection from pool 'systemTables'. All 50 connections are in use.
=============
Screenshot for reference taken from a client tool:
Resolution
This issue happens because the connection pool size is not set to a sufficient value to handle the queries against the system resources.
In Studio, under Administration > Configuration the following setting needs to be increased:
Server > Configuration > Repository Database > Connection Pools > System Pool > Pool Maximum Size (On Server Restart)
In Studio, under Administration > Configuration the following setting needs to be increased:
Server > Configuration > Repository Database > Connection Pools > System Pool > Pool Maximum Size (On Server Restart)
Issue/Introduction
This article will provide the change required to avoid the Connection Pool error when querying the system tables in TIBCO Data Virtualization.
Feedback
Yes
No
Powered by
