Skip to Content
0

Lumira 2.0 live connection to hana

Jun 07, 2017 at 10:12 AM

1.2k

avatar image
Former Member

Hi

We have installed Lumira 2.0 SPS 01 and want to try the live connection to HANA. I see that Lumira use XS engine, and Im not able to connect to our Hana express 2.0 sps 01 server. Im not sure if the connection string(server and port) is correct, or the user has the right premissions. Has anyone got this to work?

10 |10000 characters needed characters left characters exceeded
Former Member

screenshot..

capture.png (12.6 kB)
0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Matt Hawkins Jul 09, 2017 at 03:14 PM
0

Were you able to get this working? I have the same issue (works fine in Lumira 1.3.x).

Show 2 Share
10 |10000 characters needed characters left characters exceeded

I was able to resolve this by applying role sap.bc.ina.service.v2.userRole::INA_USER in Hana Studio as per SAP Note 2475496

0
Former Member

Nop, still not able to connect.

0
avatar image
Former Member Sep 01, 2017 at 11:34 AM
0
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 01, 2017 at 11:42 AM
0

Got it to work with HANA express 2.0 and SPS02 with ina addon

Make sure this url gives you information https://servername:4390/sap/bc/ina/service/v2/GetServerInfo

use this url in Lumira:

http://servername:8090

User : SYSTEM

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

one more thing...

Use the tenant database HXE not the system database.

0

Hi Former Member ,

I am having trouble connection Lumira to Hana Express Tenant DB (2.0 SPS02)

Here is my response from the GetServerInfo URL:

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

Is this wrong?

I can't access via the template url you advise: http://servername:8090

system user or development user both fail. but my error is unable to connect to database.

I have INA addon

0

Hello, I had the same problem, after SAP HANA EPM-MDS plugin installation, i get this repsonse from the GetServerInfo URL:

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

Both users fail ( system or development ) can you show us the steps to get this work?, thanks.

Regards

0
avatar image
Former Member
Nov 14, 2017 at 10:24 PM
0

The default port is 8000. So http://servername:8000

Share
10 |10000 characters needed characters left characters exceeded