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.