AQ Support For Topics Fails With "java.sql.SQLException: ORA-25226: dequeue failed" Error After Applying 18.104.22.168.160719 PSU
(Doc ID 2308103.1)
Last updated on DECEMBER 11, 2017
Applies to:Oracle WebLogic Server - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, WLS JMS
When attempting to send messages to the CACHE_NOTIFICATION listener MDB after applying patch 24904852 and later, it is observed that the MDB fails to receive the messages on the AQ Topic. The following error occurs:
#### <[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <>
#### <> <> Nested exception: java.sql.SQLException: ORA-25226: dequeue failed, queue SSVM888_ODB.CACHE_TOPIC is not enabled for dequeue
Full stack trace is as follows:
Apply <Patch 24904852> and later.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!