How to handle HANA Alert 129: Check trusted certificate expiration date

How to handle HANA Alert 129: Check trusted certificate expiration date

When checking the Alerts in HANA Cockpit or HANA Studio , there is an alert called "X trusted certificate will expire soon or has already expired."

Or 

you can find the ID 129 in the SQL result of : SELECT * FROM _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS

Solution:

You can use the following SQL statements to determine if any certificates will expire soon or have already expired

select certificate_id , subject_common_name, issuer_common_name , valid_from , valid_until , comment , subject_distinguished_name , issuer_distinguished_name , basic_constraints , subject_alt_name from certificates;

select pse_name , certificate_id , subject_name , issuer_name , valid_from , valid_until , certificate_usage from pse_certificates;

Check the date in the column valid_until, and ask your CA to sign this certificate again.

 

Reference : 3220398 (Educational purpose only)