1. Installation and Configuration Guide
  2. Performing Manual Configuration Tasks in a New Deployment
  3. Financial Close Management and Tax Governance Manual Configuration Tasks
  4. Raising the Maximum Capacity in the Connection Pool

Raising the Maximum Capacity in the Connection Pool

If necessary, fine tune the data source to size the connection pool.

To raise the maximum capacity in the connection pool:

  1. In the WebLogic Administration Console (http://WebLogic_Admin_Host:WebLogic_Admin_Port/console), select Services, then JDBC, and then Datasources.
  2. Select your data source, then Connection Pool, and then Maximum Capacity.
  3. Edit settings to increase capacity as follows:

    • financialclose_datasource—150

    • financialclosecommon_datasource—150

    If resource errors specific to these data sources are logged, increase their capacity:

    • EPMSystemRegistry

    • supplementaldata_datasource
    • taxoperations_datasource
    • taxsupplementalschedules_datasource

Note:

You can increase the capacity for each data source by a different amount, depending on the needs for your installation.

If the Oracle Hyperion Financial Close Management or Oracle Hyperion Tax Governance log includes this error message: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/data source' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool data source is Suspended, cannot allocate resources to applications..], then you have exceeded the maximum connections allowed in the connection pool for the specified data source, and you need to increase the capacity of the connection pool.