Troubleshooting
Problem
This error indicates a timeout while the JDBC driver attempts to communicate with Snowflake. This can be caused by network issues or the default timeout settings being insufficient for the request duration.
Symptom
2024-09-23 07:10:10,455 [user:*sample_user@organization] [pipeline:PIPELINE_NAME/PIPELINE_NAME__537c27e2-54ee-4dde-b24d-ebc9124d7e54__orgnaizationname] [runner:0] [thread:ProductionPipelineRunnable-PIPELINE_NAME__537c27e2-54ee-4dde-b24d-ebc9124d7e54__OrganzationName-PIPELINE_NAME] [stage:Snowflake_01] ERROR HikariPool - HikariPool-15807 - Exception during pool initialization.
net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Read timed out.
at net.snowflake.client.jdbc.RestRequest.execute(RestRequest.java:301) ~[snowflake-jdbc-3.13.25.jar:3.13.25]
at net.snowflake.client.core.HttpUtil.executeRequestInternal(HttpUtil.java:737) ~[snowflake-jdbc-3.13.25.jar:3.13.25]
at net.snowflake.client.core.HttpUtil.executeRequestWithoutCookies(HttpUtil.java:558) ~[snowflake-jdbc-3.13.25.jar:3.13.25]
at net.snowflake.client.core.SessionUtil.federatedFlowStep3(SessionUtil.java:1153) ~[snowflake-jdbc-3.13.25.jar:3.13.25]
Caused by: java.net.SocketTimeoutException: Read timed out
Resolving The Problem
You should investigate the following:
Increase Timeout Settings:
Adjust the JDBC connection property to increase the timeout:
net.snowflake.jdbc.http_client_socket_timeout_in_ms
The default timeout is set to 5 minutes. You can raise this value according to your needs.
Check Network:
If increasing the timeout does not resolve the issue, consult your network team to investigate potential connectivity problems affecting the JDBC driver.
JDBC Driver connection parameter reference.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSM7CU","label":"IBM StreamSets Data Collector"},"ARM Category":[{"code":"","label":""}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
15 March 2025
UID
ibm17186192