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 JULY 18, 2023

Applies to:

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:

 Priimary 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.