Deq_time Column not Updated when Message Dequeued (Doc ID 1293709.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.5.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-November-2013***

Symptoms

The column DEQ_TIME for the queue_table 'WF_BPEL_QTAB' is not being updated after messages have been successfully dequeued by the WF_BPEL_Q subscriber from a queue with the same_name and the messages for this subscriber remained in READY state.
 
This means that because the message remains in a Ready state then the AQ processes will not remove it from the queue, even though it has already been consumed. Over time these messages may cause file system issues as data remains stored in rdbms tablespaces which directly relates to file system file growth on hard disk drives - also affecting the rdbms due to performance issues.

Changes

None

 
 

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