Can you run HANA Express 2.0 without XSA?

[former_member49791]

Hi,

We recently identified an Out of Memory (OOM) issue with our SAP HANA Express Edition. This was causing the server to crash frequently bringing HANA down along with it. Through OS monitoring we were able to identify XSA was the culprit (java OS processes - memory and CPU spiking).

We have since stopped XSA ("XSA disable" command), which has temporarily fixed the issue.

I believe the root cause of the OOM issue is a software bug in XSA that we need to patch our version of XSA to fix (SAP Note 2949526).

However in the meantime is it OK to run HANA 2.0 with XSA offline? I know that we will lose functionality like the XSA HANA DBA Cockpit, but is there any other critical XSA HANA functionality that we will lose that HANA requires to function as a database?

We do not use XSA for custom app development, it just came bundled with our version of HANA Express:

2.00.036.00.1547699771 (fa/hana2sp03), XSA: v1.0.101

[pfefferf · Accepted solution]

XSA is an optional component.

SAP HANA, Express Edition is offered in a "server-only" edition too (can be selected in the HXE downloader). It comes with a smaller download and memory footprint.

[former_member49791 · Accepted solution]

Would you recommend uninstalling XSA if we are not going to use it? (or just leave XSA disabled).

[pfefferf · Accepted solution]

Uninstalling does not bring you any advantage in regarding the RAM footprint.

But in general, if you do not need it, I would go with the server-only edition.

[dvankempen]

Hi Tony,

Florian already answered your question; unlike XS classic, XS advanced model is an additional and optional component. You can uninstall the components with the HDBLCM installation tool.

As you also already mentioned the consequence is that all client tools that rely on this built-in application server are no longer available, like SAP HANA cockpit and the database explorer. There are several stand-alone JDBC/ODBC tools you could use as alternative.

Should you wish to continue using the HANA Deployment Infrastructure (HDI) functionality to deploy design-time artifacts to runtime catalog objects, you can do as explained by thomas.jung. HDI and XSA are related but have no dependencies.

• https://blogs.sap.com/2019/04/16/developing-with-hana-deployment-infrastructure-hdi-without-xsacf-or...

[former_member49791]

Thank you Denys.