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

-
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.

Comments

Post a Comment

Popular posts from this blog

FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen()

-
Problem: HDB start command will issue the error "FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen()" Scenario: Command 'HDB start' failed with below error:FAIL: NIECONN_REFUSED (Connection refused), NiRawConnect failed in plugin_fopen() sapcontrol commands also failed with error 'FAIL: NIECONN_REFUSED (Connection refused)' service sapstartsrv was not running, checked by command 'ps -ef | grep sapstartsrv' From OS log file /var/log/messages, find error occurred during HANA startup Cause: Permission error Troubleshooting: From the /var/log/messages, the following error was found "Unable to change to Directory /usr/sap/SID/HDBXX/hostname/trace Resolution: The instance profile may be damaged by the unexpected or mistaken shutdown. The SAPLOCALHOST parameter was pointing to wrong hostname due to which the sapstartsrv agent was not able to find/write the log files under the respective hana trace directory. After...
Read more

Exploring SAP Program RS_ABAP_SOURCE_SCAN and Its Usage

-
Image
SAP program RS_ABAP_SOURCE_SCAN is a powerful tool designed for advanced search functionality within ABAP source codes. This utility is especially useful for developers and system administrators who need to locate specific pieces of code, identify usages of particular statements or functions, and perform complex code analysis across the entire SAP system. Here’s an overview of its key features and practical applications. Key Features Comprehensive Search Capabilities:  Keyword Search : RS_ABAP_SOURCE_SCAN allows you to search for specific keywords or strings within ABAP programs. This can include function modules, methods, classes, and more. Example of How It Helped In a recent project, we were faced with the task of locating a hardcoded value within our ABAP codebase. This hardcoded value was causing issues, and we needed to identify all instances of it quickly to make the necessary adjustments. Using the RS_ABAP_SOURCE_SCAN program, we were able to scan all the programs and effi...
Read more

XS/Cockpit URLs SSL certificates are not updated after HANA DB SSL Certificate renewal

-
Problem:  XS URLs  SSL certificates are not updated after HANA DB SSL Certificate renewal Cause:  AP HANA 2.0 Cockpit is based on  SAP HANA XS Advanced (XSA)  which handles certificates a bit different than the former XS classic implementation. The XSA SSL certification is sometimes overwritten with a new installation/update. Solution: You need to bundle the certificate chain and import it to the XSA cert path. Export certificates for XSA sapgenpse export_p12 -p cockpithttps.pse -C 0 cockpithttps.p12 Export private key, certificate and CA chain & combine certificate and CA chain into 1 file. openssl pkcs12 -in cockpithttps.p12 -nocerts -nodes | sed -ne '/-BEGIN PRIVATE KEY-/,/-END PRIVATE KEY-/p' > privatekey.key openssl pkcs12 -in cockpithttps.p12 -clcerts -nokeys | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > certificate.pem openssl pkcs12 -in cockpithttps.p12 -cacerts -nokeys | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > cach...
Read more