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.
Was this article helpful?
Yes
No
Powered by
