topic Oracle to BigQuery load in Talend Studio

Oracle to BigQuery load

Anonymous — Wed, 22 Jan 2020 22:46:45 GMT

I am trying to push a few records from Oracle to BigQuery. The top part of the screenshot makes it seem like the load succeeded but the errors are below in that screenshot. Can't tell what to interpret from it. Is the error log always this abstract ? What does this mean ?

Re: Oracle to BigQuery load

Anonymous — Thu, 23 Jan 2020 18:54:13 GMT

Anyone with insights on this ?

Re: Oracle to BigQuery load

Anonymous — Sun, 02 Feb 2020 06:52:00 GMT

Can you upload a screenshot of basic settings of tBigQueryOutput?
Note that The file name in the File filed must be the same as the one you defined in the Local filename field.

Regards
Shong

Re: Oracle to BigQuery load

Anonymous — Mon, 03 Feb 2020 16:05:41 GMT

Hi Shong, here's the screenshot of the output and also, the latest error screenshot.

Also, here's the error message which is cut out from the error screenshot

"org.jets3t.service.ServiceException: Service Error Message. -- ResponseCode: 403, ResponseStatus: Forbidden, XML Error Message: <?xml version='1.0' encoding='UTF-8'?><Error><Code>InvalidSecurity</Code><Message>The provided security credentials are not valid.</Message><Details>Request was not signed or contained a malformed signature</Details></Error>"

SS2TalendCommunity_Shong_error1.JPG

Re: Oracle to BigQuery load

kotvir — Thu, 03 Jun 2021 00:17:56 GMT

Hi could you able to resolve this ?