SAP HANA Model validation error - Index out of range

[venkataramana_paidi]

Hi,

Creating a simple Attribute View using the SYSTEM user.

1. Log on with SYSTEM

2. CREATE SCHEMA EFASHION

3. CREATE THE TABLES UNDER EFASHION

4. LOAD DATA INTO TABLES

5. GRANT SELECT ON SCHEMA EFASHION TO _SYS_REPO WITH GRANT OPTION

Whilst activating/validating the Attribute View, face the following error:

Repository: Activation failed for atleast one object; atleast one runtime reported an error during activation. Please see CheckResults for details

Repository: Encountered an error in repository run time extension : Index $IDX$out of range  [$BEG$, $END$]

Please help me to resolve this issue.

Thanks & Regards,

Ramana.

[Former Member]

Hi Venkat,

I have resolved this issue by converting the single container database to a multi-tenant database.

I would urge you to try the same if you are running Data Services on your HANA database.

This workaround seem to work for me.

Best Regards,

Asif.

[former_member226419]

How you resolved the same. i didnt get it.

[Prabhith]

Hi Former Member,,

What type of tables have you created under the EFASHION Schema?

BR

Prabhith

[venkataramana_paidi]

Hi Prabhith,

I have created the sample efashion schema tables  like article_color_lookup, article_lookup, article_lookup_criteria, calendar_year_lookup, outlet_lookup, production_promotion, promotion_lookup and shop_facts tables .

Thanks & Regards,

Ramana.

[Former Member]

Hi,

I too have the exact same issue and error.

The tables are created under the efashion schema using the SYSTEM user. The tables are created as "column" tables.

Regards,

Asif.

[former_member226419]

Are you joining your tables in your attribute view? is this exception is coming while activating your attribute view?

[Former Member]

There is no joining of tables in the attribute view.

The attribute view is simply selecting fields from a single ARTICLE_LOOKUP table.

The error is displayed whilst trying to save & validate the view & the same when trying to activate it.

I have also tried to restart the HANA database but still receiving this error.

Regards,

Asif.