Clarity: Jaspersoft Studio Unable to connect in Clarity SaaS

book

Article ID: 193579

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Unable to connect to Jaspersoft Studio and Jaspersoft JDBC Adapters 

Steps To Reproduce: 

  1. Download and install Jaspersoft Studio 
  2. Configure Jaspersoft Studio using the documentation

Expected Result: The connection to the Jaspersoft Studio and Jaspersoft JDBC Adapters.

Actual Result: The connection error with the below errors listed in cause section.

Cause

The connection is failing because of the failure in SSL handshake between Jaspersoft Server and Jaspersoft Studio, the error stack is below:

Caused by: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)
at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1959)
at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302)
at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:296)
at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1514)
at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)
at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1026)
at sun.security.ssl.Handshaker.process_record(Handshaker.java:961)
at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1072)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)
at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397)
at sun.net.www.protocol.https.HttpsClient.afterConnect(HttpsC

Environment

Release : 15.8

Component : CA PPM SAAS JASPERSOFT

Resolution

  1. Open the Jaspersoft URL in the browser and click on Lock Icon on the browser navigation bar and download the certificate chain from Jaspersoft URL by opening in the browser
  2. Go to Jaspersoft Studio Installation directory example C:\Program Files\TIBCO\Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\lib\security
  3. Copy the certificate downloaded in Step 1 to the Jaspersoft Studio Installation directory example C:\Program Files\TIBCO\Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\lib\security
  4. Run the key tool command
    1. keytool -importcert -file Root.cer -keystore cacerts -alias Root
      Enter Keytool Password: changeit
    2. keytool -importcert -file Intermediate.cer -keystore cacerts -alias intermediate
      Enter Keytool Password: changeit
    3. keytool -importcert -file Last.cer -keystore cacerts -alias servercert
      Enter Keytool Password: changeit
    4. Note: The keytool commmand will import the certificate to the cacerts
  5. Now restart Jaspersoft Studio and you should be able to connect

Keytool location

Keytool is located in the folder below:

(example)

C:\Program Files\TIBCO\Jaspersoft Studio Professional-7.1.0.final\features\jre.win32.win32.x86_64.feature_1.8.0.u151\jre\bin

Additional Information

Jaspersoft Studio - Connect to SSL enabled Server

Issues relating to SSL Certificate to allow TIBCO Jaspersoft® Studio to connect to a server using HTTPS