dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleQueueMessageProperties Class / ExceptionQueue Property

In This Topic
    ExceptionQueue Property
    In This Topic
    Gets or sets the name of the queue into which the message is moved if it cannot be processed successfully.
    Syntax
    'Declaration
     
    Public Property ExceptionQueue As String
    public string ExceptionQueue {get; set;}

    Property Value

    The name of the queue into which the message is moved if it cannot be processed successfully.
    Remarks

    Messages are moved automatically into the exception queue. Messages are moved into the exception queue in the following cases:

    • The number of unsuccessful dequeue attempts has exceeded the specification for the OracleQueueOptions.MaxRetries parameter.
    • For multiconsumer queues, the message becomes eligible to be moved to the exception queue even if failed dequeue attempts exceeds the OracleQueueOptions.MaxRetries parameter for only one of the consumers. But the message will not be moved until either all other consumers have successfully consumed the message or failed more than OracleQueueOptions.MaxRetries.
    • If a dequeue transaction fails because the server process dies (including ALTER SYSTEM KILL SESSION) or SHUTDOWN ABORT on the instance.
    • A message was not dequeued before the expiration time elapsed.
    • Message propagation to the specified destination queue failed with one of the following errors:
      There were no recipients for the multiconsumer destination queue.
      Recipients were specified for a single-consumer destination queue.
      Destination queue was an exception queue.
      There was an error when applying transformation.

    The default is the exception queue associated with the queue table. If the exception queue specified does not exist at the time of the move, the message is moved to the default exception queue associated with the queue table, and a warning is logged in the alert file. If the default exception queue is specified, then the parameter returns a NULL value at dequeue time.

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also