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)