Initial Load Replicat Abends With Error : ODBC error: SQLSTATE 57017 Character Conversion Between CCSID 1208 And CCSID

(Doc ID 2307314.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.1 to 12.3 Beta [Release 12.1 to 12.3]
Information in this document applies to any platform.

Symptoms

Initial Data Load from Oracle to DB2 I Series / AS400. The initial load replicat task is
failing with below error :

ODBC error: SQLSTATE 57017 native database error -332. Character conversion between CCSID 1208 and CCSID 65535 not valid.

 

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