GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

invalid byte sequence for encoding "UTF8": 0x00

edited May 17, 2022 3:09PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentQuestion

Hi ,

We are migrating DB2 LUW DB to Postgres using GG.

Our initial replicate is abending with below error. Is there a way we can discard all such records that has invalid byte sequence to a file and continue processing of rest of the data?


2022-05-17T03:03:52.984-0700 WARNING OGG-00869 Oracle GoldenGate Delivery for PostgreSQL: Canceling BATCHSQL transaction. Database error 3452617 ([Oracle][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: VERROR; invalid byte sequence for encoding "UTF8": 0x00(File mbutils.c; Line 1597; Routine report_invalid_encoding; )).

Please advise.

Thanks,

Bina

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center