SAP HANA * 19: invalid license SQLSTATE: HY000

HANA www.basisguru.com

Symptoms:

You might have run into the situation where you are facing error (19: invalid license SQLSTATE: HY000) while login using SAP HANA hdbsql to HANA DB.

hdbsql=>
* 19: invalid license SQLSTATE: HY000
hdbsql=>
* 19: invalid license SQLSTATE: HY000

Possible Causes of 19: invalid license SQLSTATE: HY000 error :

We have a multi-tenant HANA database with valid license installed on tenant database instead of SYSTEM DB.

Or system might have been into lockdown mode.

System lockdown occurs when,

  1. We have manually deleted all licenses
  2. Temporary license has expired & we didn’t renew license within 28 days.
  3. Amount of licensed memory has exceeded of the enforced license.
  4. We changed the hardware and new key wasn’t requested.

Solution:

We need to install valid license on SYSTEM DB as shown below:

Firstly, we need to view licenses installed in our SAP HANA database on the License page of the SAP HANA cockpit.
For this purpose, we should have LICENSE ADMIN privilege.

<img src=“HANA cockpit License Management.jpg” alt=“describes HANA cockpit License Management in DB admin screen” title=“HANA cockpit License Management”>
HANA cockpit License Management

As per the procedure described in the below link, we need to request a permanent License key via SAP support portal support.sap.com/licensekey (under launch the license key application).

https://help.sap.com/viewer/afa922439b204e9caf22c78b6b69e4f2/2.8.0.0/en-US/2130bbb3cdc149c983954058892ed5e8.html

Once we receive the license key in .txt format via mail from SAP, we need to upload the license key as shown below.

Login to SAP HANA Cockpit.
Select option Request New License then upload New license.

<img src=“Upload License HANA cockpit screen.jpg” alt=“Upload License HANA cockpit screen” title=“Upload License HANA cockpit screen”>
Upload License

Once License is installed successfully, as a result the 19: invalid license SQLSTATE: HY000 shall be gone.