Correção de erro ERROR "SecurityService - org.pentaho.pms.core.exception.PentahoMetadataException: Error getting file from HTTP : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target"

Se você implementou o SSL em seu servidor do Pentaho BI, mais exatamente no Pentaho User Console (PUC), e não consegue realizar publicações utilizando o Pentaho Metadata Editor (PME), devido a ocorrência de erro conforme abaixo:

ERROR 08-03 10:24:00,645 - SecurityService - Unable to create new security reference object using XML string

ERROR 08-03 10:24:00,645 - SecurityService - org.pentaho.pms.core.exception.PentahoMetadataException: Error getting file from HTTP : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
org.pentaho.pms.schema.security.SecurityService.getContentFromServer(SecurityService.java:354)
org.pentaho.pms.schema.security.SecurityService.getContent(SecurityService.java:257)
org.pentaho.pms.schema.security.SecurityService.getUsers(SecurityService.java:450)
org.pentaho.pms.schema.security.SecurityReference.toXML(SecurityReference.java:103)
org.pentaho.pms.ui.security.SecurityDialog.test(SecurityDialog.java:581)
org.pentaho.pms.ui.security.SecurityDialog$5.handleEvent(SecurityDialog.java:310)
org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
org.eclipse.jface.window.Window.open(Window.java:796)
org.pentaho.pms.ui.MetaEditor.editSecurityService(MetaEditor.java:3807)
org.pentaho.pms.ui.MetaEditor$26.handleEvent(MetaEditor.java:590)
org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:851)
org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3589)

ERROR 08-03 10:24:00,650 - SecurityService - Unable to create new security reference object using XML string
ERROR 08-03 10:24:00,650 - SecurityService - org.pentaho.pms.core.exception.PentahoMetadataException: Error getting file from HTTP : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
org.pentaho.pms.schema.security.SecurityService.getContentFromServer(SecurityService.java:354)
org.pentaho.pms.schema.security.SecurityService.getContent(SecurityService.java:257)
org.pentaho.pms.schema.security.SecurityService.getRoles(SecurityService.java:474)
org.pentaho.pms.schema.security.SecurityReference.toXML(SecurityReference.java:104)
org.pentaho.pms.ui.security.SecurityDialog.test(SecurityDialog.java:581)
org.pentaho.pms.ui.security.SecurityDialog$5.handleEvent(SecurityDialog.java:310)
org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
org.eclipse.jface.window.Window.open(Window.java:796)
org.pentaho.pms.ui.MetaEditor.editSecurityService(MetaEditor.java:3807)
org.pentaho.pms.ui.MetaEditor$26.handleEvent(MetaEditor.java:590)
org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
org.pentaho.pms.ui.MetaEditor.readAndDispatch(MetaEditor.java:851)
org.pentaho.pms.ui.MetaEditor.main(MetaEditor.java:3589)

ERROR 08-03 10:24:00,654 - SecurityService - Unable to create new security reference object using XML string

Para correção, você precisa importar o certificado da página do PUC, para o keystore default do Java, conforme os procedimentos a seguir.

Acessar a página do PUC, no qual você queira obter o acesso e exporte o certificado.

<ilustrações>
Em seguida, importe o certificado para o keytool de seu java.

~# keytool -import -alias tomcat -keystore $JAVA_HOME/lib/security/cacerts -file /tmp/sobdemanda.crt

Sem mais, abraço.

Categories: