DB2 Iseries Direct Load Replicat Abends With SQL Error -7008

(Doc ID 1910099.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

DB2 iSeries replicat abends with:

2014-07-15 17:30:37 WARNING OGG-01004 Aborted grouped transaction on 'table', Database error -7008 ([SQL error -7008 (0xffffe4a0)] 'table'in 'database' not valid for operation.).

Source Context :
SourceModule : [er.errors]
SourceID : [/QOpenSys/home/oggbuild/OGGCORE_12.1.2.0.T2_PLATFOR
MS_140118.2244/oggcore/OpenSys/src/app/er/errors.cpp]
SourceFunction : [take_rep_err_action(short, int32_t, const char *, e
xtr_ptr_def *, std_rec_hdr_def *, char *, file_def *, bool)]
SourceLine : [547]

2014-07-15 17:30:37 ERROR OGG-01200 There is no trail to reposition to when doing direct load task.

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