A
A
Alexey Sumin2015-12-11 16:43:24
Oracle
Alexey Sumin, 2015-12-11 16:43:24

Replication from Oracle to PostgreSQL via GoldenGate fails with invalid byte sequence for UTF8 error, how to overcome?

Hello colleagues. We did live up to attempts to organize replication from Oracle to Postgresql (for subsequent migration) and immediately received a fatal error.
When trying to upload data, the process crashes with the following error:

[Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: invalid byte sequence for encoding "UTF8":0xc3
[Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]Failed transaction. The current transaction rolled back.
[Oracle][ODBC PostgreSQL Wire Protocol driver]String data, right truncated. Error in parameter 2.
Mapping problem with insert record (target format)...
*
id = 8
000000: 38 |8 |

title = landscape photography
000000: d0 bf d0 b5 d0 b9 d0 b7 d0 b0 d0 b6 d0 bd d0 b0 |................|
000010: d1 8f 20 d1 81 d1 8a d0 b5 d0 bc d0 ba d0 b0 |.. ............ |

Swears supposedly invalid UTF8 characters, but both Oracle and Postgresql databases are created in UTF8 encoding.
At the same time, through the ORA2PG package, the data is copied remarkably and in the correct encoding (this is a one-time option, but a permanent replica is needed).
Has anyone encountered such a problem?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
poxid, 2015-12-23
@poxid

Replica settings, version, odbc.ini?
IANAAppCodePage=106?
Did you read notes?
How To Replicate Data from Oracle to Postgres Using GoldenGate (Doc ID 1544137.1)
Character Conversion Issue When Replicating Data From Unicode Oracle To Unicode PostgreSQL (Doc ID 1543702.1
) .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question