EXTRACT CAPTURES NULL WRONGLY FOR COLUMNS WITH DEFAULT VALUE 0 FROM SOURCE ORACLE 11.1.0.3+ RDBMS. (Doc ID 1416718.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

Extract got null value for a column that is not null, and source DB is oracle 11.1.

Example:

CREATE TABLE CRAMER.EXT_LINK_FIBER
(
LINKID NUMBER,
ISVISIBLE NUMBER DEFAULT 1,
LABEL NUMBER DEFAULT 0,
RPPLANID NUMBER DEFAULT 0 NOT NULL,
SUPPLEMENTAL LOG GROUP GGS_EXT_LINK_FIBER_239608 (LINKID,RPPLANID) ALWAYS
);

___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: B (x42)
RecLength : 22 (x0016) IO Time : 2011/12/14 15:22:20.000.000
IOType : 3 (x03) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 37145 AuditPos : 81351432
Continued : N (x00) RecCount : 1 (x01)
.
2011/12/14 15:22:20.000.000 Delete Len 22 RBA 7643
Name: FZHANG.EXT_LINK_FIBER
Before Image: Partition 4 G s
0000 000a 0000 0006 3135 3036 3434 0003 0004 ffff | ........150644......
0000 | ..
Column 0 (x0000), Len 10 (x000a)
0000 0006 3135 3036 3434 | ....150644
Column 3 (x0003), Len 4 (x0004) <=================== this is NULL
ffff 0000

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