My Oracle Support Banner

Extract Does Not Captured Key Cols For An Update After Re-Adding The Trandata So Replicat Abends With Missing Key Cols (Doc ID 2943793.1)

Last updated on JULY 17, 2023

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.