SAP Knowledge Base Article - Public

3229794 - Import Data Connection to SAP HANA with TLS Option "Signed by a certificate authority" fails in SAP Analytics Cloud

Symptom

When attempting to create an Import Data Connection to SAP HANA with the TLS Option "Signed by a certificate authority" the following error is shown in the Console log and Network trace;

  • {"result":"{\"status\":\"Error\",\"error\":{\"code\":\"ERROR_CONNECTION_INVALID_CERTIFICATE_VALIDATION_FAID\",\"rawError\":\"SAP DBTech JDBC: Certificate validation failed : com.ibm.jsse2.util.j: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target.\",\"params\":[\"SAP DBTech JDBC: Cannot connect to jdbc:sap://<HANAHost:HANAPort> [Cannot connect to host <HANAHost:HANAPort> [com.ibm.jsse2.util.j: PKIX path building failed: com.ibm.security.cert.IBMCertPathBuilderException: unable to find valid certification path to requested target], -813.].\"]},\"httpStatus\":500}"}

  • {"result":"{\"status\":\"Error\",\"error\":{\"code\":\"ERROR_CONNECTION_INVALID\",\"rawError\":\"SAP DBTech JDBC: TLSv1 protocol cannot be initialized: Error constructing implementation (algorithm: Default, provider: IBMJSSE2, class: com.ibm.jsse2.bf$d).\",\"params\":[\"SAP DBTech JDBC: Cannot connect to jdbc:sap://<HANAHost:HANAPort>  [Cannot connect to host <HANAHost:HANAPort> [Error constructing implementation (algorithm: Default, provider: IBMJSSE2, class: com.ibm.jsse2.bf$d)], -813.].\"]},\"httpStatus\":500}"}

  • {\"code\":\"ERROR_CONNECTION_INVALID_CERTIFICATE_VALIDATION_FAID\",\"rawError\":\"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:// <HANAHost:HANAPort>[Cannot connect to host <HANAHost:HANAPort> [sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target], -813.].\"]}

Environment

  • SAP Analytics Cloud 2022.8+
  • SAP HANA secured with valid CA Signed Certificate

Reproducing the Issue

  1. Log in to SAP Analytics Cloud
  2. Navigate to Connections
  3. Create a new Import Data Connection to SAP HANA
  4. Select TLS Option "Signed by a certificate authority (Recommended)
  5. Observe the error in the Console and Networks tab within Google Chrome Developer Tools

Cause

Resolution

If the issue persists after following the steps above, the issue is currently under investigation by the Development team

See Also

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

Keywords

  • ERROR_CONNECTION_INVALID_CERTIFICATE_VALIDATION_FAID
  • ERROR_CONNECTION_INVALID
  • ERROR_CONNECTION_INVALID_CERTIFICATE_VALIDATION_FAID
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, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-AUT , SAC Authentication / Login , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0