HANA Cockpit 2.0 - unable to recover tenant databases

[MarcinOzdzinski]

Hana Cockpit Version 2.9.6 (2019-02-18 04:01:49 +0100)

From SYSTEMDB on SYSTEM USER when i choose Manage Databases three dots icon is grayed out.

Any hints ?

[pfefferf]

Which privileges does your user have assigned?

[MarcinOzdzinski]

Default SYSTEM user with following priviliges:

ADAPTER ADMIN
AGENT ADMIN
AUDIT ADMIN
AUDIT OPERATOR
BACKUP ADMIN
BACKUP OPERATOR
CATALOG READ
CERTIFICATE ADMIN
CLIENT PARAMETER ADMIN
CREATE CLIENTSIDE ENCRYPTION KEYPAIR
CREATE R SCRIPT
CREATE REMOTE SOURCE
CREATE SCENARIO
CREATE SCHEMA
CREATE STRUCTURED PRIVILEGE
CREDENTIAL ADMIN
DATA ADMIN
DATABASE ADMIN
DATABASE START
DATABASE STOP
DEVELOPMENT
DROP CLIENTSIDE ENCRYPTION KEYPAIR
ENCRYPTION ROOT KEY ADMIN
EXPORT
EXTENDED STORAGE ADMIN
IMPORT
INIFILE ADMIN
LDAP ADMIN
LICENSE ADMIN
LOG ADMIN
MONITOR ADMIN
OPTIMIZER ADMIN
REPO.CONFIGURE
REPO.EXPORT
REPO.IMPORT
REPO.MAINTAIN_DELIVERY_UNITS
REPO.MODIFY_CHANGE
REPO.MODIFY_FOREIGN_CONTRIBUTION
REPO.MODIFY_OWN_CONTRIBUTION
REPO.WORK_IN_FOREIGN_WORKSPACE
RESOURCE ADMIN
ROLE ADMIN
SAVEPOINT ADMIN
SCENARIO ADMIN
SERVICE ADMIN
SESSION ADMIN
SSL ADMIN
STRUCTUREDPRIVILEGE ADMIN
TABLE ADMIN
TENANT ADMIN
TRACE ADMIN
TRUST ADMIN
USER ADMIN
VERSION ADMIN
WORKLOAD ADMIN
WORKLOAD ANALYZE ADMIN
WORKLOAD CAPTURE ADMIN
WORKLOAD REPLAY ADMIN

i was able to perform recovery via Hana Studio using same SYSTEM user - unfortunately there are other bugs in Studio and this product is out of maintanance.

[santhoshkumarg1988]

Hi Marcin Ozdzinski,

You need to select a tenant database then the options will be enable as shown in below images

Before selecting a tenant db options are not enabled

After selecting the tenant database you can get the options as shown in below