SAP Knowledge Base Article - Public

2601586 - How to check certificate expiry date within SAP HANA Cloud Platform, after renewing certificate within SAP Analytics Cloud?

Symptom

How to check certificate expiry date within SAP HANA Cloud Platform, after renewing certificate within SAP Analytics Cloud?

You renewed your certificate in SAP Analytics Cloud and you have problems using your Live Connections to SAP HANA in Cloud Platform: failed to connect to system.

Environment

  • SAP Analytics Cloud
  • SAP HANA in SAP Cloud Platform

Reproducing the Issue

  1. Renew certificate within SAP Analytics Cloud
  2. Update certificate within SAP Cloud Platform. Follow Step: Live Data Connection to SAPCP with SSO
  3. After updating, there is no way to check the expiry date for the certificate

Cause

The certificates are added to your HANA system but not removed unless you do it manually.

Resolution

1. Login to SAP HANA Cloud XS Admin Page and check if Trust Manager is enabled?

https://<Your_HANA_Server>:<HANA_PORT>/sap/hana/xs/admin/


1_HANA_Trust_not_enabled.png

2. If the Trust Manager is no enabled, add roles sap.hana.xs.admin.roles::TrustStoreAdministrator and sap.hana.xs.admin.roles::TrustStoreViewer

2_Add_required_roles_to_SYSTEM_account.png

3. Once the roles are added/activated, Trust Manager will be enabled

3_Trust_available_in_HANA_XS_Admin.png

4. Select the Trust Manager and check the expiry date on certificate

4_HANA_Certificate_List.png

See Also

Keywords

SAC, SAP BusinessObjects Cloud, Business Objects, SAC, renew, certificate, HCP, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0