Home » Server Options » Streams & AQ » Messages not moving to Exception Queue even after retry count reaches its maximum value.
icon7.gif  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

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


Current Time: Fri Mar 29 01:02:23 CDT 2024