Skip to Content

So you are trying to explore your models in HANA Express from Lumira or Analysis for Office but getting error  “InformationAccess Service GetResponse is not available. Install SAP HANA EPMMDS plugin.”

And you wonder why if before HANA 2.0 SPS01 you could do it without problems?

Wonder no more! The reason is that one of the components is no longer there as described by note 2456225.

In this blog post, I’m documenting the steps I followed to enable Information Access with the EPMMDS plugin in SAP HANA, express edition on my Google Cloud Platform machine.

Before we continue….

(I know, you want it back…not everybody has this access… it used to be there… life was great… this is all I can offer for now)

My HXE instance is on Google Cloud Platform, which I created using the launcher but the procedure should work for the other available flavors too.

Find out the version of your SAP HANA instance

As described by the note, you need to download the right EPMMDS plugin for your version of HXE. Log in to a console and use ./HDB version to find it out:

 

Find your version in the chart in this other note (2536153) and take note of name of the package you will need to download:

Download EPMMDS

Go to https://launchpad.support.sap.com/#/softwarecenter/search/EPMMDS and download the plugin file for your version as described in the chart above.

If you cannot see the results, you might want to check the warning at the top of this post. 

Install EPMMDS

Goes without saying, my next step was to wait until the package was uploaded into my GCP instance.  Very cool stuff, like TechEd Bangalore, happened in the meantime.

Once uploaded, extract the file with the SAPCAR tool and take note of the location where you are extracting the file (in my case, the upload is into my home folder)

sudo /usr/sap/hostctrl/exe/SAPCAR -xvf <<name of the package you have uploaded>>

Switch to hxeadm (sudo su – hxeadm), go back into the directory where SAP_HANA_EPM-MDS was extracted (cd /somedirectory/SAP_HANA_EPM-MDS/) and execute ./hdbinst from inside the newly created directory:

Wait for the installation to finish. You should get the most inspirational message for the day, installation done

You can try to test it using URL  http://your_IP Address:80XX/sap/bc/ina/service/v2/GetServerInfo  (Where XX is the instance number, 90 is the default). You should get error “Request execution failed due to missing privileges “.

You will need to assign the INA_USER  role to the user that will be connecting (I’ll show this below). If you have already done this and try again, you will still get an error who does not want to be an error:  “No servers are available. Error: No error”

We´ll solve this… keep going…

Configure the tenant database

You need a tenant database to solve the error with a personality disorder. HXE instances bring a tenant DB up and running by default. I sometimes stop them to free up RAM.  There is a tutorial on how to create a tenant here if you need it, too.

If, like me, you stopped the default tenant database called HXE, you can just use the following to get it back up:

ALTER SYSTEM START DATABASE HXE;

I’m doing this from the SSH console with hdbsql, but any SQL client you have works. You don’t need to do this if you never stopped the tenant DB that comes by default.

You will need to access the XS engine in the tenant database. I changed the configuration in the webdispatcher  as follows. There’s more information about this on the help. Run the following from your SYSTEMDB as SYSTEM (or similar):

 

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', 'HXE') SET ('public_urls', 'http_url') = 'http://hxe.hxehost:8090' WITH RECONFIGURE;

ALTER SYSTEM ALTER CONFIGURATION ('xsengine.ini', 'database', 'HXE') SET ('public_urls', 'https_url') = 'https://hxe.hxehost:4390' WITH RECONFIGURE;

(Replace “90” with the proper instance number if your instance number is not 90 and “HXE” with the right name for your tenant DB ).

While you have the SSH console open and if you haven’t already, you can also grant the proper permissions to the user that will be connecting from the tenant DB, quit and log in to the tenant DB first:

hdbsql -i 90 -d HXE -u SYSTEM
call GRANT_ACTIVATED_ROLE('sap.bc.ina.service.v2.userRole::INA_USER','THE_USER_YOU_WILL_USING');

I already had a user called INAUSER in my tenant db (HXE), so this is what it looks like:

