3 Replies Latest reply: Jul 24, 2012 7:17 PM by vladodias RSS

    SOA Composite dequeue not removing message from the queue.

    robn77
      We have a simple process that populates a queue that we have a SOA Composite dequeuing.

      SOA processes the data just fine, but the message stays in the queue even after the process has done it's work. Then when the SOA Server is bounced, the messages all get reprocessed.

      It looks like once they reach the max_retries of 5, they move into the AQ$_XX_RHM_QUEUE_TBL_E error queue.

      This is our queue definition.

      BEGIN
      SYS.DBMS_AQADM.CREATE_QUEUE
      (
      QUEUE_NAME => 'APPS.XX_RHM_QUEUE'
      ,QUEUE_TABLE => 'APPS.XX_RHM_QUEUE_TBL'
      ,QUEUE_TYPE => SYS.DBMS_AQADM.NORMAL_QUEUE
      ,MAX_RETRIES => 5
      ,RETRY_DELAY => 0
      ,RETENTION_TIME => 0
      );
      END;
      /

      BEGIN
      SYS.DBMS_AQADM.START_QUEUE
      (
      QUEUE_NAME => 'APPS.XX_RHM_QUEUE'
      ,ENQUEUE => TRUE
      ,DEQUEUE => TRUE
      );
      END;