Forum Stats

  • 3,826,253 Users
  • 2,260,615 Discussions
  • 7,896,851 Comments

Discussions

GG replication Oracle to Kudu

Robeen
Robeen Member Posts: 2,179 Silver Badge

Oracle DB 12.1.0.2

OGG 18.1.0

Hello Team,

can you please advise why replication fails during Striim replication from GG trail (Oracle) to Kudu.

2751 : Inconsistent source & target table strcture Target {impala::common.cb_receipts} has less number of column as compared to source {CBS_CORE.CB_RECEIPTS}.No of columns in target {26} but expected {46}

Issue is a bot similar to this one: https://www.rittmanmead.com/blog/2016/09/using-logdump-to-debug-oracle-goldengate-and-kafka/

Workaround:

I added the parameter EXCLUDEHIDDENCOLUMNS in the extract and I see the hidden fields(SYS) have disappeared in the logdump.

Replication still fails with above error.

logdump entry:

Logdump 327 >open /ogg/ora12c/dirdat/cd000006070
Current LogTrail is /ogg/ora12c/dirdat/cd000006070
Logdump 328 >filter inc filename CBS_CORE.CB_RECEIPTS
Logdump 329 >pos 0
Reading forward from RBA 0
Logdump 330 >ghdr on
Logdump 331 >detail data on
Logdump 332 >n
Scanned     10000 records, RBA    8050614, 2020/10/24 06:51:56.000.098
Scanned     20000 records, RBA   17186196, 2020/10/24 06:53:44.000.225
___________________________________________________________________
Hdr-Ind    :     E  (x45)     Partition  :     .  (x00)
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)
RecLength  :  2268  (x08dc)   IO Time    : 2020/10/23 21:55:58.838.734
IOType     :   170  (xaa)     OrigNode   :     2  (x02)
TransInd   :     .  (x01)     FormatType :     R  (x52)
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00)
DDR/TDR Idx:   (001, 016)     AuditPos   : 5242696
Continued  :     N  (x00)     RecCount   :     1  (x01)

2020/10/23 21:55:58.838.734 Metadata             Len 2268 RBA 18770757
Name: CBS_CORE.CB_RECEIPTS
*
 1)Name          2)Data Type        3)External Length  4)Fetch Offset      5)Sca                                                                                                             le         6)Level
 7)Null          8)Bump if Odd      9)Internal Length 10)Binary Length    11)Tab                                                                                                             le Length 12)Most Sig DT
13)Least Sig DT 14)High Precision  15)Low Precision   16)Elementary Item  17)Occ                                                                                                             urs       18)Key Column
19)Sub DataType 20)Native DataType 21)Character Set   22)Character Length 23)LOB                                                                                                              Type     24)Partial Type
*
TDR version: 11
Definition for table CBS_CORE.CB_RECEIPTS
Record Length: 642
Columns: 26
TRANS_NUM_V               64     20        0  0  0 1 0     20     20      0 0 0                                                                                                              0 0 1    0 1   0    1       -1      0 0 0
TRANS_DATE_D             192     36       26  0  0 1 0     36     36     36 0 8                                                                                                              0 0 1    0 0   0  188       -1      0 0 0
TRANS_OPTN_V              64      1       66  0  0 1 0      1      1      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
TRANS_REF_NO_V            64     20       72  0  0 1 0     20     20      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
LOCATION_CODE_V           64     10       98  0  0 1 0     10     10      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
CASH_BOX_NUMBER_N        134     11      114  0  0 1 0      8      8      8 0 0                                                                                                              0 0 1    0 0   3    2       -1      0 0 0
SALES_REGION_N            64     50      126  0  0 1 0     50     50     50 0 0                                                                                                              0 0 1    0 0   2    2       -1      0 0 0
PAY_MODE_OPTN_V           64      2      182  0  0 1 0      2      2      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
ENTITY_TYPE_V             64      3      190  0  0 1 0      3      3      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
ACCOUNT_LINK_CODE_N      134     11      198  0  0 1 0      8      8      8 0 0                                                                                                              0 0 1    0 0   3    2       -1      0 0 0
SAP_SUB_AC_CODE_N        134     11      210  0  0 1 0      8      8      8 0 0                                                                                                              0 0 1    0 0   3    2       -1      0 0 0
TRANS_AMT_N              134     15      222  0  0 1 0      8      8      8 0 0                                                                                                              0 0 1    0 0   3    2       -1      0 0 0
DESCRIPTION_V             64    120      234  0  0 1 0    120    120      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
USER_CODE_N              134     11      360  0  0 1 0      8      8      8 0 0                                                                                                              0 0 1    0 0   3    2       -1      0 0 0
POSTED_TO_ACCOUNTS_N     134      8      372  0  0 1 0      8      8      8 0 0                                                                                                              0 0 1    0 0   3    2       -1      0 0 0
POSTED_TRANS_NUM_V        64     20      384  0  0 1 0     20     20      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
UPLOADED_DATE_D          192     36      410  0  0 1 0     36     36     36 0 8                                                                                                              0 0 1    0 0   0  188       -1      0 0 0
DISPLAY_REF_NO_V          64     20      450  0  0 1 0     20     20      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
CASH_BOX_COLL_TYPE_V      64      5      476  0  0 1 0      5      5      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
SALES_LINK_FLAG_V         64      1      486  0  0 1 0      1      1      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
SOURCE_CODE_V             64     31      492  0  0 1 0     31     31      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
ERLY_PYMT_TRANS_NUM_V     64     20      528  0  0 1 0     20     20      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
PREPAID_POSTPAID_FLAG_V   64      1      554  0  0 1 0      1      1      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
RECHARGE_TYPE_V           64      1      560  0  0 1 0      1      1      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
LAST_MODIFIED_DATE_D     192     36      566  0  0 1 0     36     36     36 0 8                                                                                                              0 0 1    0 0   0  188       -1      0 0 0
EXTERNAL_REFERENCE_V      64     30      606  0  0 1 0     30     30      0 0 0                                                                                                              0 0 1    0 0   0    1       -1      0 0 0
End of definition

Kindly advise.


Regards,


Joe

Best Answer

Answers

  • Robeen
    Robeen Member Posts: 2,179 Silver Badge

    Thanks for the update. After restarting the extract, error was being shown again. There was a metadata cache in Striim. I had to update it and it was ok.

  • Robeen
    Robeen Member Posts: 2,179 Silver Badge