Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: On using https link for Hyperlink in PRD it gives SSLHandshakeException

  1. #1
    Join Date
    May 2015
    Posts
    5

    Default On using https link for Hyperlink in PRD it gives SSLHandshakeException

    Hello,
    I'm trying to add Hyperlink to a column of Report which links to another report .
    It is working fine when I use http link or say any local link ; but on using https link it gives error and does not show any of the Files and Folders that exist in the https link. It gives given error

    • java.lang.RuntimeException: 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
    • (UpdateReservedCharsTask.java:90)
      at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:251)
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)
      at java.awt.EventQueue.access$200(EventQueue.java:103)
      at java.awt.EventQueue$3.run(EventQueue.java:694)
      at java.awt.EventQueue$3.run(EventQueue.java:692)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:154)
      at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:182)
      at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:221)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:219)
      at java.awt.Dialog.show(Dialog.java:1082)
      at java.awt.Component.show(Component.java:1651)
      at java.awt.Component.setVisible(Component.java:1603)
      at java.awt.Window.setVisible(Window.java:1014)
      at java.awt.Dialog.setVisible(Dialog.java:1005)
      at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.setVisible(CommonDialog.java:281)
      at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.performEdit(CommonDialog.java:193)
      at org.pentaho.reporting.designer.core.editor.drilldown.HyperlinkEditorDialog.performEdit(HyperlinkEditorDialog.java:94)
      at org.pentaho.reporting.designer.core.actions.elements.format.EditHyperlinkAction.actionPerformed(EditHyperlinkAction.java:94)
      at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
      at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
      at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
      at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
      at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
      at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
      at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
      at java.awt.Component.processMouseEvent(Component.java:6505)
      at javax.swing.JComponent.processMouseEvent(JComponent.java:3320)
      at java.awt.Component.processEvent(Component.java:6270)
      at java.awt.Container.processEvent(Container.java:2229)
      at java.awt.Component.dispatchEventImpl(Component.java:4861)
      at java.awt.Container.dispatchEventImpl(Container.java:2287)
      at java.awt.Component.dispatchEvent(Component.java:4687)
      at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
      at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
      at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
      at java.awt.Container.dispatchEventImpl(Container.java:2273)
      at java.awt.Window.dispatchEventImpl(Window.java:2719)
      at java.awt.Component.dispatchEvent(Component.java:4687)
      at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
      at java.awt.EventQueue.access$200(EventQueue.java:103)
      at java.awt.EventQueue$3.run(EventQueue.java:694)
      at java.awt.EventQueue$3.run(EventQueue.java:692)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
      at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
      at java.awt.EventQueue$4.run(EventQueue.java:708)
      at java.awt.EventQueue$4.run(EventQueue.java:706)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
      at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
      at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)



    Is it the problem of Pentaho Report Designer or the problem with the https link itself which points to Pentaho Reports.
    What needs to be done at Pentaho End(PRD)

    Thanks,
    Shalini
    Last edited by Shalini A; 12-16-2015 at 05:14 AM.

  2. #2
    Join Date
    Apr 2008
    Posts
    146

    Default

    This error usually from the client software run on a desktop means that the Java Virtual Machine's certificate trust store does not have the SSL certificate and private key imported.
    The keytool shipped with Java needs a bit of help.

    For the BA Server with the SSL certificate:
    Example: Suppost you have a crt file from your SSL certificate provider and the PEM format private key file that was used to generate the original CSR (certificate signing request).
    1. convert it into a valid p12 format
    2. import that into a keystore you can use.

    example command lines
    Doing 1:
    openssl pkcs12 -export -in /etc/ssl/certs/818d93cb10663ff4.crt -inkey star_stonegatesl_com.key -out keystore.p12 -name stonegate -CAfile /etc/ssl/certs/gd_bundle-g2-g1.crt -caname root
    Doing 2:
    keytool -importkeystore -destkeypass changeit -destkeystore ~/.keystore -srckeystore keystore.p12 -srcstoretype PKCS12 -alias stonegate


    For using a desktop JVM like Java 7 or 8.
    You could also force the default JVM keystore to import the certificate. (It would be missing the private key, which is fine for the client software.)

    C:\Program Files\Java\jdk1.8.0_101\jre\bin>
    keytool -import -alias stonegate -keypass changeit -keystore ..\lib\security\cacerts -file C:\Users\bjackson\Downloads\cert.pem

    cert.pem was really just the crt file from the certificate signer like GoDaddy etc.

    Notice that the store is within the 'jre/lib/security/cacerts file

    Hope that helps point in the right direction.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.