OGG Replicat for PostgreSQL Fails With "SQL error 3452617 ERROR: VERROR; invalid byte sequence for encoding "UTF8": 0x00"

(Doc ID 2351708.1)

Last updated on FEBRUARY 19, 2018

Applies to:

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

Symptoms

Oracle GoldenGate Delivery
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
Linux, x64, 64bit (optimized), PostgreSQL on Dec 11 2015 18:11:59


2018-01-02 05:44:58 WARNING OGG-01154 Oracle GoldenGate Delivery, rgama93.prm: SQL error 3452617 mapping BOOKER.DIST_INVOICE_ITEMS to booker.dist_invoice_items [SQL error 3452617 (0x34aec9)][Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: VERROR; invalid byte sequence for encoding "UTF8": 0x00(File wchar.c; Line 2017; Routine report_invalid_encoding; )[Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]Failed transaction. The current transaction rolled back.
2018-01-02 05:44:58 ERROR OGG-01296 Oracle GoldenGate Delivery, rgama93.prm: Error mapping from BOOKER.DIST_INVOICE_ITEMS to booker.dist_invoice_items.
2018-01-02 05:44:58 ERROR OGG-01668 Oracle GoldenGate Delivery, rgama93.prm: PROCESS ABENDING.

Changes

 

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