How to enable SAP HANA Web-based Development Workbench in SAP HANA, express edition for Multiple Databases

Task

Configure SAP HANA Web-based Development Workbench in SAP HANA, express edition for Multiple Databases (SYSTEMDB and additional Tenant DB).

Reason of the Article

First try we are not able to access the SAP HANA Web-based Development Workbench on the preconfigured SAP HANA Express Edition Server + applications virtual machine. If we add new tenant database or we would like to use SAP HANA Web-based Development Workbench connected to the SYSTEMDB we need to do additional configuration steps also. There are some documentations available which can be used to achieve the task. The aim of this article to collect these sites together and complete the available information with important details. Also, this is a step-by-step guide which goes through the process.

IMPORTANT!

SAP HANA Web-based Development Workbench and some components belongs to SAP HANA extended application services, classic model (XS classic) which will be deprecated in the future. Until they are supported, we can use them, but the recommendation is to use the SAP HANA extended application services, advanced model (XS advanced).

2465027 – Deprecation of SAP HANA extended application services, classic model and SAP HANA Repository

Architecture

In my scenario I am using Windows 10 operating system on my laptop. I am running SAP HANA, express edition (preconfigured) Server + applications virtual machine on VMware Workstation.

• Frequently Asked Questions About SAP HANA®, Express Edition
• Server + Applications: SAP HANA, express edition and XSA – by the SAP HANA Academy
• SAP Help Portal – SAP HANA, express edition
• SAP Help Portal – Getting Started with SAP HANA 2.0, express edition (Virtual Machine Method)
• SAP Help Portal – Getting Started with SAP HANA 2.0, express edition (Virtual Machine Method) – PDF

Prerequisites

• Hypervisor (VMware Workstation Player 16)
• SAP HANA, express edition (Version: 2.00.057)
  Install SAP HANA 2.0, express edition on a Preconfigured Virtual Machine (with SAP HANA XS Advanced)
• SAP HANA Studio (Version: 2.3.63)

Configure the SAP HANA Web-based Development Workbench

The preconfigured SAP HANA, express edition use instance number 90 by default.

Check the XSEngine service:

http://<hostname>:80<instance>
https://<hostname>:43<instance>

http://hxehost:8090/
https://hxehost:4390/

Check the SAP HANA Web-based Development Workbench:

http://<hostname>:80<instance>/sap/hana/ide

http://hxehost:8090/sap/hana/ide

To solve the issue, we need to follow the next configuration steps:

3030464 – How to Configure HANA Web-based Development Workbench for Multiple Databases

In case of the SAP HANA, express edition (preconfigured) Server + applications virtual machine the HXE database has all the necessary DU (Delivery Unit) to able to do the configuration.

Process Step 1 and Step 2 accordingly based on the referred KBA. SYSTEM user can be used if it is not disabled. Ensure the appropriate roles have been assigned to the user. If other database (than HXE) also will be used roles need to be assigned to the user in that particular database too (e.g. SYSTEMDB, TDB). Required RolesStep 3

Setup the URL for the HXE database.

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') SET ('public_urls', 'http_url') = 'http://hxehost:8090' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') SET ('public_urls', 'https_url') = 'https://hxehost:4390' WITH RECONFIGURE;

Step 4

As the documentation describes in this step do the virtual host creation on the machine where the web browser is being used (if it was not done before).

C:\Windows\System32\drivers\etc\hosts

“Add to a new virtual host(s) to the DNS server or /etc/hosts files on HANA host and the machine that the Web Browser is being run on.”

Connect to the SAP HANA Web-based Development Workbench again and test if it is working:

http://hxehost:8090/sap/hana/ide

Process Step 5 and Step 6 accordingly based on the KBA (to setup SAP HANA Web-based Development Workbench connected to SYSTEMDB).

Setup the URL for the SYSTEMDB database.

ALTER SYSTEM ALTER CONFIGURATION ('nameserver.ini', 'SYSTEM') SET ('public_urls', 'http_url') = 'http://hxehost2:8090' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('nameserver.ini', 'SYSTEM') SET ('public_urls', 'https_url') = 'https://hxehost2:4390' WITH RECONFIGURE;

Additional step to configure the other tenant database also (TDB).

Setup the URL for the TDB database.

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') SET ('public_urls', 'http_url') = 'http://hxehost3:8090' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'SYSTEM') SET ('public_urls', 'https_url') = 'https://hxehost3:4390' WITH RECONFIGURE;

After all configuration the SYSTEMDB webdispatcher.ini shows the next:

Test the SAP HANA Web-based Development Workbench connected to different databases

Check the XSEngine services:
http://hxehost:8090/
http://hxehost2:8090/
http://hxehost3:8090/

Check the SAP HANA Web-based Development Workbench:
http://hxehost:8090/sap/hana/ide
http://hxehost2:8090/sap/hana/ide
http://hxehost3:8090/sap/hana/ide

In case of the SYSTEMDB and the additional Tenant DB (TBD) host the error still occurs.

Identify what else are missing

2410085 – Access to HANA XS Engine based application URL fails with error 404 – Not found

In case of the SAP HANA, express edition (preconfigured) Server + applications virtual machine the HXE database has all the necessary DU (Delivery Unit). SYSTEMDB and newly added Tenant DB need to import the missing Delivery Units.

Compare the available DU (Delivery Unit) in case of the databases based on the KBA

2182103 – Troubleshooting HTTP Access in Multitenant Database Containers

SELECT * FROM "_SYS_REPO"."DELIVERY_UNITS" ORDER BY DELIVERY_UNIT

Import missing DU (Delivery Unit) to SYSTEMDB and Tenant DB based on the KBA

2124191 – Lumira Server: The web page is not found (HTTP 404 error) when accessing the SAP Lumira Server

In my case the following DUs were missing from SYSTEMDB and Tenant DB.

• HANA_IDE_CORE
• HANA_XS_IDE
• HANA_XS_EDITOR
• HDC_IDE_CORE
• SAP_WATT

Check if everything is working

Check the SAP HANA Web-based Development Workbench URLs again (one-by-one):

http://hxehost:8090/sap/hana/ide

http://hxehost2:8090/sap/hana/ide

http://hxehost3:8090/sap/hana/ide

All URLs are working properly and connects to different databases.

Conclusion

In a Multitenant Database Container environment, we can configure SAP HANA Web-based Development Workbench to connects to the different databases (HXE, SYSTEMDB, TDB).

Required setup:

• Roles
• URLs
• DUs (Delivery Units)

See Also

SAP HANA 2.0 Express Edition | URLs, Permissions and Configuration for the Web-based Development Workbench

Question

Q&A link for SAP HANA, express edition: https://answers.sap.com/tags/73555000100800000651