HANA System locked; license expired

We have below situations to do licensing in HANA DB System

• License expired & HANA DB System is locked
• Your temporary license is expired after installation
• Permanent license key is expired
• You manually deleted license key
• Change in hardware key

Below are the symptoms of above issue-

• Your SAP application will not be able to connect to HANA DB
• You are not able to connect to HANA from Studio/Cockpit

Solution:-

1.Identify the HARDWARE KEY of the HANA DB System

From HANA Studio,
Right Click Hana System ---> Properties ----> License

From SQL Level,
SELECT * FROM M_LICENSE
SELECT HARDWARE_KEY, PRODUCT_NAME FROM M_LICENSE

2.Renew & download the system license from SAP Marketplace                      https://support.sap.com/licensekey

3.License installation from SQL, use below command

hdbsql SYSTEMDB=>  SET SYSTEM LICENSE '----- Begin SAP License -----       SAPSYSTEM=HDB
HARDWARE-KEY=xxxxxxx
INSTNO=xxxxxxxxx
BEGIN=20180804
EXPIRATION=99991231
LKEY=MIIBOwYJKoZIhvcNAQcCoIIBLDCCASgCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGCAQcwggEDAgEBMFgwUjELMAkGA1UEBhMCREUxHDAaBgNVBAoTE215U0FQLmNvbSBXb3JrcGxhY2UxJTAjBgNVBAMTHG15U0FQLmNvbSBXb3JrcGxhY2UgQ0EgKGRzYSkCAgGhMAkGBSsOAwIaBQCgXTAYBgkqhkiG9w0BCQMxCwYJ\KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xODA4MDUwNTUyMzhaMCMGCSqGSIb3DQEJBDEWBBSGvPyZLXuSjUi1cLFslVA/ROC3NzAJBgcqhkjOOAQDBC8wLQIVAIOCL4JibHYcw5Lb+xljaV8IGO5mAhQjQfd/HpGKJXUBGuiAVyond4HmHg==
SWPRODUCTNAME=SAP-HANA
SWPRODUCTLIMIT=0000000xxx
SYSTEM-NR=0000000008xxxxxx5

 
From Hana Studio,
Right Click Hana System ---> Properties ----> License
Click on Install License option, load the license.

After the license installation, restart your system. System will work properly

Thanks for reading, Please share your valuable feedback.  

Share this

Basis Genie