My Oracle Support Banner

Pool SOALocalTxDataSource Is Suspended, Cannot Allocate Resources to Applications (Doc ID 1577515.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 to 11.1.1.9.0 [Release 11gR1 to 11g]
Oracle SOA Suite - Version 12.1.3.0.0 and later
Identity Manager - Version 11.1.2.3.181009 to 11.1.2.3.181009 [Release 11g]
Information in this document applies to any platform.

Symptoms

The following error occurred as a result of a database issue where the SOAINFRA schema is run.

The SOALocalTxDataSource pool became suspended and did not automatically reconnect when the DB issue was resolved.

ERROR
------------
[2013-07-30T07:11:24.399-04:00] [soaServer_p1fsn1m1] [ERROR] [] [oracle.soa.bpel.system] [tid: <TID>] [userId: ] [ecid: <ECID>] [APP: soa-infra] [composite_name: INS_OR_SVC] [component_name: ORBusSrvc] [component_instance_id: <ID>] Error while invoking bean "cube delivery": Exception not handled by the Collaxa Cube system.[[
an unhandled exception has been thrown in the Collaxa Cube systemr; exception reported is: "weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications..
at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:251)
at weblogic.jdbc.common.internal.RmiDataSource.getPoolConnection(RmiDataSource.java:456)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:538)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:498)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:491)
at oracle.integration.platform.instance.store.DOStore.getConnection(DOStore.java:663)
at oracle.integration.platform.instance.store.DOStore.performActivity(DOStore.java:636)
at oracle.integration.platform.instance.store.DOStore.retryPerformImmediate(DOStore.java:620)

 

BUSINESS IMPACT
-----------------------
BPEL transactions which use the SOALocalTxDataSource can not complete properly.

Changes

 

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
Changes
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.