cancel
Showing results for 
Search instead for 
Did you mean: 

Error in building HDB in Tenant DB

amneis
Participant
0 Kudos
267

Hello,

So this is in HANA Express 2.0 SPS02 Revision 21 which was released a few weeks ago.

I mapped both tenant databases HXE and WORKSHOP to the development space.

I got this error message when I tried to build an HDB module in WebIDE.

The system couldn't find the schema, HANA5_USR, because there were multiple databases (HXE and WORKSHOP) in the development space. It says "exact id needs to be specified". What does it mean by "exact id"? I checked the _SYS tables, the schema name used is HANA5_USR. I did not find any other name or id for that schema. I tried using the following parameters for schema in the mta.yaml file:

WORKSHOP:HANA5_USR

/HXEHOST:90:WORKSHOP:HANA5_USR

Those didn't work either.

Appreciate your help.

Thanks and kind regards.

Accepted Solutions (0)

Answers (1)

Answers (1)

amneis
Participant
0 Kudos

Fixed it. I set the WORKLOAD database as DEFAULT and it worked. Tiny details make a mess. 🙂 The message about the default access role will be fixed after I create the default-access_role.hdbrole.