Remember to map the hosts file to the new configuration in the webdispatcher:

Test it!

Use the following URL:

http://hxe.hxehost:8090/sap/bc/ina/service/v2/GetResponse?Request={"Metadata":{"Expand":["Cubes"]}}

And you should get something like:

I will show how to consume Calculation Views created in XS Advanced via Information Access in a future post (coming soon).

In the meantime, we can stay in touch on  or on LinkedIn

 

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. Aldo Ruiz Wong

    Hello Lucia,

    First of all I want to thank you for your help to make this scenario work.

    I have followed all the steps using a new instance of HXE.ova VM (Server only virtual machine), but I am getting some problems at the final step:

    This is the version of my VM, I think we are working at the same environement:

    I get these messages at the final test:

    1. http://hxehost:8090/sap/bc/ina/service/v2/GetServerInfo2 -> I get this message: {“error”:{“code”:10,”message”:”‘GetServerInfo2’: undefined function import or entity set”}}2. https://hxehost:4390/sap/bc/ina/service/v2/GetResponse?Request={Metadata:{Expand:[Cubes]}} -> I get this message: {“error”:{“code”:14,”message”:”ina: Parameter ‘Request’ could not be parsed”}}3. https://hxe.hxehost:4390/sap/bc/ina/service/v2/GetResponse?Request={Metadata:{Expand:[Cubes]}} -> It does not recognize the user and password

    I created a new user “LUMIRA” and the only granted role is “sap.bc.ina.service.v2.userRole::INA_USER”

    What could I have done wrong?

    Regards

    (0) 
    1. Lucia Subatin Post author

      Hi Aldo,  

      The 3rd option should be the right one and yes, we are using the same revision of HXE.

      The INAUSER I created has many more authorizations and I could log in to the tenant DB using hdbsql  (hdbsql -i 90 -d HXE). Have you tried that with the user you created yet?

      Maybe you could add the role to your tenant’s SYSTEM user temporarily and try with that one to rule out authorization problems.

      Cheers,

      Lucía.

      (0) 
      1. Aldo Ruiz Wong

        Hello Lucia,

        I can’t log in using hdbsql with the user “LUMIRA”, maybe there are permissions missing since I only added the role sap.bc.ina.service.v2.userRole::INA_USER

        But I can login in eclipse:

        I added the “sap.bc.ina.service.v2.userRole::INA_USER” role to user “SYSTEM” and I get this message when I check the URL https://hxe.hxehost:4390/sap/bc/ina/service/v2/GetResponse?Request={Metadata:{Expand:[Cubes]}}

        The problem may be the permissions that the user has?

        Thank You

        (0) 
        1. Lucia Subatin Post author

          Hi Aldo,

          I see the user Lumira is logged in to the systemDB in your screenshot. It has to be created and granted the Ina role in the tenant, HXE. Same applies with the SYSTEM user, the permissions need to be granted in the tenant HXE, and of course use the password for SYSTEM on the tenant.

          Cheers,

          Lucía.

          (0) 
          1. Aldo Ruiz Wong

            Hello Lucia,

            Yes, I was woking in the systemDB instead HXE, now that I have created the user Lumira in the tenant HXE and I added the role sap.bc.ina.service.v2.userRole::INA_USER to user Lumira I get this message when I check the URL https://hxe.hxehost:4390/sap/bc/ina/service/v2/GetResponse?Request={Metadata:{Expand:[Cubes]}} : {“error”:{“code”:14,”message”:”ina: Parameter ‘Request’ could not be parsed”}}

            I added the role sap.bc.ina.service.v2.userRole::INA_USER to SYSTEM and I get the same message.

            Regards

            (0) 
      1. Matthew Wong

        Hi Lucia, after a successful Live Data Connection in Lumira 2.0, when I add a dimension or measure to the chart, Lumira shows the 3 dots thinking and just hangs there infinitely. Did you ever experience this with your calculation views?

        –Matt

        (0) 

Leave a Reply