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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sirarm9
Contributor
Contributor

tBigQueryOutput SignatureDoesNotMatch

Hi, I'm trying to use the tBigQueryOutput component but I receeive this error message:

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

Exception in component tBigQueryOutput_1_tBQBE (test)

org.jets3t.service.ServiceException: Service Error Message. -- ResponseCode: 403, ResponseStatus: Forbidden, XML Error Message: <?xml version='1.0' encoding='UTF-8'?><Error><Code>SignatureDoesNotMatch</Code><Message>The request signature we calculated does not match the signature you provided. Check your Google secret key and signing method.</Message><StringToSign>PUTqIc+QU/1fdXGSMlChMp6HQ==application/octet-streamMon, 28 Sep 2020 14:00:24 GMTx-goog-meta-md5-hash:a8873e414ff57dd5c648c94284ca7a1d/test_sth/biquery_bulk.txt</StringToSign></Error>

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

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 bi.test_0_1.test.tDBInput_2Process(test.java:1394)

at bi.test_0_1.test.runJobInTOS(test.java:1851)

at bi.test_0_1.test.main(test.java:1702)

I've already use the json service account file downloaded from Google Cloud and filled the field Access Key and Secret Key of the component with the private key id and private key of the json file.

Please help me.

Thanks

Regards

Armando

Labels (2)
0 Replies