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

2 REPLIES
Ten 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)