Send to Tableau Server SSL - Job Failed

Hi, I’ve been trying to publish a hyperfile to TS using the secure host but receive the error below:

ERROR Send to Tableau Server 0:5 Execute failed: javax.net.ssl.SSLHandshakeException: SSLHandshakeException invoking https://xxxxxxxxxxxxxxxxxx.com/api/2.8/auth/signin: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Publishing the same workflow to the http protocol of TS works fine.
I’ve gone through several posts and guidelines in order to installing JAVA JRE, add the SSL certificate to Java manager, used SSLPoke to check whether the host can be reached and it can (with port 443) - has successfully connected when I run the SSLPoke command.

-Tableau Hyper, send to tableau server
-Send to Tableau server node error
-https://stackoverflow.com/questions/373295/digital-certificate-how-to-import-cer-file-in-to-truststore-file-using
-https://matthewdavis111.com/java/poke-ssl-test-java-certs/

I’m under the impression that KNIME still isn’t recognizing the certificate perhaps since the certification default location is not Java/JRE_XXXXX/lib/security/cacerts. But then again this is just my assumption.

My assumption is that the certificate has been added to the trusted key store successfully but KNIME is trying to retrieve from the wrong location.

I’m not sure what I’m doing wrong or what more needs to be done to enable the connection.

Any advise will be greatly appreciated!

Ofer

Hi
Are you using the KNIME JRE or a standalone installation? You mention that you have installed the JRE, but this should not be required since KNIME has its own JRE built-in.
The KNIME JRE path is in the KNIME install path and (latest version)
plugins\org.knime.binary.jre.win32.x86_64_1.8.0.252-b09

1 Like

That seems to work!

Than k you very much for your help.

I did in fact install the CERT into an independent Java JRE installation.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.