AQ Support For Topics Fails With "java.sql.SQLException: ORA-25226: dequeue failed" Error After Applying 12.1.3.0.160719 PSU

(Doc ID 2308103.1)

Last updated on DECEMBER 11, 2017

Applies to:

Oracle WebLogic Server - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3.0.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:

 



Changes

 Apply <Patch 24904852> and later.

 

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