Problem description
Unable to discover SAP HANA databases due to invalid license.
Cause
The license is not valid
Traceback
SAPHANADiscovery.log
Log Location: /var/log/Druva/EnterpriseWorklaods/sap-hana/saphanadiscovery.log
[2024-07-26 11:14:33,007] [ERROR] Error <class 'hdbcli.dbapi.Error'>:(437, 'only commands for license handling are allowed in current state'). Traceback -Traceback (most recent call last):
File "hdb.py", line 234, in get_system_overview
File "hdb.py", line 50, in execute
hdbcli.dbapi.Error: (437, 'only commands for license handling are allowed in current state')
Verification:
To validate customers certificates, connect to sap database user by running command:
su - <SID>adm
Connect to database running hdbsql query:
hdbsql -u <user> -p <password> -i <instance_no> -d systemdb
Execute query:
hdbsql SYSTEMDB=> SELECT SYSTEM_ID,START_DATE, EXPIRATION_DATE, VALID FROM M_LICENSE;
If the output of column “valid” is false, then the license is invalid
For Database with valid license output will be similar to the below given example:| SYSTEM_ID | START_DATE | EXPIRATION_DATE | VALID|| "AUT" | "2023-08-22 00:00:00.000000000" | "2025-12-31 23:59:59.999999000" | "TRUE"|here VALID is true.
For Databases with in-valid license output will be similar to the below given example:| SYSTEM_ID | START_DATE | EXPIRATION_DATE | VALID|| "KRD" | ? | ? | "FALSE"|here VALID is false,
Resolution:
Databases will be discovered once a valid license is added.
See Also: