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