OGG-03003 Oracle GoldenGate Capture for DB2 : Target table ggc.tab1 has a lower case ASCII, non-ASCII or special character, such as white space or dot, that is incompatible with trail format level 2.

(Doc ID 1935686.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

The following error does appear when using OGG 11.1.x for DB2 as source and OGG 11.2.x for DB2 as target

 TABLE ggc.tab1;

Source Context :
 SourceModule            : [er.mapping]
 SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/app/er/mapping.cpp]
 SourceFunction          : [validateTargetName]
 SourceLine              : [297]
 ThreadBacktrace         : [8] elements
                         : [/home/ggc/GoldenGate/libgglog.so(CMessageContext::AddThreadContext()+0x26) [0x2b55a5daebf6]]
                         : [/home/ggc/GoldenGate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x366) [0x2b55a5da88e6]]
                         : [/home/ggc/GoldenGate/libgglog.so(_MSG_ERR_TABLE_INCOMPATIBLE_WITH_TRAIL_FORMAT_RELEASE(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, unsigned int, CMes
sageFactory::MessageDisposition)+0xb7) [0x2b55a5d9f0c7]]
                         : [/home/ggc/GoldenGate/extract(get_map_entry(ggs::gglib::ggunicode::UString const&, unsigned int, wc_def*, int)+0x25aa) [0x53d07a]]
                         : [/home/ggc/GoldenGate/extract(get_infile_params(time_elt_def*, time_elt_def*, char**)+0x1eb1) [0x52d091]]
                         : [/home/ggc/GoldenGate/extract(main+0x151) [0x561261]]
                         : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x31d141d994]]
                         : [/home/ggc/GoldenGate/extract(__gxx_personality_v0+0x2da) [0x497e6a]]

2014-10-14 10:38:18  ERROR   OGG-03003  Target table ggc.tab1 has a lower case ASCII, non-ASCII or special character, such as white space or dot, that is incompatible with trail format level 2.

2014-10-14 10:38:18  ERROR   OGG-01668  PROCESS ABENDING.

Changes

 n/a

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