topic Re: Error when attempting to log catcher components to BigQuery AND upload a file into Google Cloud Storage in the same job in Talend Studio

Error when attempting to log catcher components to BigQuery AND upload a file into Google Cloud Storage in the same job

Anonymous — Sat, 16 Nov 2024 02:56:07 GMT

Starting job consumer at 22:56 19/03/2020.
[statistics] connecting to socket on port 3845
[statistics] connected
Job Started.
Job running with context = 'development'
Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.util.concurrent.MoreExecutors.directExecutor()Ljava/util/concurrent/Executor;
	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.create(BigQueryImpl.java:212)
	at com.google.cloud.bigquery.BigQueryImpl.create(BigQueryImpl.java:187)
	at project.job_version.job.tStatCatcher_1Process(job.java:12389)
	at project.job_version.job.tGSPut_1Process(job.java:10671)
	at project.job_version.job.tKafkaInput_1Process(job.java:10537)
	at project.job_version.job.tKafkaConnection_1Process(job.java:5626)
	at project.job_version.job.tJava_1Process(job.java:5502)
	at project.job_version.job.tPrejob_1Process(job.java:5371)
	at project.job_version.job.runJobInTOS(job.java:12865)
	at project.job_version.job.main(job.java:12581)
[statistics] disconnected
[statistics] disconnected
[statistics] disconnected
[statistics] disconnected
[statistics] disconnected
[statistics] disconnected

Job job ended at 22:57 19/03/2020. [Exit code  = 1]

I created a job that connects to a Kafka topic and outputs the file to CSV.

The job then uploads the CSV file to Google Cloud Storage.

Also, in the same job, I have the tAssert, tFlowMeter, tLogCatcher, and tStatsCatcher components mapped to BigQuery output components.

When I disable only the CSV upload to GCS, the job runs successfully.

When I disable only the log components, the job runs successfully.

When both are enabled I receive the error listed above.

Has anyone run into this or a similar issue?

Re: Error when attempting to log catcher components to BigQuery AND upload a file into Google Cloud Storage in the same job

Anonymous — Fri, 20 Mar 2020 03:05:12 GMT

Re: Error when attempting to log catcher components to BigQuery AND upload a file into Google Cloud Storage in the same job

Anonymous — Fri, 20 Mar 2020 03:30:15 GMT

I'm running Talend Big Data v7.3.1 with:

java version "1.8.0_201"
Java(TM) SE Runtime Environment (build 1.8.0_201-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)

Re: Error when attempting to log catcher components to BigQuery AND upload a file into Google Cloud Storage in the same job

Anonymous — Fri, 20 Mar 2020 18:28:44 GMT

Same here.

Having Bigquery alone it´s ok.

Having Drive alone it´s ok.

Having both, does not work.

Re: Error when attempting to log catcher components to BigQuery AND upload a file into Google Cloud Storage in the same job

Anonymous — Fri, 20 Mar 2020 20:47:48 GMT

Thanks for the feedback. Hopefully there's an enhancement on the feature backlog that would allow multiple Google-related components to be added within a single job.

Do you think a potential workaround is to leave the BigQuery logging components in a parent job and create a sub-job that contains the Google Cloud Storage component?

Re: Error when attempting to log catcher components to BigQuery AND upload a file into Google Cloud Storage in the same job

Anonymous — Fri, 20 Mar 2020 21:07:27 GMT

I'm affraid, it seems that it needs to be in a separated thread.