topic Re: Connection to snowflake in Talend Bigdata Platform 7.0.1 in Talend Studio

Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Sat, 16 Nov 2024 07:41:48 GMT

Hi,

I ve connected to snowflake database using Talend by using the metadata connection provided within Talend Bigdata Platform 7.0.1

While droping in th components on my designer my job keeps failing due to the below error :

Exception in component tDBConnection_1 (Snowflake)
java.lang.RuntimeException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: java.security.cert.CertificateEncodingException: Failed to encode object..
at nbcu_jobs.snowflake_0_1.Snowflake.tDBConnection_1Process(Snowflake.java:471)
at nbcu_jobs.snowflake_0_1.Snowflake.runJobInTOS(Snowflake.java:952)
at nbcu_jobs.snowflake_0_1.Snowflake.main(Snowflake.java:778)
[FATAL]: nbcu_jobs.snowflake_0_1.Snowflake - tDBConnection_1 net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: java.security.cert.CertificateEncodingException: Failed to encode object..
java.lang.RuntimeException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: java.security.cert.CertificateEncodingException: Failed to encode object..
at nbcu_jobs.snowflake_0_1.Snowflake.tDBConnection_1Process(Snowflake.java:471)
at nbcu_jobs.snowflake_0_1.Snowflake.runJobInTOS(Snowflake.java:952)
at nbcu_jobs.snowflake_0_1.Snowflake.main(Snowflake.java:778)

Please help me resolve this.

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Mon, 10 Sep 2018 04:50:28 GMT

Hello,

Are you trying to connect over SSL?

Best regards

Sabrina

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Tue, 11 Sep 2018 09:20:06 GMT

Hi Sabrina,

I appreciate your reply. How can I check my connectivity is SSL?

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Tue, 11 Sep 2018 10:40:13 GMT

Hello,

With your Talend Bigdata Platform subscription solution, could you please create a case on talend support portal so that we could give you a remote assistance(webex session ) through support cycle with priority?

https://login.talend.com/support-login.php

Feel free to let us know if there is any login issue for you.

Best regards

Sabrina

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Wed, 12 Sep 2018 08:28:16 GMT

Hi Sabrina,

I tried logging in with my credentials and says the that I require an account no.

Also tried to create a new account but says my email is already registered.

Can you help me log in to this portal ?

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Wed, 12 Sep 2018 09:07:19 GMT

Hello,

For your talend support portal login issue, could you please send me a private message with your credentails? I would send an email to Customer Care <customercare@talend.com> for help.

Best regards

Sabrina

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Mon, 24 Sep 2018 09:03:04 GMT

Resolved:

The solution to this issue was the port number which needs to be enabled.(port no:443)

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

Anonymous — Sun, 03 May 2020 17:45:55 GMT

This issue is related to JIRA TDI-42686. Just add the additional jvm parameter and the additional jdbc parameter and then this issue will be resolved. This issue is related to the jdbc driver that we are using on the backend and this driver in future releases to include a fix for this issue from Snowflakes side related also this issue on their side:

https://www.snowflake.com/blog/latest-changes-to-how-snowflake-handles-ocsp/

JVM Parameter:
-Dnet.snowflake.jdbc.ocspFailOpen=true

JDBC Parameter:
insecureMode=true

Re: Connection to snowflake in Talend Bigdata Platform 7.0.1

bashwin — Mon, 15 Jul 2024 11:16:09 GMT

i'm also facing the same issue - where we need to specify/enable the port no ?