Show TOC

rs_exceptslastLocate this document in the navigation structure

Stores the origin ID, secondary queue ID, and associated information about the last logged transaction written into the exceptions log.

Column

Datatype

Description

error_db

int

Database where the error occurred

origin

int

Origin database of the transactions

origin_qid

binary(36)

qid of the last transaction from this origin

secondary_qid

binary(36)

Secondary qid of the last logged transaction from this origin

status

tinyint

Status of the transaction:

  • 0 – Valid: no transactions were lost for this origin

  • 1 – Detecting losses: you should determine if any transactions have been lost in this origin

  • 2 – Rejecting messages after loss detected: transactions were probably lost for this origin

origin_time

datetime

Time at origin for the transaction

log_time

datetime

Time the transaction was logged

lorigin

int

Logical database where the message originated

Indexes
  • Unique index on (error_db, origin)

  • Unique index on (error_db, origin, status)