My Oracle Support Banner

GOLDENGATE EXTRACT CAPTURES NULL FOR AN AFTER(NOT BEFORE) IMAGE OF A KEY COLUMN IN PKUPDATE (Doc ID 1580618.1)

Last updated on JUNE 05, 2019

Applies to:

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

Symptoms

Extract captures a PKUpdate, and a key value is null in after image, but not in before image.
Following is an example, where column 0 is a key column.

_________________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 56 (x0038) IO Time : 2013/08/08 20:54:06.000.000
IOType : 115 (x73) OrigNode : 255 (xff)
TransInd : . (x01) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 541542 AuditPos : 39995660
Continued : N (x00) RecCount : 1 (x01)

2013/08/08 20:54:06.000.000 GGSPKUpdate Len 56 RBA 2483794
Name: <schema_name>.<table_name>
After Image: Partition 4 G m
001b 0000 0006 0000 4e54 4946 0001 000d 0000 0009 | ........NTIF........
3235 3435 3939 3934 3000 0000 06ff ff00 0000 0000 | 254599940...........
0100 0d00 0000 0932 3534 3539 3939 3430 | .......254599940
Before Image Len 29 (x0000001d)
KeyLen 27 (x0000001b)
KeyCol 0 (x0000), Len 6 (x0006)
0000 4e54 4946 | ..NTIF
KeyCol 1 (x0001), Len 13 (x000d)
0000 0009 3235 3435 3939 3934 30 | ....254599940
.
After Image Len 27 (x0000001b)
Column 0 (x0000), Len 6 (x0006)
ffff 0000 0000 | ...... <======= this should not be NULL.
Column 1 (x0001), Len 13 (x000d)
0000 0009 3235 3435 3939 3934 30 | ....254599940

-------------------------------------------------------------------------

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
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.