My Oracle Support Banner

How To Replace Bad Characters On Target Using OGG BigData Replicat (Doc ID 2076868.1)

Last updated on JUNE 05, 2019

Applies to:

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

Goal

When source trail has malformed input characters in the trail record which do not comply with the target character set it would cause errors like below in OGG BigData Replicat

2017-02-16 16:08:18 ERROR OGG-03533 Conversion from character set CESU-8 of source column SUBJECT to character set UTF-16 of target column SUBJECT failed because the source column contains a character 'f0' at offset 30 that is not available in the target character set.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.