SAP Knowledge Base Article - Public

2932437 - "PKIX path building failed" when creating a Model based on a Live Data Connection to SAP Universe in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

This KBA relates to the legacy version LUC 2.x only. It is heavily recommended to upgrade to LUC 3.x for Full Support and for a much simpler deployment process.

When attempting to create a model based on a Live Data Connection to SAP Universe using Live Universe Connector 2.4, the Query Builder is empty, and the following error occurs in SAP Analytics Cloud (SAC):

  • "{"code":500,"message":"javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: SSLHandshakeException invoking https:/<tomcathostname:tomcatport>/biprws/raylight/v1/universes/27532: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target","stacktrace":"com.sap.csina.cloud.qb.QueryBuilderException: javax.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: SSLHandshakeException invoking https:/<tomcathostname:tomcatport>/biprws/raylight/v1/universes/27532"

  • HTTPS BIPRWS hostname and port has been defined in the boe.properties file

Environment

  • SAP Analytics Cloud (Enterprise) 2020.8.9
  • SAP Live Universe Connector (BOE Live Data Connect) 2.4
  • SAP Business Intellligence Platform 4.2 

Reproducing the Issue

  1. Login to SAP Analytics Cloud
  2. Create a Live Data Connection to SAP Universe (Successful)
  3. Create a Model using same Connection
  4. Observe Query Buildler is empty and error message is displayed 

Cause

This issue is currently under investigation by development.

Resolution

Workaround

  • As a workaround, please use the BIPRWS Port for HTTP and declare these changes in the boe.restUrl parameter in the boe.properties file

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-LDC-UNV , SAC Live Data Connection Universe , Problem

Product

SAP Analytics Cloud 1.0