[resolved] Socket Exception

One Star

[resolved] Socket Exception

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
  
Moderator

Re: [resolved] Socket Exception

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Socket Exception

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
Moderator

Re: [resolved] Socket Exception

Hi,
Could you please tell me what's the build version you are using?
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.
One Star

Re: [resolved] Socket Exception

Hi,
5.4.1.r111943 is the build version and enterprise edition.
Thanks,
Lmit
Moderator

Re: [resolved] Socket Exception

Hi,
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.

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.