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 APRIL 17, 2023

Applies to:

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


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


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

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