AQ Adapter Under Stress Returns Error "ORABPEL-11947 - Enqueue Failed, SQL Wrapper Has Been Closed"

(Doc ID 444619.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle(R) BPEL Process Manager - Version 10.1.3.1 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Sep-2010***


Symptoms

You have a BPEL process which enqueues an XML message into a queue using an AQ adapter. You have applied <patch 5877231> to ensure you are using the latest AQ adapter.
You have set validate-connection=true and inactivity-timeout for the data source.

While doing a stress test you get following error:

Enqueue failed; nested exception is:
ORABPEL-11947 Please examine the log file to determine the problem.

SQL wrapper has been closed!


The domain log file contains the following error:


<ERROR> <default.collaxa.cube.ws> <AQ Adapter::Outbound>
java.sql.SQLException: SQL wrapper has been closed!
at oracle.oc4j.sql.proxy.SQLBCELProxy.oc4j_intercept(SQLBCELProxy.java:296)
at oracle_jdbc_driver_T4CPreparedStatement_Proxy.executeQuery()
at oracle.tip.adapter.aq.database.Queue.getEmptyCLOB(Queue.java:152)
at oracle.tip.adapter.aq.database.EnqueueObject.setCLOBElement(EnqueueObject.java:156)
at
oracle.tip.adapter.aq.database.MessageWriter.buildEnqueueObject(MessageWriter.java:1070)


On debugging, using any of the data source, transaction or JDBC debug options below

-Ddatasource.verbose=true
-DDataSourceConnection.debug=true
-Djdbc.connection.debug=true
-Djdbc.debug=true
-Dtransaction.debug=true

you may also see the following error

oracle.AQ.AQException: JMS-184: Queue object is invalid
at oracle.AQ.AQUtil.throwAQEx(AQUtil.java:167)
at oracle.AQ.AQOracleQueue.enqueue(AQOracleQueue.java:1028)
at oracle.tip.adapter.aq.database.MessageWriter.doEnqueue(MessageWriter.java:640)
at oracle.tip.adapter.aq.database.MessageWriter.enqueue(MessageWriter.java:381)
at oracle.tip.adapter.aq.database.MessageWriter.writeMessage(MessageWriter.java:343)
at oracle.tip.adapter.aq.outbound.AQEnqueuer.execute(AQEnqueuer.java:111)

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