How to connect SAP HANA 2.0 express with SAP Lumira 2.0 ?

[former_member355591]

Hello

When I try to access SAP HANA 2.0 SP02 Live Views using Lumira 2.0 SP02 Discovery, Lumira cannot reach SAP HANA express 2.0 SP02: I get the message “Unable to connect to http://hxehost:8090”

When I was deploying the INA Service I got this message with the GetServerInfo URL

https://hxehost:4390/sap/bc/ina/service/v2/GetServerInfo :

{
“Messages”: [
{
“Number”: 42001,
“Type”: 2,
“Text”: “InformationAccess Service GetServerInfo is not available. Install the SAP HANA EPM-MDS plugin.”
}
]
}

Once I installed the SAP HANA EPM-MDS plugin, I get this message:

{
“Grids”: [],
“ItemLists”: [],
“Messages”: [{
“Number”: 200,
“Text”: “No servers are available. Error: No error”,
“Type”: 2
}]
}

Im still getting the message “Unable to connect to http://hxehost:8090” when I try to connect from Lumira 2.0 SP02. Can someone tell me what is missing?.
Thanks.

Regards

[thomas_jung · Accepted solution]

HANA Live View requires the INA interface which in turn require the EPM-MDS plug-in as of HANA 2.0. Unfortunately the current version of SAP HANA Express Edition does not come with the EPM-MDS plug-in. If you have a full license for HANA as well, you can download this EPM-MDS plug-in from the software download center of the Service Marketplace and install it with hdblcm.

[former_member355591 · Accepted solution]

Hello Thomas,

I have already installed the SAP HANA EPM-MDS plugin from the Service Marketplace "SAP HANA EPM-MDS 1.0 (SUPPORT PACKAGES AND PATCHES)", I used the file:

IMDB_EPMMDS_2020P_4-80002211.SAR EPMMDS Rev 20.4 only for HANA 2.0 Rev 20

I dont understand why I am getting this message when I check the GetServerInfo URL ( https://hxehost:4390/sap/bc/ina/service/v2/GetServerInfo ) :

{
“Grids”: [],
“ItemLists”: [],
“Messages”: [{
“Number”: 200,
“Text”: “No servers are available. Error: No error”,
“Type”: 2
}]
}

This can't work with SAP HANA 2.0 Express Edition?, it looks like some other services are missing.

Should I use a new installation of SAP HANA instead Express Edition?

Thank your for your help.

Regards

[thomas_jung · Accepted solution]

This error has to do with the MDC configuration and the XSEngine. I got this error as well recently when setting up this scenario and had to make sure that XSEngine was properly configured on my tenant DB as well.

[former_member355591 · Accepted solution]

Hi Thomas, how can i make sure that the XSEngine is properly configured on the tenant DB? I am working with the VM SAP HANA 2.0 Express Edition, we might have the same configuration. Did you make this scenario work?

I was searching for a guide to set up this, but I did not find anything to solve this.

Thank you very much for your help,

Regards

[thomas_jung · Accepted solution]

I'd recommend having a look at this blog: https://blogs.sap.com/2014/12/09/hide-and-seek-in-xsengine-expose-http-access-to-multitenant-databas...

[thomas_jung · Accepted solution]

Actually I just spoke to @Lucia Subatin and she had the same issue on HXE. Her HXE is more "pure" than mine since I installed from the binaries. In her system the first tenant was disabled. It had to be re-enabled via SQL: ALTER SYSTEM START DATABASE <database_name>. In my system I'd gone a step further and initially deactived the web dispatcher for the entire XSEngine and also had to re-enable it for the tenant after restarting it. After speaking to Lucia, I don't believe that in standard HXE that extra step will be necessary, but you have the instructions in the blog link above if so.

[lsubatin · Accepted solution]

Hi, I had taken screenshots of my setup process for HANA Express on GCP so here's a blog on what I did to make it work: https://blogs.sap.com/2017/11/02/configure-information-access-in-hana-express-to-connect-from-lumira...

[former_member355591 · Accepted solution]

Thank You Lucia, I will follow those steps.

[former_member355591 · Accepted solution]

Hello Thomas, I've just seen that Lucia has done the configuration, I will try those steps. Thank you for all your assistance.