Error in building HDB in Tenant DB

[amneis]

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.

[amneis]

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.