Technical Articles
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;
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
Question
Q&A link for SAP HANA, express edition: https://answers.sap.com/tags/73555000100800000651
Hi ,
Where we get the localhost:<port number> during the configuration of multiple tenant DB's.
Please kindly provide the information.
Thank you.
Regards,
Venkatesh