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

Last updated on APRIL 28, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.6.0 version, BPEL Service Engine

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: orabpel.invoke.pool-4.thread-5] [userId: ] [ecid: d35549bbc641cc94:61c86674:14024d1ee06:-7ffd-000000000018b99a,1:403031] [APP: soa-infra] [composite_name: INS_OR_SVC] [component_name: ORBusSrvc] [component_instance_id: B77A0CE0F90811E28F69E94E008EC4CF] 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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms