Classic extract does not capture a Key column for an update record

(Doc ID 2131147.1)

Last updated on NOVEMBER 01, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.31 and later
Information in this document applies to any platform.

Symptoms

We have a table with many columns, and 5 of them are key columns that are in supplemental log.
but one of them (#1 in trail record) is missing in an update record:

example:
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 7811 (x1e83) IO Time : 2016/03/08 08:14:24.000.000
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 41760 AuditPos : 2161960588
Continued : N (x00) RecCount : 1 (x01)

2016/03/08 08:14:24.000.000 FieldComp Len 7811 RBA 5749641
------->>> This is the problematic record.
Name: LSPAPPO.TRB1_SUB_ERRS
After Image: Partition 4 G m
0000 000a 0000 0000 0000 0000 0bbf 0002 0015 0000 | ....................
3230 3136 2d30 332d 3037 3a30 323a 3435 3a34 3200 | 2016-03-07:02:45:42.
0300 1500 0032 3031 362d 3033 2d30 373a 3230 3a34 | .....2016-03-07:20:4
343a 3233 0004 000a 0000 0000 0000 0000 0bbf 0005 | 4:23................
0008 0000 434d 5431 2020 0006 0007 0000 544a 4130 | ....CMT1 ......TJA0
3100 0700 0a00 0000 0000 0000 0000 0000 0800 0a00 | 1...................
0000 0000 0000 0007 d300 0900 0a00 0000 0000 00dc | ....................
Column 0 (x0000), Len 10 (x000a)
0000 0000 0000 0000 0bbf | ..........
Column 2 (x0002), Len 21 (x0015) --------->>>>> Column 1 does not appear.
0000 3230 3136 2d30 332d 3037 3a30 323a 3435 3a34 | ..2016-03-07:02:45:4
32 | 2
Column 3 (x0003), Len 21 (x0015)
0000 3230 3136 2d30 332d 3037 3a32 303a 3434 3a32 | ..2016-03-07:20:44:2

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms