Error while fetching data from snowflake to mendix

0
Hi Experts,   I'm getting JDBC connection issue in Mendix while fetching data from few snowflake tables. This was working fine earlier and it is happening now for few tables only. Error msg in Mendix - JDBC driver internal error: Max retry reached for the download of #chunk0 (Total chunks: 4) retry=7, error=net.snowflake.client.jdbc.SnowflakeSQLLoggedException: JDBC driver encountered communication error. Message: Received close_notify during handshake.     Kindly help me to resolve this issue as issue is in production.
asked
2 answers
0

Hi Abrar,

It seems not Mendix issue but the following Snowflake's issue.

https://community.snowflake.com/s/article/Snowflake-JDBC-throws-error-while-fetching-large-data-JDBC-driver-internal-error-Timeout-waiting-for-the-download-of-chunk0

 

Best regards,

Yuta Suzuki.

answered
0

Hi Abrar,

 

The 'close_notify during handshake' part of the error indicates that the connection was closed unexpectedly whilst doing the SSL handshake. A search on the web indicates that this can be caused by the following:

  • Network issues: A temporary disruption in connectivity between your client and Snowflake.
  • Firewall or proxy interference: Security appliances might be blocking or inspecting SSL traffic.
  • SSL certificate validation failure: The client may not trust the Snowflake server's certificate.
  • JDBC driver version mismatch: An outdated or incompatible driver could cause communication failures.

 

Solutions could be:

  • Verify firewall and proxy settings: Make sure Snowflake traffic is not being blocked or inspected.
  • Update the JDBC driver: Ensure you're using the latest version of the Snowflake JDBC driver.
  • Check SSL configurations: If using a proxy, verify that SSL inspection is not interfering with the connection.
answered