golden gate index issue

Posted by Roshan on Jun 04, 2021; 7:23am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/golden-gate-index-issue-tp9842.html

Oracle Golden Gate 18c
Oracle DB 12.1.0.2
Solaris 11

Hello Erman,

the lag checkpoint for replication is increasing and RBA is not moving.

I enabled trace and the following output was captured.

trace file:
old obj name = CB_INVOICE
nullflags_knglxr is 0Xe1
 Bind variable count 0
knalfGenRowHashValues: ERR.: 26688
Missing key in lcr
Table: "CBSOGG"."CB_INVOICE", Index# 1253950, Columns: ("ACCOUNT_LINK_CODE_N", "TRANS_NUM_V") is missing: "ACCOUNT_LINK_CODE_N"
Dumping lcr:
Dumping lcr a04775a40 : type 3
 Dumping external row LCR
 (xid,scn,instnum,scnseq,flags,time,compat,compat_num)
=( 0x002a.02b.0008239c,0x0000.00000000,844,0,0x801, 06/04/2021 10:12:59,9.2.0.0.0,0)
header null flags = 0Xfdfc
  gdbnm=a047758e8, NULL
 tag is null
 uba is null
 tde key id=0
 Message tracking: null
 Header extra: nullflags=0xfc
   nos_xid=a04775378, 42.43.533404
   pos=a04775960, length=12, isnull=N, 333237323036383635343130
   flags=0
   execusr=0
    logon_user (null)
   rba (null)

I deleted all indexes with ACCOUNT_LINK_CODE_N but still replication hangs.

target table DDL is shown below
cbinvoice.txt

If I disable all contraints on target table replication will not start becausing structure of source and target will be different.
Kindly advise why dropping index is not working?

Thanks,

Roshan