Five Stars

tBigQueryOutput component issue in Auth_code generation

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]

 

Talend bigquery auth_code.PNG

 

 

1 REPLY
Moderator

Re: tBigQueryOutput component issue in Auth_code generation

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:TalendHelpCenterSmiley Frustratedcenario: Writing data in BigQuery.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.