[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