Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Writing to BigQuery errors

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)

Labels (3)
1 Reply
Anonymous
Not applicable
Author

@nthampiSorry to tag you directly but any insight on this