How to install hana streaming license for tenant database

[benzhang]

The hana streaming service is unavailable because the license on the tenant database is expired. After research, I saw there's already a solution: https://launchpad.support.sap.com/#/notes/0002645528, I have the similar issue with the reference. The "install licence" button is grayed out in Studio, so I followed his way, and installed a hana cockpit:

But the difference from the solution is: I cannot find either "DB Administration" section or "Manage system licenses" item.

Now this become a blocking issue. Is there anything I missed? Installing the tenant license must be on the cockpit? Is there a workaround?

Best regards,

Ben

[RobertWaywell · Accepted solution]

Hi Ben,

I'm using a newer version of Cockpit and don't have an older version available to try out. Using SAP HANA Cockpit 2.8.8 (2018-11-22 07:36:30 +0100), I was able to successfully apply licenses to my test system today. Comparing the HANA Cockpit version that you showed in the original question to the version # I am currently using, I'm wondering if your Cockpit just might be too old to include this option.

I'm not an expert on reading the version #'s for HANA Cockpit, but I think the version you are using translates as SP 00 Patch 6 in contrast to SP08 Patch 8 for the version I am using. I may not have that exactly right, but it is definitely clear that the version you have installed was released in 2016 whereas HANA 2.0 SPS02, which is the HANA version where you had to start administering licenses through HANA Cockpit, was released in 2017.

As a next step I would recommend updating your HANA Cockpit version to current release. I expect that will resolve the issue but if not then we will be in a better position to troubleshoot further.

Thanks

Rob

[benzhang]

Hi Robert,

I've updated the hana cockpit to the latest version: 2.8.8, and the "Manage system licenses" appear.

Best regards,

Ben

[benzhang]

Hi Robert,

Thanks for the solution. I tried the way you proposed to create a new user. And use him as the technical user. Secondly, I am always using "SYSTEM" user to administer the target tenant DB. But it turns out the "Manage system licenses" option never appear. Is there another way to install the tenant db license? For example: In studio? Command line?

Thanks,

Ben

[RobertWaywell]

Hi Ben,

There are different credentials required in different places when working with Cockpit. To Register a resource, you need to specify a user of the target database that has been configured with specific permissions which give read access to various resources. An example script to create a Cockpit Technical user would like this:

CREATE USER PM1_COCKPIT_USER PASSWORD Password1 NO FORCE_FIRST_PASSWORD_CHANGE;
GRANT CATALOG READ to PM1_COCKPIT_USER;
GRANT SELECT on SCHEMA _SYS_STATISTICS to PM1_COCKPIT_USER;


GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE on SCHEMA _SYS_TELEMETRY to PM1_COCKPIT_USER;

In that script I am creating a user called "PM!_COCKPIT_USER" that will be used to register the database as a resource in HANA Cockpit Manager. Since you are currently using SYSTEM as the Cockpit Technical user, you should verify that you have provided the necessary permissions. I'm not sure if SYSTEM has those permissions by default.

You then switch to HANA Cockpit and in the Resource Directory have to specify a User ID that will be used to administer the target database. This is where I tend to use the SYSTEM database user, although you have the option of creating a different user with the appropriate permissions:

Have you configured these credentials yet and if so, what database user have you specified here?

Thanks

Rob

[benzhang]

Hi Robert,

I used the user COCKPIT_ADMIN to login to the cockpit admin, and registered the tenant DB "IB1@IB0" by specifying the user "SYSTEM".

Thanks,

Ben

[benzhang]

Hi Robert,

I'm using the System database user, so I assume he has the administration permissions.

Thanks,

Ben

[RobertWaywell]

When you supplied the Database User credentials to connect from Cockpit, what user ID did you provide? Does it have full system administration permissions?

Keep in mind that the Cockpit technical user which is created and used to register the resource in the Cockpit Manager does not have database/system administration permissions. The Database User that you then specify in HANA Cockpit is the user that requires database/system administration permissions. That could be your SYSTEM database user, or another user that has been granted the necessary permissions.