SAP HANA 2.0 Cockpit FAQ

thanks for such helpful wiki docs !

starting new with HANA cockpit 2.0 SP11 e.g. with backup scheduling for a tenantDB (AS-Java) or backup scheduling for the systemDB,

we struggle with the requirements for backup job scheduling.

In every HANA database, xs-engine must be activated and xs-job scheduling must be activated - the documentation is poor and you waste a lot of valuable time checking:

1) which XS engine is installed (XS-C or XS-A) and how can you can recognize, whether it is activated

    how check xs-engine for different tenantDB ? - must be enabled in each tenantDB + systemDB ?

2) is the xs job scheduling activated? - how do you check this?

3) what authorities must be assigned to a backup-user, especially the HANA cockpit security + authorizations is not easy

4) create backup-user in each HanaDB - each tenant-DB ! 

5) missing Hana-User authority is resulting in missing (not shown) options in HANA-Cockpit ! (e.g. "manage backup" is not shown when missing authority)

6) does a managed HanaDB needs the XS-A additionally or is backup-scheduling possible with XS-C engine?

7) (in cockpit view "resource directory")

     trying to change an initially maintained "user credentials" with "manage credentials" (edit an already created and authority-assigned backup-user)

     causing error "Unable to validate credentials"  ??

======================== 

additional info: 

the error  "Unable to validate credentials"  is caused when creating Backup-User and mark/select the option "disable ODBC/JDBC access" (within User in TenantDB) 

after deselect that option "disable ODBC/JDBC access" the usage of that user in HANA-Cockpit works fine.

Hi Christoph - Thank you for your feedback.  I'll pass along the information to our User Assistance colleague to enhance the documentation.  Here are the answers to your questions:

1) You can check the different services that are running by clicking the "Database Status" tile in the System Overview page.  It takes you to the "Manage Services" app.  You can do this for tenants and SYSTEMDB  and that's where you'd check which XS engine is running.  It needs to be enabled for each database.

2) The "Manage Services" app will show you that.  If you need to enable it, you can issue a SQL statement as described here: https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/5ca042ca971f4fddbc1d4a961f7c22ed.html.

3) Please refer to this document for the authorizations: https://help.sap.com/viewer/afa922439b204e9caf22c78b6b69e4f2/2.11.0.0/en-US/d7d31c767207407fadb3a5ddfeec1321.html.

4) I understand this to be a documentation error.

5) That's the expected behaviour and it's a new feature in later versions of the HANA cockpit.  We had many requests to hide tiles where the cockpit user doesn't have the privilege to perform that operation.

6) You need the XSC engine.

7) As you noticed, you need ODBD/JDBC enabled for a database user.

I hope this information helps you!

José Ramos
SAP HANA Product Management
SAP Labs Canada

Hi Jose, thanks for your reply, 

to 1) + 2) 

after executing that SQL-statements to systemDB and to tenantDB as described in the help-doc, (i did SQL-execution within HANA_studio in sql-console, and checked after that so the value was "true") 

but

within HANA-Cockpit trying to setup a backup-jobscheduling => "Backup schedules", after configuring the jobschedule-setup for one job, it was shown in the header-lines "The schedule job is not enabled" 

why ?

after going => "Backup configuration" => in section "Data Backup Scheduler" there was shown a switch that shows "off" => so i do "edit" in "Data Backup Scheduler" and switch-on that function again. 

is a different config needed (not only the mentioned sql-statement to setup XS-engine and to setup xs-scheduler) or was this a matter of delayed or not already finished reload of the HANA_configuration within the HANA-cockpit ? (i am able to deliver detailed hardcopys, if needed) 

thanks

the HANA cockpit 2.0 itself has a HANA systemDB only,

Trying to activate XS-engine and XS-Jobscheduling with SQL_Statements, did not succeed ?  ( 0 records affected )

but trying to setup the backup-jobscheduling for HANA-Cockpit itself, -  a message comes up: 

"This database is running without an XS Engine. Therefore it is not possible to schedule backups, and any already scheduled backups will not be executed.

For more information, see the SAP HANA Database Administration Guide."  ( the help.sap.com docs are only according to XS-C engine ?)

============= 

as i know, the HANA-cockpit comes with an XS-A engine,  How to activate XS-A engine for jobscheduling ? 

Hi Christoph, XSC is required for job scheduling, so activating it is required.

Hi Christoph,

It depends. HANA Cockpit can be also installed as a tenant in an existing HANA system. In this case it can be scheduled and backed up like every other tenant database, provided XSC is activated. If you have cockpit installed standalone on HANA express, here is an article how to schedule backups for HANA express: https://blogs.sap.com/2016/10/31/backup-databases-sap-hana-express-sap-hana-academy/ .