Integrated Extract Fails to Start Due to OGG-06219 on Multitenant Database
(Doc ID 2758000.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 12.3.0.1.4 and laterInformation in this document applies to any platform.
Symptoms
When starting Integrated Extract (IE), it may fail due to OGG-06219 on Multitenant Database (CDB).
WARNING OGG-01262 Oracle GoldenGate Capture for Oracle, CAPCKG.prm: The call to the cm_obj_find() function from line 1865 in CM_object_create() failed with reason 'cm_obj_find: object (e.g., trans) already exists: error: 115'.
INFO OGG-06509 Oracle GoldenGate Capture for Oracle, CAPCKG.prm: Using the following key columns for source table <PDB>.<SCHEMA>.<TABLE>: <COLUMN1>, <COLUMN2>, ...
INFO OGG-01054 Oracle GoldenGate Capture for Oracle, CAPCKG.prm: Recovery completed for target file <Trail File>, at RBA <RBA>, CSN <CSN>.
INFO OGG-01057 Oracle GoldenGate Capture for Oracle, CAPCKG.prm: Recovery completed for all targets.
ERROR OGG-06219 Oracle GoldenGate Capture for Oracle, CAPCKG.prm: Unable to extract data from the Logmining server OGG$<CAPTURE>.
INFO OGG-01026 Oracle GoldenGate Capture for Oracle, PMPCKG.prm: Rolling over remote file <Trail File>.
ERROR OGG-02078 Oracle GoldenGate Capture for Oracle, CAPCKG.prm: Extract encountered a fatal error in a processing thread and is abending.
ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, CAPCKG.prm: PROCESS ABENDING.
(example of messages in report file of Capture process)
WARNING OGG-01262 The call to the cm_obj_find() function from line 1865 in CM_object_create() failed with reason 'cm_obj_find: object (e.g., trans) already exists: error: 115'.
INFO OGG-06509 Using the following key columns for source table <PDB>.<SCHEMA>.<TABLE>: <COLUMN1>, <COLUMN2>, ...
INFO OGG-01054 Recovery completed for target file <Trail File>, at RBA <RBA>, CSN <CSN>.
INFO OGG-01057 Recovery completed for all targets.
Source Context :
SourceModule : [er.redo.oraxo]
SourceID : [er/redo/oracle/redooraix.c]
SourceMethod : [RedoIE::handleReadError]
SourceLine : [15880]
ThreadBacktrace : [11] elements
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [<GG_HOME>\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ)]
: [thread id 1 seqno 220 rba 304252708 scn 137854142 ts 212467096205000000]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [Checking messages (includes checkpointing)]
: [Checking messages (includes checkpointing)]
: [Checking messages (includes checkpointing)]
: [Checking messages (includes checkpointing)]
: [Checking messages (includes checkpointing)]
: [Checking messages (includes checkpointing)]
2020-09-18 10:09:50 ERROR OGG-06219 Unable to extract data from the Logmining server OGG$<CAPTURE>.
Source Context :
SourceModule : [er.redo.ora.IXFormatter]
SourceID : [er/redo/oracle/IXFormatter.cpp]
SourceMethod : [IXFormatter::getResult]
SourceLine : [748]
ThreadBacktrace : [16] elements
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [h:\ggs_kg\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ)]
: [h:\ggs_kg\gglog.dll(?_MSG_@@YAPEAVCMessage@@PEAVCSourceContext@@HW4MessageDisposition@CMessageFactory@@@Z)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [C:\Windows\System32\KERNEL32.DLL(BaseThreadInitThunk)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [h:\ggs_kg\extract.exe(ERCALLBACK)]
: [h:\ggs_kg\extract.exe(ERCALLBACK)]
: [h:\ggs_kg\extract.exe(ERCALLBACK)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [h:\ggs_kg\extract.exe(_ggTryDebugHook)]
: [h:\ggs_kg\extract.exe(ERCALLBACK)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
: [C:\Windows\System32\KERNEL32.DLL(BaseThreadInitThunk)]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
2020-09-18 10:09:50 ERROR OGG-02078 Extract encountered a fatal error in a processing thread and is abending.
Changes
This problem may happen on following configuration.
- Oracle Database is configured as Multitenant Database
- Extract is configured as Integrated Extract
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |