My Oracle Support Banner

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 MAY 22, 2023

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, <replicat name>.prm: SQL error 3452617 mapping SCHEMA.TABLE to SCHEMA.TARGET [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,<replicat name>.prm: Error mapping from SCHEMA.TABLE to SCHEMA.TARGET.
2018-01-02 05:44:58 ERROR OGG-01668 Oracle GoldenGate Delivery, <replicat name>.prm: PROCESS ABENDING.

Changes

 

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
Changes
Cause
Solution


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