Enterprise Manager SQL Counting Mediator Instances and Associated Errors (Doc ID 1397878.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 09-August-2013***

Symptoms

- SQL being executed repeatedly:  SQLCall(SELECT /*+ INDEX(MEDIATOR_INSTANCE MEDIATOR_INSTANCE_INDEX6) */ count(*) FROM MEDIATOR_INSTANCE WHERE COMPONENT_NAME like ?)

- Associated errors in log:
-- java.lang.UnsupportedOperationException: Attribute applicable only for Service bindings
-- java.lang.RuntimeException: ORABPEL-9732
Persistency service internal error
-- weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications

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