AQ Support For Topics Fails With "java.sql.SQLException: ORA-25226: dequeue failed" Error After Applying 22.214.171.124.160719 PSU
Last updated on DECEMBER 11, 2017
Applies to:Oracle WebLogic Server - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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.
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