Connection to snowflake in Talend Bigdata Platform 7.0.1

[Anonymous]

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.

[Anonymous]

Hello,

Are you trying to connect over SSL?

Best regards

Sabrina

[Anonymous]

Hi Sabrina,

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

[Anonymous]

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

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous · Accepted solution]

Resolved:

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

[Anonymous]

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

[bashwin]

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