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 laterInformation 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 |