rs_exceptshdr

Stores information about failed transactions. The source and output commands of the transactions are stored in the system tables rs_exceptscmd and rs_systext. All rows for a transaction in rs_exceptscmd and rs_exceptshdr are identified by the column sys_trans_id.

Column

Datatype

Description

sys_trans_id

rs_id

System-assigned transaction ID for this transaction

rs_trans_id

binary(120)

Replication Server-generated unique transaction ID

app_trans_name

varchar(30)

User-specified transaction name

orig_siteid

int

ID of the origin database

orig_site

varchar(30)

Data server name for the origin database

orig_db

varchar(30)

Name of the origin database

orig_time

datetime

Time the transaction was initiated

orig_user

varchar(30)

User who submitted the transaction at the origin site

error_siteid

int

ID of the site where the error occurred

error_site

varchar(30)

Name of the data server where the error occurred

error_db

varchar(30)

Name of the database where the error occurred

log_time

datetime

Time the error occurred

ds_error

int

Data server error number

ds_errmsg

varchar(255)

Data server error message

error_src_line

int

Line number of the command that caused the error

error_proc

varchar(255)

Procedure during which the error occurred

err_output_line

int

Line number of the output command that caused the error

log_reason

char(1)

Why the transaction was logged:
  • O – indicates an orphan transaction in the DSI queue

  • E – a data server error mapped to LOG or RETRY_LOG

  • S – indicates the transaction was skipped because the resume connection command was executed with the skip transaction option

  • D – the transaction was logged by a sysadmin log_first_tran command

trans_status

smallint

Transaction status—one or more of these:

  • 0x0001 – orphan transaction

  • 0x0002 – logged transaction was going to primary site

  • 0x0004 – conflicting transaction

retry_status

smallint

Retry status for the transaction—one of these:

  • 1 – retry succeeded

  • 2 – transaction has not committed

app_usr

varchar(30)

Name of the user who applied the transaction at the error site

app_pwd

varchar(30)

Password of the user who applied the transaction at the error site

Indexes

Unique index on (sys_trans_id)