My Oracle Support Banner

AQ Adapter Doesn’t Process XMLtype Messages. (Doc ID 2431915.1)

Last updated on SEPTEMBER 05, 2018

Applies to:

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

Symptoms


AQ adapter doesn’t process XMLtype messages.

We have an Oracle Multi consumer advanced queue (AQ). The queue has a XMLType as a payload.
We have subscribed a BPEL process on this AQ with the AQ Adapter. When we enqueue a message on the AQ with PL/SQL, we can see that the message changes from the AQ state “READY” to “PROCESSED”. So this means that the message is dequeued.
However we don’t see a flow instance for the BPEL process in the EM of the soasuite.
Also the soa_infra table sca_flow_instance doesn’t show an instance.

When we enqueue another message, then the state of that new message remains “READY” in the AQ.
As a side effect, when we are in this situation (having dequeued one message), we are unable to undeploy the bpel process.

We’ve also tried the same situation with an SCA composite using an OSB service. This produces the same results.


An AQ based on a RAW message or an OBJECT TYPE works fine.
And on 12.2.1.2 (after applying patch p24816844_122120_Generic) dequeueing of an XMLType also works fine.


 

Errors such as : 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.