3 Replies Latest reply on Jul 25, 2012 12:17 AM by vladodias

    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;