My Oracle Support Banner

No resources currently available in pool mds-soa to allocate to applications, please increase the size of the pool and retry (Doc ID 2540111.1)

Last updated on JUNE 21, 2023

Applies to:

SOA Suite Cloud Service - Version N/A and later
Oracle SOA Suite - Version 12.2.1.2.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

Even when there is no activity in the database, the mds-soa datasource is not releasing connections.

In the logfiles, the following warning can be seen:

weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mds-soa to allocate to applications, please increase the size of the pool and retry..

 

eg:

<Mar 13, 2019 1:45:42,626 PM UTC> <Warning> <oracle.integration.platform> <SOA-20137> <Local Binding: unable to circumvent SOAP/HTTP for local invocation. It is possible that the service is not available locally, is not an SCA service, or that there are policy references attached to the source or destination binding.
oracle.fabric.common.FabricException: Error in getting XML input stream: WADLs/PopulateSOACrossReferenceRestService.wadl: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mds-soa to allocate to applications, please increase the size of the pool and retry..
at oracle.integration.platform.common.MDSMetadataManagerImpl.getDocumentAsInputStreamUsingCustomization(MDSMetadataManagerImpl.java:644)
at oracle.integration.platform.common.MDSMetadataManagerImpl.getDocumentAsInputStream(MDSMetadataManagerImpl.java:586)
at oracle.integration.platform.blocks.rest.bc.WADLManager.isWADLAvailableInMDS(WADLManager.java:37)
..
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused By: oracle.mds.exception.MDSRuntimeException: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mds-soa to allocate to applications, please increase the size of the pool and retry..
at oracle.mds.internal.persistence.db.BaseReposAccess.<init>(BaseReposAccess.java:510)
at oracle.mds.internal.persistence.db.shredded.ShreddedReposAccess.<init>(ShreddedReposAccess.java:298)
..
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused By: oracle.mds.internal.persistence.db.fcf.MDSDBIOException: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mds-soa to allocate to applications, please increase the size of the pool and retry..
at oracle.mds.internal.persistence.db.JNDIConnectionManagerImpl.fetchConnection(JNDIConnectionManagerImpl.java:331)
at oracle.mds.internal.persistence.db.ConnectionManager.getConnection(ConnectionManager.java:456)
...
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused By: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mds-soa to allocate to applications, please increase the size of the pool and retry..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:276)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:552)
...
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.