[User Provided Service in Cloud Foundry] Multiple HANA instance in same space,

[former_member617538]

Hi,

I have two HANA instance in the same space. How do i define my User Provided service in Cloud Foundry to point to the correct instance?

I am getting the authentication failure when I create a grantor service in my HDI development in WebIDE:

2:06:18 PM (HDB) Error: authentication failed
grantor service: "RS_ACCESS2", type: "sql", user: "RS_ACCESS"
file name: src/cfg/grants.hdbgrants

User Provided Service definition "RS_ACCESS2" :

{ "user": "RS_ACCESS", "password": "xxxx", "schema": "xxx", "tags": "[ \"hana\" ]" }

The user account is active and the password is correct. I have successfully use the account to log in to the DB explorer.

Has anyone encountered this error before?

Thanks & Regards,

Mark

[former_member617538]

Hi varun_bhargav18 ,

You will need to specify the database_id in your mta.yaml file:

resources:

- name: hdi_db

properties:

hdi-container-name: '${service-name}'

type: com.sap.xs.hdi-container

parameters:

service-name: _hdi

config:

database_id: xxxxxx

[former_member743230]

Hi markching2 ,

hope you have resolved this issue by now and it would be really helpful if you can share the solutions as I am facing the similar error.

Thanks and Regards,

Varun

[pfefferf]

In your user-provided service definition I miss the hostname, port and driver information (like described here, under point 6).

[former_member617538]

Hi Florian,

Thanks for the reply!

I am using HANA-as-a-Service and i tried using the Direct SQL Connectivity Endpoint as the host and port number.

But i am getting this error when i tried to build the grantor service:

Error: only secure connections are allowed
grantor service: "RS_ACCESS2", type: "sql", user: "RS_ACCESS"
file name: src/cfg/grants.hdbgrants

I can't find any documentation on which driver to use to connect to HANA-as-a-Service. Do you know what is the correct driver to use?

Thanks & Regards,

Mark