GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REPLICAT - OGG-00875 Unexpected error looking for col n in lobmem

M81SilvaApr 10 2017 — edited May 8 2017

I'm using version:

Oracle GoldenGate Command Interpreter for Oracle

Version 12.2.0.1.160419 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160322.1529.2

Windows x64 (optimized), Oracle 12c on May 5 2016 05:12:01

Operating system character set identified as windows-1252.

I'm facing an issue with UDT columns when trying to get data Inserted into Target database

The columns are present in the trail file, but it gives the following error

2017-04-10 11:10:41 INFO OGG-06510 Using the following key columns for target table TABLE_A: ID

Source Context :

SourceModule : [ggapp.lobrow]

SourceID : [../gglib/ggapp/lobrow.c]

SourceFunction : [LOBROW_col_present_clob]

SourceLine : [964]

ThreadBacktrace : [23] elements

: [C:\app\...\product\12.1.2\oggcore_1\gglog.dll(??1CContextItem@@UEAA@XZ+0x2a76) [0x00007FFADA3BF056]]

: [C:\app\...\product\12.1.2\oggcore_1\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ+0x561) [0x00007FFADA3BF6A1]]

: [C:\app\...\product\12.1.2\oggcore_1\gglog.dll(?_MSG_ERR_DB_LOB_COLUMN_MISSING@@YAPEAVCMessage@@PEAVCSourceContext@@HW4MessageDisposition@CMessageFactory@@@Z+0x3c) [0x00007FFADA35990C]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0x105edc) [0x00007FF69316D59C]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x28eef) [0x00007FF6931E726F]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x29a5a) [0x00007FF6931E7DDA]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x2a415) [0x00007FF6931E8795]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x2ba38) [0x00007FF6931E9DB8]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x2e086) [0x00007FF6931EC406]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x25c06) [0x00007FF6931E3F86]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0xb28ff) [0x00007FF693119FBF]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0xafc88) [0x00007FF693117348]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0xb5fab) [0x00007FF69311D66B]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0x5a754) [0x00007FF6930C1E14]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0x4b871) [0x00007FF6930B2F31]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0xad167) [0x00007FF693114827]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x6c33) [0x00007FF6931C4FB3]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x5deb) [0x00007FF6931C416B]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(_ggTryDebugHook+0x6add) [0x00007FF6931C4E5D]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(ERCALLBACK+0xad20b) [0x00007FF6931148CB]]

: [C:\app\...\product\12.1.2\oggcore_1\replicat.exe(CommonLexerNewSSD+0x2de52) [0x00007FF6932DCFB2]]

: [C:\WINDOWS\System32\KERNEL32.DLL(BaseThreadInitThunk+0x14) [0x00007FFB21898364]]

: [C:\WINDOWS\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x00007FFB219A70D1]]

2017-04-10 11:10:41 ERROR OGG-00875 Unexpected error looking for col 7 in lobmem.

I have been searching on MOS, but the only reference I got is that the issue was fixed for OGG version 11. Linux platform

My problem is that I'm using

Version 12.2.0.1.160419 OGGCORE_12.2.0.1.0OGGBP_PLATFORMS_160322.1529.2

Windows x64

Which is the latest available version for Windows.

Did anyone have faced the same issue? Or can advise?

TIA

Mara

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2017

Added on Apr 10 2017

#goldengate

15 comments

740 views