topic From Salesforce to BigQuery - java.lang.NoSuchMethodError in Talend Studio

From Salesforce to BigQuery - java.lang.NoSuchMethodError

Anonymous — Sat, 16 Nov 2024 02:09:05 GMT

Hi,

I am trying to retrieve data from Salesforce and then write it in a table in BigQuery, but I am getting the following error:

Exception in thread "main" java.lang.NoSuchMethodError: 'java.util.concurrent.Executor com.google.common.util.concurrent.MoreExecutors.directExecutor()' at com.google.api.gax.retrying.BasicRetryingFuture.<init>(BasicRetryingFuture.java:77) at com.google.api.gax.retrying.DirectRetryingExecutor.createFuture(DirectRetryingExecutor.java:73) at com.google.cloud.RetryHelper.run(RetryHelper.java:73) at com.google.cloud.RetryHelper.runWithRetries(RetryHelper.java:51) at com.google.cloud.bigquery.BigQueryImpl.getTable(BigQueryImpl.java:408) at bau_sf2bq.bigqueryingest_bau_0_1.BigQueryIngest_Bau.tFileInputExcel_2Process(BigQueryIngest_Bau.java:1588) at bau_sf2bq.bigqueryingest_bau_0_1.BigQueryIngest_Bau.runJobInTOS(BigQueryIngest_Bau.java:2290) at bau_sf2bq.bigqueryingest_bau_0_1.BigQueryIngest_Bau.main(BigQueryIngest_Bau.java:2139)

It seems like the error comes only if Salesforce and BigQuery components are used in a same job.

I actually tried something simple: I used a tFileInputExcel to push the data into a table in BigQuery and it works. But as soon as I added the salesforce connection component (tSalesforce_Connection), then I get that error.

Re: From Salesforce to BigQuery - java.lang.NoSuchMethodError

Taochok — Thu, 15 Apr 2021 12:45:19 GMT

I have the same issue.

And splitting the jobs didn't work either.

I tried making 3 different jobs

job1 is the orchestor

job2 connects to SF and download data

job3 connects to Google and upload data to BQ.

So, main job (job1) calls job2, that downloads localy the data.

then onSubJobOk job1 calls job3, the one that uploads the local data to BigQuery.

I got the same error. No success.

My solution is becoming to have 2 jobs and call them completely asynchronously... 😞

this didn't work for me either:

Re: From Salesforce to BigQuery - java.lang.NoSuchMethodError

SSchneeberger — Thu, 08 Sep 2022 14:09:23 GMT

Same here. Error only occurs, if tSalesforceInput and tBigqueryOutput are used in the same job and authentication method in tbigqueryOutput is set to service account. Did anyone find a solution to this? Is there a statement from talend why this happens?

Talend Open Studio V7.3.1

Re: From Salesforce to BigQuery - java.lang.NoSuchMethodError

Taochok — Thu, 08 Sep 2022 14:29:38 GMT

I ended up creating 2 different jobs and call them completely asynchronously.

Re: From Salesforce to BigQuery - java.lang.NoSuchMethodError

SSchneeberger — Thu, 08 Sep 2022 14:58:35 GMT

Hi Taochok, thanks a lot for your quick answer. I will consider this as a fallback solution. I still think this is a bug in talend and I will try the same with version 8.

Re: From Salesforce to BigQuery - java.lang.NoSuchMethodError

SSchneeberger — Tue, 20 Sep 2022 13:18:05 GMT

Quick update for others: with the version 8 this error seems to be solved. I could succesfully build and run the jobs that previously caused the error.