My Oracle Support Banner

Initial Load PostgreSQL Replicat abend - OGG-03534 Invalid character 'e9' at offset 3 - Multibyte character issue (Doc ID 2828090.1)

Last updated on FEBRUARY 09, 2022

Applies to:

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

Symptoms

When doing initial load from Ogg 21.3.x Postgresql to target Postgresql, the
replicat failed with

2021-09-21 13:59:34 ERROR OGG-03534 Invalid character 'e9' at offset 3
for character set UTF-8 was found while performing character validation of
source column ptnt_1st_name maps target column ptnt_1st_name.

The issue seems to be with the initial load extract. PostgreSQL extract is writing non
utf8 character ‘e9’ to the trail file and causing the target relicat to fail( it will fail in replicat for any target
database)
The value for the column <column name> = José

It is been captured by the extract as
Column 8 (x0008), Len 8 (x0008)
0000 0400 4a6f 73e9 | ....Jos.

The online extract / replicat works good with similar record ( insert/update)

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


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