issue while executing tBigQueryOutput component

Six Stars

issue while executing tBigQueryOutput component

H

I am trying to send some data in the form of table into Big Query using tBigQueryOutput component, but I am getting the following error while execution, May anyone help me to get this resolved?

BTW, if i deactivate the Bigquery component and use a tlogrow to check its output it is working fine. Can anyone of you help me to know where I am getting this wrong?

 

bigquery_error.jpg

Forteen Stars

Re: issue while executing tBigQueryOutput component

it generally syntax errors - like missed quotes, or wrong variable name and etc

 

if You attache screenshot of component settings it will be more easy to help

-----------
Six Stars

Re: issue while executing tBigQueryOutput component

I found the problem and got the problem resolved. However, If I ran the job, then it says that 11 rows (which I have at source) is processed with 2 different error as mentioned below, can you help me out to know what exactly is the problem at both these different cases? I guess 2nd one is related to connection issue and the 2nd one is related to deeper issue. Can you help me resolve what is the actual issue?



1st Error :
[WARN ]: virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum - tBigQueryOutput_1_tBQBE - C:\Talend\git\project.git\token.properties (The system cannot find the file specified)
Exception in component tBigQueryOutput_1_tBQBE
java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
[FATAL]: virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum - tBigQueryOutput_1_tBQBE Read timed out
at sun.security.ssl.InputRecord.readFully(Unknown Source)
at sun.security.ssl.InputRecord.read(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream0(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:77)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:965)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:283)
[statistics] disconnected
at com.google.api.client.googleapis.auth.oauth2.GoogleAuthorizationCodeTokenRequest.execute(GoogleAuthorizationCodeTokenRequest.java:158)
at virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum.tFileInputDelimited_1Process(iTether_json_curriculum.java:1060)
at virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum.runJobInTOS(iTether_json_curriculum.java:1590)
at virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum.main(iTether_json_curriculum.java:1424)

Job iTether_json_curriculum ended at 15:29 29/05/2017. [exit code=1]



2nd Error I got while re-running the job


[WARN ]: virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum - tBigQueryOutput_1_tBQBE - C:\Talend\git\project.git\token.properties (The system cannot find the file specified)
[FATAL]: virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum - tBigQueryOutput_1_tBQBE 400 Bad Request
{
"error" : "invalid_grant"
}
Exception in component tBigQueryOutput_1_tBQBE
com.google.api.client.auth.oauth2.TokenResponseException: 400 Bad Request
{
"error" : "invalid_grant"
}
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:105)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
at com.google.api.client.googleapis.auth.oauth2.GoogleAuthorizationCodeTokenRequest.execute(GoogleAuthorizationCodeTokenRequest.java:158)
at virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum.tFileInputDelimited_1Process(iTether_json_curriculum.java:1060)
at virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum.runJobInTOS(iTether_json_curriculum.java:1590)

at virtusa_project.itether_json_curriculum_0_1.iTether_json_curriculum.main(iTether_json_curriculum.java:1424)




Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download