Replicat Abends With Key Column <COL_NAME> (0) Is Missing From Update On Table <SCHEMA.TABLENAME> (Doc ID 2963276.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Replicat is abended with the below errors:

Oracle GoldenGate Delivery for Oracle process started, group <REP_NAME> discard file opened: 2023-03-13 12:55:15.109389
Key column XXXXX_ID (0) is missing from update on table <SCHEMA.TABLENAME>
Missing 1 key columns in update for table <SCHEMA.TABLENAME>.
Current time: 2023-03-13 12:55:24
Discarded record from action ABEND on error 0

Aborting transaction on <trail path> beginning at seqno 4 rba 390,790,486
                         error at seqno 4 rba 390790486
Problem replicating <SCHEMA.TABLENAME> to <SCHEMA.TABLENAME>.
Mapping problem with unified update record (target format) SCN:101.21.XXXXXXX...
*

Since Extract is unable to captured the Key cols for an update after deleting
trandata for a table and re-adding the trandata for a schema:

1. add trandata <schema.tablename>
2. delete trandata <schema.tablename>
3. add schematrandata <schemaname>

2023/05/31 03:57:16.000.000 GGSUnifiedUpdate     Len    41 RBA 2555
Name: <SCHEMA.TABLENAME>  (TDR Index: 1)
After  Image:                                             Partition x0c   G  
s
 1200 0000 0600 0500 0000 0100 3008 0005 0000 0001 | ............0.......
 0030 0600 0500 0000 0100 3608 0006 0000 0002 0036 | .0........6........6
 33                                                | 3
Before Image          Len    22 (x00000016)
BeforeColumnLen     18 (x00000012)
Column     6 (x0006), Len     5 (x0005)
 0000 0100 30                                      | ....0 >>>>>>>>>>>>>>>>Key cols 0 is not captured with before image
Column     8 (x0008), Len     5 (x0005)
 0000 0100 30                                      | ....0
 
After Image           Len    19 (x00000013)      >>>>>>>>>>>>>>>>Key cols 0 is not captured with after image
Column     6 (x0006), Len     5 (x0005)
 0000 0100 36                                      | ....6
Column     8 (x0008), Len     6 (x0006)
 0000 0200 3633                                    | ....63
 

Changes

Cause

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