Writing to BigQuery errors

Anonymous — Sat, 16 Nov 2024 03:26:38 GMT

I am using Talend Open Studio for Data Integration 7.3.1 for evaluating and weighing it's benefits before i go for their Enterprise offering.

I am reading from an Oracle Table which is successful as the live indicator of progress in UI indicates.

I have given the CORRECT "Service account credentials file" ALONG with the CORRECT ProjectId, Dataset and Table names in GCP.

The error i am getting is "Empty Key" ( see detailed error below ) .It looks as though it';s expecting details on Google Storage configurations of "Access Key", "Secret Key", "Bucket", "File", "Header".

MY MAIN question is Why is TALEND FORCING me to enter Google Storage Configuration details like "Access Key", "Secret Key", "Bucket", "File", "Header". ( BigQuery has it's own storage aspects )

[WARN ] 15:52:42 org.jets3t.service.utils.Mimetypes- Unable to find 'mime.types' file in classpath

Exception in component tBigQueryOutput_2_tBQBE (loadOra2BQ)

org.jets3t.service.ServiceException: Request Error: Empty key

at org.jets3t.service.impl.rest.httpclient.RestStorageService.performRequest(RestStorageService.java:563)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.performRequest(RestStorageService.java:264)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.performRestPut(RestStorageService.java:1017)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.createObjectImpl(RestStorageService.java:1828)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.putObjectWithRequestEntityImpl(RestStorageService.java:1749)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.putObjectImpl(RestStorageService.java:1741)

at org.jets3t.service.StorageService.putObject(StorageService.java:840)

at org.jets3t.service.impl.rest.httpclient.GoogleStorageService.putObject(GoogleStorageService.java:416)

at mytalend.loadora2bq_0_1.loadOra2BQ.tDBInput_1Process(loadOra2BQ.java:1016)

at mytalend.loadora2bq_0_1.loadOra2BQ.runJobInTOS(loadOra2BQ.java:1444)

at mytalend.loadora2bq_0_1.loadOra2BQ.main(loadOra2BQ.java:1293)

Caused by: java.lang.IllegalArgumentException: Empty key

at javax.crypto.spec.SecretKeySpec.<init>(SecretKeySpec.java:96)

at org.jets3t.service.utils.ServiceUtils.signWithHmacSha1(ServiceUtils.java:144)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.authorizeHttpRequest(RestStorageService.java:689)

at org.jets3t.service.impl.rest.httpclient.GoogleStorageService.authorizeHttpRequest(GoogleStorageService.java:467)

at org.jets3t.service.impl.rest.httpclient.RestStorageService.performRequest(RestStorageService.java:312)

Re: Writing to BigQuery errors

Anonymous — Tue, 28 Jan 2020 16:15:49 GMT

@nthampiSorry to tag you directly but any insight on this

topic Writing to BigQuery errors in Talend Studio

Writing to BigQuery errors

Re: Writing to BigQuery errors