Question

Denodo JDBC Multi table origin offset issue

  • 11 March 2022
  • 1 reply
  • 124 views
poulose
Rank

Hi,

I am using a multi table JDBC Origin to connect to Denodo and extract data. The pipeline is running fine but hangs after 5-10 minutes. Getting the below error for offset column I am using.

Please let me know if I have to change any settings. The same works perfectly fine when I am using a single table JDBC consumer.

Pipeline Status: RUNNING_ERROR: JDBC_75 - Jdbc Runner Failed. Reason java.util.concurrent.ExecutionException: com.google.common.util.concurrent.UncheckedExecutionException: java.lang.NumberFormatException: For input string: "2020-04-05 19:18:11.0"

1 reply

Bikram
Rank
Userlevel 5
Badge +1

@poulose ,

From the above error i noticed the issue is because of data format. 

Kindly let me know if you are using the date field as offset value.

If you can use test pipeline then i can have a look into it and help on the same.

 

Thanks & Regards,

Bikram_ 

Reply


Terms & Conditions