Posts

Showing posts from March, 2020

SAP HANA TenantDB is locked with license key error System locked; license is invalid or expired but SYSTEMDB has a valid license

Image
Issue : SYSTEMDB has a valid license and is not locked Tenant is locked with the error " System locked; license is invalid or expired " This error will occure in HANA DATABASE 1.0 HANA DATABASE 2.0 Multi-Tenant Database Container Scenario : License keys that are applied directly to the  TENANT  database will override any licenses on the  SYSTEMDB. Solution: Remove the license key from the  TENANT  database. This allows the  TENANT  to inherit the  SYSTEMDB  license key. To do this, run the following  SQL  command from the  TENANT  (not the  SYSTEMDB ) UNSET SYSTEM LICENSE ALL This does not require a restart of the  SYSTEMDB  or  TENANT . However, a new connection will need to be established.