Skip to Content
avatar image
Former Member

Error in building HDB in Tenant DB

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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.

    Add comment
    10|10000 characters needed characters exceeded