Skip to Content
Author's profile photo John Appleby

HANA SP7 features – monitoring

There are some cool new monitoring features in SAP HANA SP7. You can right click the system and select:

– Open Memory Overview

– Open Resource Utilization

Screen Shot 2013-12-05 at 10.44.10 AM.png

However, you may find you get the error: “Error while opening ‘Memory Overview’ Editor” or ‘Resource Overview” – Reason: You do not have the required privilege.

Screen Shot 2013-12-05 at 10.44.32 AM.png

This is because it requires a new role: sap.hana.admin.roles::Monitoring

If you add this role to your user, like this:

Screen Shot 2013-12-05 at 10.47.21 AM.png

And now we can open up the new monitors!

Screen Shot 2013-12-05 at 3.19.28 PM.png

Screen Shot 2013-12-05 at 3.19.40 PM.png

These tools look like really useful ways of seeing how your HANA system is behaving in real-time, and should be particularly useful for development and testing environments.

Assigned tags

      32 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi John,

      thanks for providing this workaround! I consider such a permission problem a bug with HANA. If even user SYSTEM cannot see the Memory Overview or Resource Utilization per default, then SAP should change that in the next revision.

      Regards,

      Mark

      Author's profile photo Lars Breddemann
      Lars Breddemann

      Hi Mark,

      I see your point, but I have to disagree.

      SYSTEM is not supposed to be the operational DBA user.

      It should be used as the 'bootstrapping' user. The one single account that sets up the system and the permission layout.

      This includes the creation of a monitoring role that contains the privileges to view the monitor data.

      The thing with pre-delivered users like SYSTEM is: default is king.

      Whatever permission we (SAP) deliver it with, that is exactly what we will find in most installations.

      So, when the privilege setup should be somewhat secure and distributed to the different system responsibilities (like user management, backup operator, system monitor, etc.) then it's not a good idea to provide an account that can do everything.

      If there's such an account, then this account will be used for, well, everything.

      And if the SYSTEM user "accidentally" (meaning something else was intended) drop this schema or changes this model then it doesn't help to say "well, we told you that you shouldn't do it that way - you should've set up proper roles and users for this".

      However, I agree upon that we need to provide a set of working default roles for the standard scenarios. And that is currently worked upon.

      - Lars

      Author's profile photo Former Member
      Former Member

      Hi Lars,

      you are speaking of much less than 1% of the databases. Every database vendor is emphasizing the TCO, including SAP! And that is what happens out there in the wild: There is no sophisticated security concept implemented. Of course a mature database must allow for a segregation of duties, but this is hardly anywhere found. Especially on SAP systems where the user and permission management is done by the application anyway.

      SYS was always my favorite user on Oracle, SYSTEM will be my favorite user on HANA. I like to keep things simple and there are only very few reasons which really justify the complexity. If you have to protect your database from your DBAs, because they could accidentially drop a schema ... oh my 😉

      Regards,

      Mark

      Author's profile photo John Appleby
      John Appleby
      Blog Post Author

      Sorry Lars I'm not with you here 🙂

      System should have this role added by default as well as a bunch of others that are now missing.

      If you want security with HANA then you need to do some work configuring the SoD model regardless.

      Author's profile photo Former Member
      Former Member

      Yet another good feature from SPS07.

      Author's profile photo Former Member
      Former Member

      I agree a very helpful feature - a lot of customers were waiting for this!

      Author's profile photo Raj Kumar Salla
      Raj Kumar Salla

      Cool feature. Graphical representation is always impressive.

      John now you have lot of documents to publish I guess.

      Regards

      Raj

      Author's profile photo Rama Shankar
      Rama Shankar

      Thanks John!

      Regards,

      Rama Shankar

      Author's profile photo Denys Kempen
      Denys Kempen

      Hi John,

      The SAP HANA Academy just published a blog on What's New with SPS 7 for monitoring that lists the latest tutorial videos on the topic of monitoring.

      Denys

      Author's profile photo Echo Chen
      Echo Chen

      Hi John,

      I add the sap.hana.admin.roles::Monitoring to SYSTEM user. The previous error about privilege disappeared.

      However, I still could not see the new graph with opening 'Memory Overview' editor.

      Are there any other configuration steps needed?

      HANA DB Version           1.00.70.00.386119

      HANA studio Version       1.0.7000

      Author's profile photo Former Member
      Former Member

      Me too. I already wondered whether I am the only one who cannot see the Memory Overview. The same for Resource Utilization. No error message, no graphics, just a blank window.

      Author's profile photo Krishna Tangudu
      Krishna Tangudu

      is it showing you anything in alerts or traces? Must be some other role to "View" you are missing here?

      may be do you have these roles?

      sap.hana.xs.admin.roles::*


      Check after adding these if it is working?


      Regards,

      Krishna Tangudu

      Author's profile photo Former Member
      Former Member

      Hello there,

      Already raise the issue in both XS and UI5 community @ https://community.wdf.sap.corp/message/476331#476331 & https://community.wdf.sap.corp/message/476332#476332 . No reply yet.

      Any idea which component is responsible for this?

      Thanks!

      B.R.

      Ian

      Author's profile photo Echo Chen
      Echo Chen

      Hello Krishna,

      We added all the roles sap.hana.xs.admin.roles::*  to system user. And it is still not working. 😕

      Author's profile photo Krishna Tangudu
      Krishna Tangudu

      Did you enable the traces? Can you see anything in the traces? or alerts?

      Regards,

      Krishna Tangudu

      Author's profile photo Former Member
      Former Member

      Hi Krishna,

      I am running HANA with the default trace configuration. I enabled the SQL trace and the User-Specific Trace and retried to open the Memory Overview. Still nothing. And except for some standard SQL statements in the SQL trace file, nothing in the tracefiles. I have never ever seen the Memory Overview work, neither with revision 70, 71 or 72.

      Since it seems I am not the only one affected, I have opened a discussion thread about this effect:

      How do I enable the Memory Overview in HANA Studio?

      Regards,

      Mark

      Author's profile photo Candy Zhan
      Candy Zhan

      Hi Mark,

      I tried Rev 73, still blank. Have you figured out this issue? Or get any feedback yet?

      Regards,

      Candy

      Author's profile photo Sung Han Choi
      Sung Han Choi

      HI,

      As of  SPS7,

      refer below SAP note

      "0001978195_xs web application shows only a blank page.pdf"

      Thank you

      Author's profile photo Former Member
      Former Member

      Hi,

      Thanks for your comment, but it still does NOT work by adding charset="UTF-8".

      I knew this lack of charset in generated index.html long time ago.

      However, I don't think it is relevant to the issue here, as this app did not throw any syntax error in the console when rendering, it is just sheer blank page with some information in the console.

      I actually open up an internal msg 8908/2014, it is said that this is a bug...But obviously I cannot check the bug detail here without authorization.



      Author's profile photo Former Member
      Former Member

      Which trace we need here? If you check my thread in community, if I revise the code in XS app a bit, the content shows up perfectly...

      Author's profile photo Former Member
      Former Member

      Very interesting, good progress.

      but still you can't tools to clear understand situation with memory and who it eating and for why.

      Author's profile photo Srinivas Kakarla
      Srinivas Kakarla

      Jon,

      Thanks for the details. We are able to view the graphical representations of memory and resource utilization by assigning the specified monitoring role, but on certified vendor appliances and not on VMWare instances.

      Not sure if this is intended or am I missing something here. Please advise.

      Thanks.

      Author's profile photo Gowrisankar M
      Gowrisankar M

      Hi ,

      If the monitoring features Open Memory Overview ,Open Resource Utilization,open dashboard

      not working please make sure below perquisites are present.


      1.Permission->it requires a new role: sap.hana.admin.roles::Monitoring

      2. Browser-->Your local system should have IE-9 and higher.


      (monitoring features directly depend on the windows default browser IE 9 and higher) and as of now they have not implemented with different browser dependency)

      IE 8 is not supported since HTML 5 not preferably used in.

      testtttt.PNG

      Hope this helps 🙂


      BR,

      Gowrisankar

      Author's profile photo Former Member
      Former Member

      I had updated hana db from version 1.00.68 to 1.00.80 four month ago. There is no sap.hana.admin.roles roles in my HANA db. I didn't find the same problem like me in here. How to create it? 😕

      Author's profile photo Henricus Bouten
      Henricus Bouten

      How did you update?

      Did you use the SAP HANA LifeCycle Management tools or hdbupd?

      Author's profile photo Former Member
      Former Member

      Hi Hay,

      I used HLM tool to do that. Update was smoothly,without any error.

      Author's profile photo Henricus Bouten
      Henricus Bouten

      Then the role should be there. So in SAP HANA Studio => <your database> => Security => Roles there is no role named: sap.hana.admin.roles::Monitoring

      Is the HANA_ADMIN Delivery Unit loaded? You can check this in the SAP HANA Modeler Perspective => Delivery Units.

      Author's profile photo Former Member
      Former Member

      Great ,after  import it the role was created.Thanks Hay 🙂 🙂

      Author's profile photo Henricus Bouten
      Henricus Bouten

      HI Peter,

      You are welcome! But the missing HANA_ADMIN DU points to a installation going not so smooth. During the installation of the SAP HANA were there any problems?

      Do you have all the auto content DU loaded?

      Author's profile photo Former Member
      Former Member

      I have not loaded all of them.Usually,I load specify content DU when need it.

      Shall I load all of content DU ?

      There was no errors shown during install and update.But I often meet out of memory problem,when the session connetion status become 'RUNNING(CANCEL REQUESTED)'.

      Is there relationship between them?

      Author's profile photo Henricus Bouten
      Henricus Bouten

      After a normal install using hdblcm all the auto_content packages are automatically loaded. The content packages not. You should only load them if needed.

      I think your out of memory error isn't related to the not installed DU's.

      Author's profile photo Former Member
      Former Member

      Oh, I will check it.

      'Open Memory Overview '  and 'Open dashboard'   are available. 🙂

      Thank you,Hay.