Skip to Content

SAP HANA comes with different tools that can be accessed via Browser. The URLs, of course, differ and also require certain permissions. In addition some minor configuration to the SAP HANA database needs to be done to make all tools fully available.

This is a list of all my blog-posts about those tools:

URLs, Permissions and Configuration for the Web Dispatcher

URLs, Permissions and Configuration for the HALM

URLs, Permissions and Configuration for the Web-based Development Workbench

URLs, Permissions and Configuration for the XS Classic Server

URLs, Permissions and Configuration for the HDBLCM

URLs, Permissions and Configuration for the SAP HANA Cockpit for Offline Administration

 

In this blog I explain how to access SAP HANA’s Web Dispatcher. It exists only once in a SAP HANA Instance and is administrated via the System Database. More information can be found in the SAP HANA Admin Guide.

I am using SAP HANA 2.0 Express in a VM Ware Container.

How to download & install SAP HANA Express is explained in this Youtube-Video

I am using the Package “Server only virtual machine”.

To be able to administrate the Web Dispatcher of SAP HANA a small configuration change needs to be done. It is also explained in SAP Note 2107899 – HANA Web Dispatcher – Multi DB – Access to Administration UI is restricted to System DB users

Required Configuration

Logon to the System Database in SAP HANA Studio and navigate to the Configuration Tab.

SID is SYS. Now, filter for string enable_admin_ui.

Change $(SAPSYSTEMNAME) to SYS. Save the parameter and restart the Service. I restart the database using “HDB stop” and “HDB start” as user hxeadm.

Required Authorizations

Grant role “sap.hana.xs.wdisp.admin::WebDispatcherAdmin” to provide Administrator rights.

Statements are:

— Create Administrator for Webdispatcher
create user wdisp_admin password Abcd12345 NO FORCE_FIRST_PASSWORD_CHANGE;

— Grant Admin Role
call _SYS_REPO.GRANT_ACTIVATED_ROLE (‘sap.hana.xs.wdisp.admin::WebDispatcherAdmin’, ‘WDISP_ADMIN’);

URL

The URLs of Web Dispatcher are:

http://hxehost:8090/sap/hana/xs/wdisp/admin/

https://hxehost:4390/sap/hana/xs/wdisp/admin/

When you see this:

Go back to Required Configuration. This is due to a wrong configuration, not about missing privileges.

Instead you should see the following.

Login was successful.

That’s it, thank you very much, please like and subscribe Feel free to leave a comment..

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Bruno Marcos

    Great! It has worked perfectly for me. Now, I can open the web dispatcher in my hana express edition.

    Could you explain why did you make this modification = “Change $(SAPSYSTEMNAME) to SYS”. What does it means?

     

    Tks a lot

     

    (0) 
    1. Stefan Seemann Post author

      Hello Bruno,

      thank you very much. Refering to note  2107899 , The parameter has to be set to the value that represents the SystemDB.

      From the note:

      To enable the Web Dispatcher Administration specify which DB is the System DB by setting the parameter wdisp/enable_admin_ui_for_sid in webdispatcher.ini – [profile]. This parameter has to be set to the value of the subparameter SID of the wdisp/system_<xx> parameter that represents the System DB.

      Example:

      wdisp/system_0 = SID=SYS, EXTSRV=…, SRCVHOST=…  #This system represents the System DB
      wdisp/system_1 = SID=TN1, EXTSRV=.., SRCVHOST=…   # This system represents a Tenant DB
      wdisp/enable_admin_ui_for_sid = SYS    # Only users in the System DB that have the role  sap.hana.xs.wdisp.admin::WebDispatcherAdmin or …::WebDispatcherMonitor are authorized to access the Admin UI.

      As a consequence the identifier used in the SID subparameter of the wdisp/system that represents the System DB has to be unique.

      Best regards, Stefan

       

      (0) 

Leave a Reply