rs_helpexception:

It displays transaction details that gets captured in the exception log and it is usually used when any replication thread goes down and we want to capture related transaction that caused replication failure.

Syntax

rs_helpexception [transaction_id, [, v]]

Login to Replication server and run below command to log the failed transaction into exception log.

1> syadmin log_first_tran, DS2,DB2
2> go

Now, login to RSSD database and run rs_helpexception command to display the transaction ID and then supply same transaction id to get the transaction detail.

1> rs_helpexception
2> go

Summary of Logged Transactions on 'REPSRV'

Total # of Logged Transactions = 1

Xact ID Org Site Org User Org Date Dest Site # Recs/Xact

——————- ————- ————- ————- ———

123 DS1.DB1 testuser Jun 13 2018 DS2.DB2 3

Here, 123 is transaction id and 3 denotes number of commands in the transaction. please note that rs_helpexception output contains transaction details along with some junk characters, so try to extract the transactions carefully.

1> rs_helpexception 123, v
2> go

Sample Output:

        Detailed Summary of Logged Transaction # 123      on 'REPSRV'

Origin Site                    Origin User     Org. Commit Date  #Cmds in Xact
—————————— ————— —————– ————-
DS1.DB1                 testuser          Jun  13 2018  10:20             3

Dest. Site                     Dest. User      Date Logged
—————————— ————— —————–
DS2.DB2                 DB2_maint   Jun  13 2018 11:02

This transaction was logged by the 'sysadmin log_first_tran' command.

textval:

——————————————————————————————-

A0100distribute :origin_time='Jun 13 10:20:24:416PM',:origin_user='',
:mode=1
begin transaction 'logexec' for 'eurian'/''
begin transaction
A0100distribute :origin_user='',:mode=1
exec "TT"."so_req_rep_all_allcon" @"p01"=80000709,@"p02"='MIL'
execute tt_act_rep_all_allcon @p01 = 80000709, @p02 = 'MIL'
A0100distribute :origin_time='Jun 13 10:20:416PM',:origin_user='',
:mode=1
delete from empl_tb where id=340123
A0100distribute :origin_user='',:mode=1
exec "TT"."so_req_rep_all_allcon" @"p01"=80000709,@"p02"='MIL'
execute tt_act_rep_all_allcon @p01 = 80000709, @p02 = 'MIL'
A0100distribute :origin_user='',:mode=1
exec "TT"."so_req_rep_all_allcon" @"p01"=80000709,@"p02"='MIL'
execute tt_act_rep_all_allcon @p01 = 80000709, @p02 = 'MIL'
A0100distribute :origin_time='Jun 13 10:20:416PM',:origin_user='',
:mode=1
delete from empl_tb where id=340393
A0100distribute :origin_user='',:mode=1
exec "TT"."so_req_rep_all_allcon" @"p01"=80000709,@"p02"='MIL'
execute tt_act_rep_all_allcon @p01 = 80000709, @p02 = 'MIL'
A0100distribute :origin_time='Jun 13 10:20:416PM',:origin_user='',
:mode=1
delete from empl_tb where id=340487
A0100distribute :origin_user='',:mode=1
commit transaction
execute rs_update_lastcommit @origin = 107,@origin_qid =0x00000001004620
d300019296000effffffff000000008910009bd7cd0001000000000001,
@ secondary_qid =0x000000000000000000000000000000000000000000000000000
000000000000000000000, @origin_time = 'Jun 13 10:20:227PM'
commit transaction
(return status = 0)