AQ Adapter Doesn’t Process XMLtype Messages
(Doc ID 2431915.1)
Last updated on AUGUST 09, 2021
Applies to:Oracle SOA Suite - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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 188.8.131.52 (after applying patch p24816844_122120_Generic) dequeueing of an XMLType also works fine.
Errors such as :
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