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 laterOracle 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)
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 |