DB2i Extract Abends With Error OGG-01145 (Doc ID 2193421.1)

Last updated on JANUARY 14, 2017

Applies to:

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

Goal

 DB2i extract would fail when column a Timestamp datatype column was added by ALTERing the table (step 8) in the fashion as mentioned below:

1) CREATE TABLE GGMAVU/GG_TESTCASE01
(
COLA NUMERIC(10),
COLB VARCHAR(30),
COLC TIMESTAMP
)

2) grant select,insert,update,delete on GGMAVU/GG_TESTCASE01 TO GGMAVU

3) ggsci
DBLOGIN SOURCEDB HLDD40 USERID GGMAVU, PASSWORD AACAAAAAAAAAAAIAOCTJZGGAFEUAEFLC ENCRYPTKEY Superkey
DEFAULTJOURNAL GGMAVU/OGGJRN
ADD TRANDATA GGMAVU.GG_TESTCASE01
ADD EXTRACT OD4E2_D9, TRANLOG, BEGIN NOW
add exttrail /oracle/MAVU/ggate/data/d9, extract OD4E2_D9, megabytes 50

4) start extract OD4E2_D9

STRSQL
5) insert into GGMAVU/GG_TESTCASE01 values (1, 'test', CURRENT TIMESTAMP)

6) ggsci
stats extract OD4E2_D9 (this shows 1 row extracted as expected)
stop extract OD4E2_D9

7) STRSQL
insert into GGMAVU/GG_TESTCASE01 values (2, 'test2', CURRENT TIMESTAMP)

8) ALTER TABLE GGMAVU/GG_TESTCASE01 ADD COL_D TIMESTAMP

9) insert into GGMAVU/GG_TESTCASE01 values (3, 'test3', CURRENT TIMESTAMP, CURRENT_TIMESTAMP)

10) Start the extract ==> It fails with below error
Source Context :
SourceModule : [ggvam.rec]
SourceID : [/QOpenSys/home/oggbuild/OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150320.0454/oggcore/OpenSys/src/gglib/ggvam/cvamrec.cpp]
SourceFunction : [com_goldengate_vam::CVamRec::mapToInternal(const file_def *, CVamCol *, char **)]
SourceLine : [4088]

2016-08-06 19:04:23 ERROR OGG-01145 programming error, binary length mismatch converting QEW8CD (192).

Solution

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