topic Re: [resolved] Socket Exception in Talend Studio

[resolved] Socket Exception

lmit — Sat, 16 Nov 2024 11:34:26 GMT

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

Re: [resolved] Socket Exception

Anonymous — Fri, 25 Jul 2014 04:10:20 GMT

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

Re: [resolved] Socket Exception

lmit — Fri, 01 Aug 2014 11:18:56 GMT

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

Re: [resolved] Socket Exception

Anonymous — Fri, 01 Aug 2014 11:39:11 GMT

Hi,
Could you please tell me what's the build version you are using?
Best regards
Sabrina

Re: [resolved] Socket Exception

lmit — Mon, 04 Aug 2014 09:13:39 GMT

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

Re: [resolved] Socket Exception

Anonymous — Mon, 04 Aug 2014 09:59:38 GMT

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