Forum Stats

  • 3,824,872 Users
  • 2,260,435 Discussions
  • 7,896,334 Comments

Discussions

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

User_3SC3G
User_3SC3G Member Posts: 2 Green Ribbon

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.

Comments

  • ORASCN
    ORASCN Member Posts: 1,872 Bronze Crown

    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