tBigQueryOutput component issue in Auth_code generation

Anonymous — Sat, 16 Nov 2024 09:10:38 GMT

Hi,

With this post i want to understand 2 things:

1) Internal processing of tBigQueryOutput component ? Is it generating bq or gsutil query to load data to google big query.

2) Facing below error while generating Auth_code for the component:

Starting job test_bq at 18:01 12/10/2017.

[statistics] connecting to socket on port 3811
[statistics] connected
Exception in component tBigQueryOutput_1_tBQBE
java.lang.NullPointerException
at com.google.api.client.repackaged.com.google.common.base.Preconditions.checkNotNull(Preconditions.java:191)
at com.google.api.client.util.Preconditions.checkNotNull(Preconditions.java:127)
at com.google.api.client.json.jackson2.JacksonFactory.createJsonParser(JacksonFactory.java:92)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:85)
at com.google.api.client.json.JsonObjectParser.parseAndClose(JsonObjectParser.java:81)
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:88)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:570)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:362)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at local_project.test_bq_0_1.test_bq.tFileInputDelimited_1Process(test_bq.java:879)
at local_project.test_bq_0_1.test_bq.runJobInTOS(test_bq.java:1388)
at local_project.test_bq_0_1.test_bq.main(test_bq.java:1245)
[statistics] disconnected
Job test_bq ended at 18:01 12/10/2017. [exit code=1]

Re: tBigQueryOutput component issue in Auth_code generation

Anonymous — Thu, 19 Oct 2017 08:21:24 GMT

Hi,

Are your connection parameters Client Id, Client Secret Ok with you?

Here are online documents about component reference:TalendHelpCenter:tBigQueryOutput and the related scenario:TalendHelpCentercenario: Writing data in BigQuery.

Best regards

Sabrina

topic Re: tBigQueryOutput component issue in Auth_code generation in Talend Studio

tBigQueryOutput component issue in Auth_code generation

Re: tBigQueryOutput component issue in Auth_code generation