Skip to Content

Error in building HDB in Tenant DB

Oct 26, 2017 at 06:46 PM


avatar image


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:



Those didn't work either.

Appreciate your help.

Thanks and kind regards.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ana Neis Oct 27, 2017 at 03:12 PM

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.

10 |10000 characters needed characters left characters exceeded