Installation of XSA runtime and WEBIDE on top of HANA Tenant Database #ATR

[AJAYTR_ATR66]

Disclaimer: WEBIDE is discontinued now. User can use BAS instead of WEBIDE.

Welcome to #ATR blogs (2)

Informative Note: Created this blog to provide information on how to install XS Advanced Runtime on top of HANA Tenant Database (RHEL) with WEBIDE Application.

Prerequisites - Knowledge on HANA Database, Unzipping SAR file, SAP Software download center, Running hdblcm.

XSA and it’s applications (WEBIDE, COCKPIT, etc.,.) can be installed on top of HANA Database. Usually, Business users will seek WEBIDE XSA application mostly for their development purposes which comes with XSA.

General SAP XSA Installation blog:

https://help.sap.com/docs/SAP_HANA_PLATFORM/2c1988d620e04368aa4103bf26f17727/30edce93cbf74613af66742...

 

PREREQUISITES:

1)  XSA Compatibility on top of your HANA Database

XSA is backward compatible. Hence, Newer XSA version will be supported on older HANA version. We can use any of the HANA Database SPS 05,06,07 accordingly.

Refer - https://me.sap.com/notes/2347931 - XSA compatibility

2) RPM package - Error

Install corresponding compat-sap-c++ version rpm file accordingly. You can find library information from note 2347931 -> 3410050.

At least libstdc++.so.6.0.21 (GLIBCXX_3.4.21 and GLIBC 2.14). On RHEL 7 systems, you can install the compat-sap-c++ 5 package. Prefer to use SAP HANA Database installed on RHEL 8/9.

Usually, Above package will be already available in OS since it's one of the prerequisites while installing HANA Database.

Error  "You will face library sync error - /lib64/libstdc++.so.6: version `GLIBCXX_3.4.26' not found"

Solution: https://access.redhat.com/solutions/6985203 - Establish a link (sync)

3) Mdcdispatcher file permission error

2601631 - SAP HANA XS Advanced xscontroller startup failed with error "hdbmdcdispatcher must be executed as root" - (1)

Error " Output line 35: [06] Checking mdcdispatcher availability
Output line 36: [06] ERROR: FAILED to connect to mdcdispatcher file socket when starting proccess '[echo, Detecting HANA hdbmdcdispatcher XSA process creation mode...]' (mdc process group exists: true)
Output line 37: [06] ERROR: hdbmdcdispatcher stdout: uid: 1004
Output line 38: gid: 79
Output line 39: sid: H51 userId: 1004 groupId: 79 sapsys: 0 mask: 384
Output line 40: ERROR: hdbmdcdispatcher must be executed as root (UserId: 1004). Check s-bit on hdbmdcdispatcher or mount options on filesystem
Output line 41: [06] ERROR: hdbmdcdispatcher stderr:
Output line 42: [06] ERROR: Exit code of hdbmdcdispatcher process: 13
Output line 43: [06] ERROR: Failed to connect to local file socket "/var/lib/hdb/SID/ipc/hdbmdcdispatcher.3575394" within timeout of 30 sec."

Solution: XSA will be installed but its components (hrtt, web ide) will fail to install. While checking, it's due to file permission error. XS will use mdcdispatcher service for connectivity and user managements. File permission was not set correctly in mdcdispatcher. Hence, it can't able to install any components. xs_worker service and end point port won;t work. Comment -  'mdcdispatcher needs to be executed with root 1004' even though we have run hdblcm with root user.

Give full permission for mdc folder and hdbmdcdispatcher file - /usr/sap/H51/HDB02/exe/mdc. If mounted with NFS, unmount and remount with "-suid" .option.

Note: If you already installed XSA and stuck with file permission error while installing applications, uninstall XSA and start from scratch post file permission error resolution steps performed. This will help to reallocate memory and limits with correct value.

 

INSTALLATION:

Step 1: Download XSA software and unzip file.

XSA files will also be available from SAP HANA Database software as well.

Run hdblcm: ./hdblcm --component_medium=/hana/shared/HDB/hdblcm/HANASPS05forXSWEBDIDE --component_root=/hana/shared/HDB/hdblcm

You can also simply start hdblcm and locate XSA software directory.

No 7 - Install XS    [Note: I currently have only one tenant database. Hence, it automatically install XSA on that tenant. If multiple tenant database exists, you can select which tenant database XSA needs to be installed accordingly ]

(Recommended routing mode- Port)

(Select All components since web ide requires other components (hrtt, services, ui5) as an prerequisite)

Once installed, you can check XSA and it's application [Login with dbsidadm, Provide XSA_ADMIN password if requested]

command -> xs -v

WEBIDE

WEBIDE port - 53075

INFO:

1) Installing XSA will stop HANA database during installation process. You can stop HANA Database manually and proceed XSA installation to speedup process.

2) You can bind HANA Database update as well as XSA install/Update to avoid two downtimes.

3) You can use XSA Cockpit to create users and role collection (having roles). Once role collection created, you can assign it to created users.

Security -> Role Collections.

You need to assign WEBIDE roles to users for accessing WEBIDE Application.

4) You can increase Instances of any application if you face any slowness.

XSA Cockpit -> Home -> Org -> SAP -> Applications

5) On-Premise WEBIDE for HANA is pretty old. We have latest Business Application Studio (CF) and WEB IDE Full stack (Neo) applications in SAP BTP. It will have more features and options to work on ui5 development. On-Premise WEBIDE can be helpful for small dev projects which doesn't include ui5.

 

6) If you wish to install HANA Cockpit with XSA, make sure not to install any other components. It will result in application error. Have a dedicated system with HANA Cockpit and XSA alone.

 

#Thanks for Visiting !