Wednesday 4 September 2019

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

Tags


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

  1. HANA DATABASE 1.0
  2. HANA DATABASE 2.0
  3. 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.






EmoticonEmoticon

Note: only a member of this blog may post a comment.