GoldenGate for Big Data-kafka handler replicating data from Postgres with junk characters for boolean values (Doc ID 3074779.1)

Last updated on MARCH 06, 2025

Applies to:

Symptoms

We have a Golden Gate for Big data streaming changes to Kafka with Kafka handler, it gets the data from Postgres database, and we see that kafka messages for a column which is of boolean data type is showing junk characters

Table has a column manually_prepared which boolean data type and in source postgres database it has. "True" or "False" as values
When we see the kafka messages we see the below
{"table":"pg.xxxxxx","op_type":"U","op_ts":"2025-01-29 20:39:32.068731","current_ts":"2025-01-29 20:39:33.126000","pos":"00000000000030991040","csn":"00000000/133A5EA0","xid":"45610986","txind":"W","opseqno":"1","before":{"tax_jurisdiction_id":"c25efafe-05c0-4d57-a8ad-c30fe43b7394",manually_prepared":"AQ=="},"after":{"tax_jurisdiction_id":"c25efafe-05c0-4d57-a8ad-c30fe43b7394","manually_prepared":"AQ=="}}

If you see manually_prepared has junk characters "AQ==" instead of boolean value.

Changes

Cause

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