Attempt to fix the Adaptive Server error by analyzing the transaction text in the exceptions log as follows:
Log in to the RSSD and display the transaction ID by executing the rs_helpexception stored procedure.
1> rs_helpexception 2> go
Summary of Logged Transactions on ‘westernRS’ Total # of Logged Transactions = 1 Xact ID Org Site Org User Org Date Dest Site # Recs/Xact ----------- --------------- -------- ----------- --------------- 107 mil01hprdss.eur eurian Jan 26 1996 westernDS.eur 3
For Detailed Information on a Logged Xact., type ‘rs_helpexception {Xact ID}’
(return status = 0)
Using the transaction ID displayed in the previous step, display the full transaction text by executing the rs_helpexception stored procedure with the v option. The v option includes the text of the transaction in the output.
1> rs_helpexception 107, v 2> go
You see this information:
Detailed Summary of Logged Transaction # 107 on ‘westernRS’ Origin Site Origin User Org. Commit Date #Cmds in Xact ------------------------------ --------------- ----------------- westernDS.westDB eurian Jan 26 1996 9:27 3
Dest. Site Dest. User Date Logged ------------------------------ --------------- ----------------- westernDS.westDB eurian Jan 29 1996 10:39
This transaction was logged by the ‘sysadmin log_first_tran’ command.
Rejected Records
textval ---------------------------------------------------------------- A0100distribute :origin_time=’Jan 26 1996 9:27:24:416AM’,:origin_user= ‘’,:mode=1 begin transaction ‘logexec’ for ‘eurian’/’******’ begin transaction A0100distribute :origin_user=’’,:mode=1 exec “TT”.”so_req_rep_all_allco n” @”p01”=80000709,@”p02”=’MIL’ execute tt_act_rep_all_allcon @p01 = 80000709, @p02 = ‘MIL’ A0100distribute :origin_time=’Jan 26 1996 9:27:24:416AM’,:origin_user= ‘’,:mode=1 commit transaction execute rs_update_lastcommit @origin = 107, @origin_qid = 0x 00000001004620d300019296000effffffff000000008910009bd7cd0001000000000001, @ secondary_qid = 0x00000000000000000000000000000000000000000000000000000000000000 0000000000, @origin_time = ‘Jan 26 1996 9:27:24:416AM’ commit transaction
(return status = 0)
This text corresponds to what is sent to the database (in this case, function strings have been applied).
Use this transaction information to manually apply the update to the replicate database.
After fixing the error in the database, resume the connection in the Replication Server.
> resume connection to westernDS.westDB
Delete the transaction from the exceptions log to keep the log small:
1> exec rs_delexception 107 2> go
