How To Use CHARMAP To Get Around Error -6706 The String Contains An Untranslatable Character in TeraData ?

(Doc ID 2276509.1)

Last updated on NOVEMBER 07, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 to 12.2.0.1.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Replicating from Oracle to Teradata using an intermediary server.
2015-05-06 08:23:38 WARNING OGG-01154 SQL error -6706 mapping YANTRA_ADMIN.YFS_PERSON_INFO to PRD_USD_OPT.SOMS_YFS_PERSON_INFO_T [SQL error -6706 (0xffffe5ce)][Teradata][ODBC Teradata Driver][Teradata Database] The string contains an untranslatable character.

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