Replicating From DB2 to Teradata Using BINTOHEX in a Replicat Map Statement Gives Error OGG-01004 Database error -6706 - Untranslatable Character (Doc ID 1645766.1)

Last updated on JANUARY 09, 2017

Applies to:

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

Symptoms

Replicating from IBM DB2 to Teradata and using BINTOHEX in the replicat MAP statement causes the error -

2014-02-06 11:01:31 WARNING OGG-01004 Aborted grouped transaction on 'PRELOAD_T.EG_BOECACVPMITE_0', Database error -6706 ([SQL error -6706 (0xffffe5ce)][Teradata][ODBC Teradata Driver][Teradata Database] The string contains an untranslatable character.Unable to get catalog string.

 and -

 

2014-02-06 11:01:31  WARNING OGG-01154  SQL error -6706 mapping GGADM.BOECACVPMITE to PRELOAD_T.EG_BOECACVPMITE_0 [SQL error -6706 (0xffffe5ce)][Teradata][ODBC Teradata Driver][Teradata Database] The string contains an untranslatable character.Unable to get catalog string.

2014-02-06 11:01:31  WARNING OGG-01003  Repositioning to rba 2338 in seqno 1.

Source Context :
 SourceModule            : [er.errors]
 SourceID                : [/scratch/mmar/view_storage/mmar_17377487/oggcore/OpenSys/src/app/er/errors.cpp]
 SourceFunction          : [take_rep_err_action]
 SourceLine              : [632]
 ThreadBacktrace         : [8] elements
                         : [/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x30) [0x2b6db2da76d0]]
                         : [/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2dc) [0x2b6db2d9a34c]]
                         : [/ogg/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, CMessageFactory::MessageDisposition)+0xcc) [0x2b6db2d69d7c]]
                         : [/ogg/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, bool)+0x122f) [0x5178ef]]
                         : [/ogg/replicat(process_extract_loop()+0x1942) [0x535332]]
                         : [/ogg/replicat(main+0x9ef) [0x55022f]]
                         : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x384e41d994]]
                         : [/ogg/replicat [0x498faa]]

2014-02-06 11:01:31  ERROR   OGG-01296  Error mapping from GGADM.BOECACVPMITE to PRELOAD_T.EG_BOECACVPMITE_0.

  The MAP statement may have something similar to -

OID_HEX = @BINTOHEX(OID)

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