invalid byte sequence for encoding "UTF8": 0x00
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