Replicating From UTF-8 To Hbase Is Running Into Character Set Conversion Issue (Doc ID 2108670.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Application Adapters - Version 12.1.2.1.6 and later
Information in this document applies to any platform.

Symptoms

 OGG Big Data Adapter for HBase:

***********************************************************************
Oracle GoldenGate Delivery
Version 12.2.0.1.0 OGGCORE_12.2.0.1.0_PLATFORMS_151101.1925.2
Linux, x64, 64bit (optimized), Generic on Nov 10 2015 18:00:28

***********************************************************************
Oracle GoldenGate Java Adapter, 12.2.0.1.0.012
Copyright (c) 2007,2015. Oracle and/or its affiliates. All rights reserved
Built with Java 1.7.0_79 (class version: 51.0)
***********************************************************************

is abending with:

2016-02-18 18:22:51 INFO OGG-03010 Performing implicit conversion of column data from character set UTF-8 to US-ASCII.
Feb 18, 2016 6:22:51 PM oracle.goldengate.datasource.UserExitDataSource newTableMetaData
INFO: timesyncLock hold count= 1
Feb 18, 2016 6:22:51 PM oracle.goldengate.datasource.AbstractDataSource pruneTxBuffer
WARNING: Not pruning operations from tx after processing, buffering all operations. Not all handlers are in 'operation mode'.

2016-02-18 18:22:56 ERROR OGG-03517 Conversion from character set UTF-8 of source column DUPLICATE_KEY1 to character set US-ASCII of target column DUPLICATE_KEY1 failed because the source column contains a character that is not available in the target character set.

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