Hi All,
Am using tBigQueryOutput component in my job but am getting the following error if i run the job
Exception in component tBigQueryOutput_1_tBQBE
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
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.waitForClose(Unknown Source)
at sun.security.ssl.HandshakeOutStream.flush(Unknown Source)
at sun.security.ssl.Handshaker.kickstart(Unknown Source)
at sun.security.ssl.SSLSocketImpl.kickstartHandshake(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.getOutputStream(Unknown Source)
at sun.net.
www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.google.api.client.http.javanet.NetHttpRequest.execute(NetHttpRequest.java:79)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:814)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:284)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:308)
at com.google.api.client.auth.oauth2.Credential.executeRefreshToken(Credential.java:524)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:269)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:446)
Could anyone help me out in fixing this error ?
Thanks,
Lmit
Hi, What's the build version you are using? Can you reach your Big Query by client? Have you checked timeout setting and server's maximum login connection? firewall? Could you please use tBigQueryOutputBulkExec components instead of the tBigQueryOutput to see if this issue repro? Best regards Sabrina
Hi,
Thanks for your reply...
I have checked more into this and it turns out that the company has changed the firewall policy.
We now have a Websense endpoint installed on machines which routes the network traffic through proxy server for HTTP and HTTPS requesst. I want to use this proxy setting of my machine through Talend but when used from Preferences tab, I get the error mentioned earlier.
Please note I am using Bigquery output component. Other bigquery exec component also gives same error.It works fine on the machine where proxy server setting is not performed. The settings done in Preferences tab are like:
HTTP settings
IP
user name
password
HTTPS settings
IP
user name
password
We now have a Websense endpoint installed on machines which routes the network traffic through proxy server for HTTP and HTTPS requesst. I want to use this proxy setting of my machine through Talend but when used from Preferences tab, I get the error mentioned earlier. Please note I am using Bigquery output component. Other bigquery exec component also gives same error.It works fine on the machine where proxy server setting is not performed. The settings done in Preferences tab are like: HTTP settings IP user name password HTTPS settings IP user name password
We
suggest you connect to the Support portal: https://support.talend.com/otrs/customer.pl and log your request, so that we can give you a remote assistance to address your issue quickly through the support cycle.
