SAP Knowledge Base Article - Preview

3503845 - Got error "We couldn't connect to the TLS-configured HANA database because the TLS certificate couldn't be validated." when create an import data connection to HANA using TLS Option in SAP Analytics Cloud (SAC)

Symptom

Got the below errors when create import data connection to HANA using TLS Option in SAC:

  • In SAC UI:
    Error 1:
    We couldn't connect to the TLS-configured HANA database because the TLS certificate couldn't be validated. For security reasons, we recommend that the certificate be signed by a trusted CA. If that's not possible, select the option to skip validation. For more information, see the help topic "Import Data Connection to SAP HANA".
    Error 2:
    We couldn't connect to the TLS-configured HANA database because we can't verify the host name provided in the certificate. Please check the connection details and try again. For more information, see the help topic "Import Data Connection to SAP HANA". 
  • In HAR trace:
    SAP DBTech JDBC: Certificate validation failed : sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.\",\"params\":[\"SAP DBTech JDBC: Cannot connect to jdbc:sap://<HANA Host>:<HANA Port> [Cannot connect to host <HANA Host>:<HANA Port>  [sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target 
  • In Tomcat Catalina log:
    SAP DBTech JDBC: Cannot connect to jdbc:sap://<HANA Host>:<HANA Port> [Cannot connect to host <HANA Host>:<HANA Port> [sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target 


Read more...

Environment

  • SAP Analytics Cloud (Enterprise)
  • SAP HANA

Product

SAP Analytics Cloud all versions

Keywords

KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.