OraFAQ Forum: Streams & AQ » Messages not moving to Exception Queue even after retry count reaches its maximum value.

Home » Server Options » Streams & AQ » Messages not moving to Exception Queue even after retry count reaches its maximum value.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Messages not moving to Exception Queue even after retry count reaches its maximum value. [message #194359]

Thu, 21 September 2006 11:55

parthes_t
Messages: 1
Registered: September 2006
Location: Chennai,India

Junior Member

Hi,

As per the AQs documents,messages are moved to the exception queue, when the number of unsuccessful dequeue attempts has exceeded the maximum number of retries, or the message has expired. So i set the expiration time as 10 mins and the maximum retry count as 8. But the messages are not getting expired even after 10 mins or when dequeue attempts reaches 8.

This is the procedure which i used to enqueue messages into Queue.

CREATE OR REPLACE PROCEDURE ENQ_REND_IMAGE AS
enqueue_options dbms_aq.enqueue_options_t;
message_properties dbms_aq.message_properties_t;
message_handle RAW(16);
message IMAGE.OMDQ_OUTG_MSG_OBJ;
message_rpt_blk IMAGE.OMDQ_OUTG_MSG_OBJ_RPT_BLK_AR;
message_trgsys IMAGE.OMDQ_OUTG_MSG_OBJ_RPT_BLK;
BEGIN
message_properties.exception_queue := 'IMAGE.OMDQ_OUTG_MSG_EXP';
message_properties.expiration:= 600;
message_rpt_blk:= IMAGE.OMDQ_OUTG_MSG_OBJ_RPT_BLK_AR(
IMAGE.OMDQ_OUTG_MSG_OBJ_RPT_BLK('08','ACAT_INITIATION','20060616060912924958','ATD050000VU1'), IMAGE.OMDQ_OUTG_MSG_OBJ_RPT_BLK('08','ACAT_INITIATION','20060816060750289512','ATD050000XT3'), IMAGE.OMDQ_OUTG_MSG_OBJ_RPT_BLK('08','ACAT_INITIATION','20060706043155282038','ATD050000X2T'));
message := IMAGE.OMDQ_OUTG_MSG_OBJ(
'IMAGE','LOAS','396001','IMD0500000S7','3CR000009','50','IMD0500000S8','10','loas','N','field6','field7','field8','field9','field10', 'field11','field12','field13','field14','field15','field16','field17','field18','field19','field20','3',message_rpt_blk);
dbms_aq.enqueue(
queue_name => 'IMAGE.OMDQ_OUTG_MSG',
enqueue_options => enqueue_options,
message_properties => message_properties,
payload => message,msgid => message_handle);
COMMIT;
END;

Thanks in Advance,

regards,
Partip

Report message to a moderator

Previous Topic:	9i to 10g replication
Next Topic:	dbms_aq.namespace_aq is not available in Oracle 8i.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 07:01:57 CST 2024