My Oracle Support Banner

Replicat abend with ERROR OGG-03517- Conversion from character set UTF-8 of source column XML_DATA to character set UTF-16BE of target column XML_DATA failed (Doc ID 2122868.1)

Last updated on AUGUST 06, 2020

Applies to:

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

Symptoms

Replicat abend with

2016-03-27 18:47:09 ERROR OGG-03517 Oracle GoldenGate Delivery for Oracle, rep.prm:
Conversion from character set UTF-8 of source column XML_DATA to character set UTF-16BE of target column XML_DATA failed because the source column contains a character that is not available in the target character set.

It is observed that the characterset of source and target are the same.The issue is observed in 12.1.2.1.0 version


Replicat session NLS

Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"


Extract session NLS
Database Language and Character Set:
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"

*** Source ***

SQL> select parameter,value from v$nls_parameters where parameter like '%CHARACTERSET';

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16


** Dest ***

SQL> select parameter,value from v$nls_parameters where parameter like '%CHARACTERSET';

PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16

Cause

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
Symptoms
Cause
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.