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

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

    • EDNDataSource (Oracle Database only)

    • EDNLocalTxDataSource (Oracle Database only)

    • mds-owsm

    • mds-soa

    • EPMSystemRegistry

    • OraSDPMDataSource

    • SOADataSource

    • SOALocalTxDataSource

Note:

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

If the Financial Close Management 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.