Integrated Extract Abends with "OGG-02078 Extract encountered a fatal error in a processing thread and is abending" when Capturing Wide Table

(Doc ID 2384181.1)

Last updated on APRIL 27, 2018

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate 12.3.0.1.0 Integrated extract with source Oracle Database 12c abends with:

ERROR OGG-02078 Extract encountered a fatal error in a processing thread and is abending.

when capturing a change to a wide table with OLTP or EHCC compression.  A wide table has a width of 128/256/512/1000; for example, table with more than 255 columns.

 

Integrated Extract's associated capture process may not report any errors, with alert log entries like:

LOGMINER: session#=4 (OGG$CAP_ETEST), builder MS04 pid=468 OS id=44759 sid=3880 stopped
LOGMINER: session#=4 (OGG$CAP_ETEST), preparer MS05 pid=470 OS id=44763 sid=3993 stopped
LOGMINER: session#=4 (OGG$CAP_ETEST), preparer MS06 pid=469 OS id=44761 sid=3938 stopped
LOGMINER: session#=4 (OGG$CAP_ETEST), reader MS07 pid=467 OS id=44756 sid=3821 stopped
OGG Capture client successfully detached from GoldenGate Capture OGG$CAP_ETEST (OS pid=44717).

 

Refer to the following for information regarding OLTP and EHCC compression:

Master Note for OLTP Compression (Doc ID 1223705.1)
Exadata Hybrid Columnar Compression (EHCC) FAQ (Doc ID 1910687.1)

 

To check if wide tables are enabled for OLTP compression, execute the following:

select a.ksppinm "Parameter",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"
from x$ksppi a, x$ksppcv b, x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and a.ksppinm like '%_widetab_comp_enabled%';

Changes

Upgrade to, or new installation of, Oracle GoldenGate 12.3 with source Oracle Database 12c. 

For earlier versions, refer to:

Extract limitations for OLTP compressed tables – Chained Rows (Doc ID 2210290.1)

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