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

Last updated on JULY 18, 2023

Applies to:

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

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