About GoldenGate Synchronization Error (OGG-01004) (Doc ID 2725380.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 12.2.0.2.2 version,

ACTUAL BEHAVIOR
---------------
About GoldenGate synchronization error (OGG-01004)

Environmental composition:
Source side
OS: NonStopServer
DB: NonStop SQL / MP
OGG-12.2.0.2
CharctorSet: shiftjis

Target side
OS: Linux
DB: PostgreSQL 11.3
OGG-12.2.0.2.181009
CharctorSet: UTF-8



Event:
When we registered the ShiftJIS code double-byte character data in the VARCHAR column of the table on the Source side and executed it synchronously with GoldenGate, an error occurred.

[Excerpt from ggserr.log]
2020-09-11 10:39:01 WARNING OGG-01004 Oracle GoldenGate Delivery, XXXX.prm: Aborted grouped transaction on'XXXX', Database error 3452617 ([SQL error 3452617 (0x34aec9)] [Oracle] [ODBC PostgreSQL Wire Protocol driver] [PostgreSQL] ERROR: VERROR; invalid byte sequence for encoding "UTF8": 0x82 (File wchar.c; Line 2017; Routine report_invalid_encoding;)
).
2020-09-11 10:39:01 WARNING OGG-01003 Oracle GoldenGate Delivery, reppgext.prm: Repositioning to rba 1334 in seqno 6.
2020-09-11 10:39:01 WARNING OGG-01154 Oracle GoldenGate Delivery, reppgext.prm: SQL error 3452617 mapping $XXXXX.YYYYYY.ZZZZZZ to AAAA.CCCCC [SQL error 3452617 (0x34aec9)] [Oracle] [ODBC PostgreSQL Wire Protocol driver] [PostgreSQL] ERROR: VERROR; invalid byte sequence for encoding "UTF8": 0x82 (File wchar.c; Line 2017; Routine report_invalid_encoding;).
2020-09-11 10:39:01 ERROR OGG-01296 Oracle GoldenGate Delivery, reppgext.prm: Error mapping from $ XXXXX.YYYYYY.ZZZZZZ  to AAAA.CCCCC
2020-09-11 10:39:01 ERROR OGG-01668 Oracle GoldenGate Delivery, reppgext.prm: PROCESS ABENDING.

Cause

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