SOA Suite AQ Messaging Generates Error ORA-25228 in the Database Logs

(Doc ID 963159.1)

Last updated on OCTOBER 09, 2017

Applies to:

Oracle(R) BPEL Process Manager - Version to [Release AS10gR3]
Information in this document applies to any platform.
***Checked for relevance on 14-Sep-2011***


Using SOA Suite and Asynchronous AQ services returns ORA-25228 error messages in the database and also on the SOA server side indicating that the queue is empty.

Errors seen in the SOA container log files ($ORACLE_HOME/opmn/logs) :

ORA-25228: timeout or end-of-fetch during message dequeue from BPEL.AQ_TEST_29073_T
ORA-06512: at ""SYS.DBMS_AQIN"", line 571
ORA-06512: at line 1

Also timeout errors :


Message handle error.
An exception occurred while attempting to process the message
the exception is: Failed to create "java:comp/env/ejb/local/CubeEngineLocalBean" bean;
exception reported is: "javax.naming.NamingException:
  Cannot lookup java:comp/env attributes, not in a valid component
at com.evermind.server.Application.getEnvironmentContext(
at com.evermind.server.ApplicationContext.getEnvironmentContext(
at com.evermind.server.ApplicationContext.lookupInJavaContext(
at com.evermind.server.ApplicationContext.unprivileged_lookup(
at com.evermind.server.ApplicationContext.lookup(
at javax.naming.InitialContext.lookup(
at com.collaxa.cube.engine.util.EngineBeanRegistry.lookupEngineLocalBean(
at com.collaxa.cube.engine.util.EngineBeanCache.getEngineLocalBean(
at com.collaxa.cube.engine.dispatch.message.domain.PerformRecoveryMessageHandler.handle
at com.collaxa.cube.engine.dispatch.DispatchHelper.handleMessage(
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
at java.util.concurrent.ThreadPoolExecutor$

ADDM Tool (Automatic Database Diagnostic Monitor) is giving the following message : Wait event SQL Net break/reset to client in wait class Application was consuming significant database time.


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