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)




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

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog