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