connection error to snowflake null response for request post

Four Stars cog
Four Stars

connection error to snowflake null response for request post

I used the Snowflake component to connect to the snowflake. The test connection was successful and I could get the tables. but when I wanted to use 't snowflake output' to insert a simple CSV file to snowflake table it raised an error: Null response for request=POST, Connection timed out

I also increased the time out for the connection from 30 to 120 but no difference, keep getting a 'null response for request post' 

job.png

 

 

 

[WARN ]: net.snowflake.client.jdbc.RestRequest - Null response for request=POST.................HTTP/1.1

[WARN ]: net.snowflake.client.jdbc.RestRequest - Exception encountered for: POST.................. HTTP/1.1
net.snowflake.client.jdbc.internal.apache.http.conn.HttpHostConnectException: Connect to s.eu-west-1.snowflakecomputing.com:443 [s.eu-west-1.snowflakecomputing.com/34.247.247.75, s.eu-west-1.snowflakecomputing.com/52.30.85.75, s.eu-west-1.snowflakecomputing.com/52.209.170.35] failed: Connection timed out: connect
at net.snowflake.client.jdbc.internal.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:159)
at net.snowflake.client.jdbc.internal.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:373)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:381)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:237)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:185)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:111)
at net.snowflake.client.jdbc.internal.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
at net.snowflake.client.jdbc.internal.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
at net.snowflake.client.jdbc.internal.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108)
at net.snowflake.client.jdbc.RestRequest.execute(RestRequest.java:164)
at net.snowflake.client.core.HttpUtil.executeRequestInternal(HttpUtil.java:369)
at net.snowflake.client.core.HttpUtil.executeRequest(HttpUtil.java:318)
at net.snowflake.client.core.HttpUtil.executeRequest(HttpUtil.java:290)
at net.snowflake.client.core.SessionUtil.newSession(SessionUtil.java:1257)
at net.snowflake.client.core.SessionUtil.openSession(SessionUtil.java:853)
at net.snowflake.client.core.SFSession.open(SFSession.java:396)
at net.snowflake.client.jdbc.SnowflakeConnectionV1.<init>(SnowflakeConnectionV1.java:143)
at net.snowflake.client.jdbc.SnowflakeDriver.connect(SnowflakeDriver.java:331)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.talend.components.snowflake.runtime.utils.DriverManagerUtils.getConnection(DriverManagerUtils.java:34)
at org.talend.components.snowflake.runtime.SnowflakeRuntime.createConnection(SnowflakeRuntime.java:84)
at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.validate(SnowflakeSourceOrSink.java:72)
at org.talend.components.snowflake.runtime.SnowflakeSink.validate(SnowflakeSink.java:41)
at local_project.loaddata_0_1.loadData.tFileInputDelimited_1Process(loadData.java:1306)
at local_project.loaddata_0_1.loadData.runJobInTOS(loadData.java:2304)
at local_project.loaddata_0_1.loadData.main(loadData.java:2153)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at net.snowflake.client.jdbc.internal.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:339)
at net.snowflake.client.jdbc.internal.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:142)
... 27 more
[WARN ]: net.snowflake.client.jdbc.RestRequest - Null response for request=POST............................HTTP/1.1
[ERROR]: net.snowflake.client.jdbc.RestRequest - Stop retrying since elapsed time due to network issues has reached timeout. Elapsed=126071 milliseconds, timeout=30 seconds
Exception in component tDBOutput_1 (loadData)
java.lang.RuntimeException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to s.eu-west-1.snowflakecomputing.com:443 [s.eu-west-1.snowflakecomputing.com/34.247.247.75, s.eu-west-1.snowflakecomputing.com/52.30.85.75, s.eu-west-1.snowflakecomputing.com/52.209.170.35] failed: Connection timed out: connect.
at local_project.loaddata_0_1.loadData.tFileInputDelimited_1Process(loadData.java:1308)
at local_project.loaddata_0_1.loadData.runJobInTOS(loadData.java:2304)
at local_project.loaddata_0_1.loadData.main(loadData.java:2153)
[statistics] disconnected

Moderator

Re: connection error to snowflake null response for request post

Hello,

Could you please check if the connection port number is enabled.(port no:443)?

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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads