SAP HANA Express VM Getting Started
This page contains instructions on how to set up SAP HANA Express Edition Virtual Machine for development and use of SAP training material.
Applies to SAP HANA Express Edition 2.0 SPS03 and SPS03
Most important step in order to prevent build errors afterwards is to Activate Tenant Database
Setup Environment
Activate Tenant Database
- Login to SAP HANA XS Advanced Cockpit, probably at https://hxehost:51036/cockpit#/xsa/overview
- Go to Tenant Databases
- For Tenant Database HXE Click on Button Activate -> Enter Master Password
- Map Database to Organization HANAExpress and Space development. Activate default checkbox
- Click Save
Database Explorer
Find database SQL port numbers starting from the system database:
SELECT DATABASE_NAME, SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS_DATABASES.M_SERVICES WHERE DATABASE_NAME='<DBNAME>' and ((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NAME='xsengine'))
Add System Database
- Login to SAP Web IDE (Use XSA_DEV)
- Go to Database Explorer and click on "+"
- Select Database Type SAP HANA Database (Multitenant)
- Enter values as follows:
- Host: localhost or server name
- Instance Number: 90
- Port Number: 39013
- Database: System Database
- User -> System
- Passwort -> Master Password
- Click on OK
Add Tenant Database
- Login to SAP Web IDE (Use XSA_DEV)
- Go to Database Explorer and click on "+"
- Select Database Type SAP HANA Database (Multitenant)
- Enter values as follows:
- Host: localhost or server name
- Instance Number: 90
- Port Number: 39015
- Database: Tenant Database HXE
- User -> System
- Passwort -> Master Password
- Click on OK
Web IDE
Clone Project
- Clone from desired repository
- Open Project Settings -> Open section Space
- Set space to development
- Click on Save
Install Demodata
SFLIGHT
- Download https://github.com/SAP/hana-xsa-opensap-hana7/raw/snippets_2.3.2/ex2/sflight_hana.tar.gz
- Open Web IDE
- Go to Database Explorer
- Open System Database
- Right-Click on Catalog and select Import Catalog Objects
- Enter values as follows:
- Import objects from -> local computer
- Local archive (*.tar.gz) -> Select file downloaded above
- Activate Include dependencies and Include table data
- Number of parallel threads -> 2
- Click on OK
SQL Commands in Tenant (Needed for Exercise 2.6):
CREATE USER CUPS_SFLIGHT PASSWORD "<Password>" SET PARAMETER CLIENT = '001';
ALTER USER CUPS_SFLIGHT DISABLE PASSWORD LIFETIME;
GRANT SELECT ON SCHEMA SFLIGHT TO CUPS_SFLIGHT WITH GRANT OPTION;
GRANT SELECT METADATA ON SCHEMA SFLIGHT to CUPS_SFLIGHT WITH GRANT OPTION;
CREATE ROLE SFLIGHT_CONTAINER_ACCESS; GRANT SELECT, SELECT METADATA ON SCHEMA SFLIGHT TO SFLIGHT_CONTAINER_ACCESS WITH GRANT OPTION; GRANT SFLIGHT_CONTAINER_ACCESS TO CUPS_SFLIGHT WITH ADMIN OPTION;
Central DB
Install CentralDB MTAR (Needed for Exercise 2.8): In this exercise, we will configure access and synonyms between our local project container and an already existing container deployed on this system. In order to perform this exercise in your own system, you will have to first download and deploy (with the –use-namespaces option) this MTA into your development space from: https://github.com/SAP/hana-xsa-opensap-hana7/raw/snippets_2.3.2/ex2/openSAP.CentralDB_1.1.2019.mtar xs deploy help: https://help.sap.com/viewer/4505d0bdaf4948449b7f7379d24d0f0d/2.0.03/en-US/308f2041995c41a88bbb197cf2a984f7.html#loio308f2041995c41a88bbb197cf2a984f7__section_irt_3dc_zs
xs deploy openSAP.CentralDB_1.0.2019.mtar --use-namespaces
Create User Provided Services
XSA Commands: xs cups CROSS_SCHEMA_SFLIGHT -p "{\"host\":\"<hostname>\",\"port\":\"3##<15|13>\",\"user\":\"CUPS_SFLIGHT\",\"password\":\"<Password>\",\"driver\":\"com.sap.db.jdbc.Driver\",\"tags\":[\"hana\"] , \"schema\" : \"SFLIGHT\" }"
xs cups sap.hana.democontent.epm.services.images -p "{\"host\":\"www.loc.gov\",\"port\":\"80\",\"tags\":[\"xshttpdest\"] }"
Create Further Services
xs create-service xsuaa space openSAP-ex-uaa -c xs-security.json
xs create-service auditlog free openSAP-ex-log
xs create-service sapui5_sb sapui5-1.52 openSAP-ui5
Create XS Advanced Roles
xs create-role openSAPHANA-ex Viewer Viewer_300 -a "{\"client\":{\"value\":\"300\",\"source\":\"static\"},\"country\":{\"value\":\"US\",\"source\":\"static\"}}"
xs create-role openSAPHANA-ex Editor Editor_300 -a "{\"client\":{\"value\":\"300\",\"source\":\"static\"}}"
Build DB sequence
Build zunächst user-db dann die core-db / db.
Trouble Shooting
Build of DB fails with invalid user name
Error Message
Using grantor service "ServiceName_1" of type "sql" Error: Error executing: GRANT "SFLIGHT_CONTAINER_ACCESS" TO "OPENSAPHANA_OPENSAPHANA_HDI_CONTAINER_1#OO"; (nested message: invalid user name: OPENSAPHANA_OPENSAPHANA_HDI_CONTAINER_1#OO: line 1 col 37 (at pos 36)) grantor service: "ServiceName_1", type: "sql", user: "CUPS_SFLIGHT" file name: cfg/SFLIGHT.hdbgrants
Root Cause
User name OPENSAPHANA_OPENSAPHANA_HDI_CONTAINER_1#OO was created in a different tenant database, i.e. SYSTEM instead of HXE.
The HXE tenant database has to be activated and mapped as default in the VM first. If this is not the case any created projects will create users in SYSTEM database instead of the development tenant database.
Fix
No fix known besides to dropping the VM entirely and setup again and following the steps above Setup Environment
Build of DB fails
Error Message
20:27:30 (DIBuild) Processing "cfg/central.hdbgrants"... ok Processing "cfg/user.hdbgrants"... Using grantor service "hdi-user-service" of type "hdi" Granting schema roles in the container "OPENSAP_HANA_USER_00_1" and the parameters "[]"... Granting the schema role "user#" to the principal "OPENSAPHANA_OPENSAPHANA_DB_HDI_CONTAINER_1#OO" in the schema "" with grant option = "false" Error: Database error 389: : invalid role name: user#: line 1 col 7 (at pos 6) [8201003] Error: Granting schema roles in the container "OPENSAP_HANA_USER_00_1" and the parameters "[]"... failed [8214221]Error: Error executing: CALL "OPENSAP_HANA_USER_00_1#DI".GRANT_CONTAINER_SCHEMA_ROLES(#CONTAINER_ROLES, #CONTAINER_ROLES_PARAMETERS, ?, ?, ?); (nested message: HDI call failed)grantor service: "hdi-user-service", type: "hdi", user: "OPENSAP_HANA_USER_00_1_BVB0FJGXOQE559VFZERVZC3S1_DT" (hdi_user)file name: cfg/user.hdbgrants
Root Cause
Missing User DB.
Fix
Build User DB first.
