Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

What happened? The apply process is still stuck. The count of conflicts raised by 1 and apply is again waiting for manual resolution. Lets check the conflicts again:

 

Code Block
dbvrep> list conflict
Information for conflict 32010159942 (current conflict):
Table: REPOE.LOGON at transaction 000a.01f.000001df at SCN 653533
SQL text (with replaced bind values): update "REPOE"."LOGON"
set "LOGON_ID" = 100000000
where (1=1)
and "LOGON_ID" = 1000000
and "CUSTOMER_ID" = 496840
and "LOGON_DATE" = to_date('2006.03.31 04:18:40','yyyy.mm.dd hh24:mi:ss')
Error: Command affected 2 row(s).
Handled as: PAUSE
Conflict repeated 21 times.

...

Now we have to check whether our two rows got replicated: 

Code Block
REPOE@TTORCL_trg> select count(*) from repoe.logon where logon_id=1000000;
COUNT(*)
----------
0
REPOE@TTORCL_trg> select count(*) from repoe.logon where logon_id=100000000;
COUNT(*)
----------
2

...