Oracle Golden Gate Big Data Adapter is sending wrong data type to Kafka

User_3SC3G

Hi Team,

We have following scenario.

Source(Oracle 19c DB table)- Oracle Goldengate at source end.

Target(Kafka Topic) - Oracle GoldenGate for Big Data Adapter sends data to Kafka topic.

Oracle 19c DB ==>Oracle Goldengate ==>Oracle Goldengate for Big Data Adapter ==> Kafka Topic.

We have one column in source Oracle table with Data type(Number(6,0)).

At the target(Kafka Topic) end, sometimes Oracle GOLDENGATE Big Data Adapter sending the data type of this column as LONG to Kafka topic.

Has anyone experienced this behavior? And how to troubleshoot and fix this issue?

Your input is highly appreciated.

Thanks,

Chinna.

ORASCN

Hi Chinna,

How did you confirm that the datatype was LONG? Did you find anything in the Logdump output of that trail file?

The datatype shouldn't change. Could you please provide your parameter files so that I can test it out and update you.

Regards,

Veera