APPLIES TO:
Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.
SYMPTOMS
Extract does not captured key cols for an update after re-adding(delete/add) the trandata:
Logdump 14 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x0c)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 46 (x002e) IO Time : 2023/04/13 17:00:39.000.000
IOType : 134 (x86) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 13 AuditPos : 1566736
Continued : N (x00) RecCount : 1 (x01)
2023/04/13 17:00:39.000.000 GGSUnifiedUpdate Len 46 RBA 1979
Name: <Schema.Table> (TDR Index: 1)
After Image: Partition x0c G
s
1500 0000 0100 0500 0000 0100 3402 0008 0000 0004 | ............4.......
0052 6176 6901 0005 0000 0001 0035 0200 0800 0000 | .<Name>........5......
0400 5261 7669 | ..<Name>
Before Image Len 25 (x00000019)
BeforeColumnLen 21 (x00000015) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Primary key col 0 ID is missing/not captured
Column 1 (x0001), Len 5 (x0005)
0000 0100 34 | ....4
Column 2 (x0002), Len 8 (x0008)
0000 0400 5261 7669 | ....<Name>
After Image Len 21 (x00000015) >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Primary key col 0 ID is missing/not captured
Column 1 (x0001), Len 5 (x0005)
0000 0100 35 | ....5
Column 2 (x0002), Len 8 (x0008)
0000 0400 5261 7669 | ....<Name>
GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4153 4c5a 4141 4841 4141 414e 7341 4142 0001 | AAASLZAAHAAAANsAAB..
TokenID x74 't' ORATAG Info x01 Length 0
TokenID x4c 'L' LOGCSN Info x00 Length 7
3232 3532 3130 36 | 2252106
TokenID x36 '6' TRANID Info x00 Length 11
302e 352e 3236 2e31 3035 32 | 0.5.26.1052
TokenID x69 'i' ORATHREADID Info x01 Length 2
0001 | ..
Hence replicat is abended with below missing key col errors:
Key column ID (0) is missing from update on table <Schema.Table>
Missing 1 key columns in update for table <Schema.Table>.
Current time: 2023-04-13 17:00:46
Discarded record from action ABEND on error 0
CHANGES
Re-added the trandata.
CAUSE
This issue is identified in <Bug 35289372Bug 35289372Bug 35289372Bug 35289372> and this bug is closed as duplicate of Bug 30372831.
SOLUTION
As a workaround re-add trandata using below steps:
delete trandata <schema.table>
ALTER TABLE <schema.table> ENABLE LOGICAL REPLICATION;
add trandata <schema.table>
OR
Apply OGG BP, where Bug 30372831 fix is included.
If patch is not available for your platform, then reach out to oracle support.
