Skip to Content
avatar image
Former Member

Error while validating the Attribute View

Hi Experts,

I have created a table and used that table in the attribute view.I made one of the colums as Key attribute in the Semantic Layer. When I am validating the Attribute View . I am getting the below error .

  • Repository: Activation failed for at least one object;At least one runtime reported an error during activation. Please see CheckResults for details
    • Activation is performed with activation mode Check only.
    • Sales_Analysis.SALES_ATTR_VIEW
      • Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Attribute View: SQL: transaction rolled back by an internal error: insufficient privilege: Not authorizednCreate view DDL statement: CREATE COLUMN VIEW "_SYS_BIC"."Sales_Analysis/SALES_ATTR_VIEW" TYPE JOIN WITH PARAMETERS ( joinIndex = "Sales-Product"."REGION", joinIndexType = 0, viewAttribute = ('REGION_ID', "Sales-Product"."REGION", "REGION_ID", '', 'default', 'attribute', '', 'Sales_Analysis/SALES_ATTR_VIEW$REGION_ID'), viewAttribute = ('REGION_NAME', "Sales-Product"."REGION", "REGION_NAME", '', 'default', 'attribute', '', 'Sales_Analysis/SALES_ATTR_VIEW$REGION_NAME'), viewAttribute = ('SUB_REGION_NAME', "Sales-Product"."REGION", "SUB_REGION_NAME", '', 'default', 'attribute', '', 'Sales_Analysis/SALES_ATTR_VIEW$SUB_REGION_NAME'), view = ('V_REGION', "Sales-Product"."REGION"), defaultView = 'V_REGION', 'REGISTERVIEWFORAPCHECK' = '1' ) NO STRUCTURED PRIVILEGE CHECKn
      • Attribute deployment started: Sales_Analysis/SALES_ATTR_VIEW timestamp: 2014-12-24,11:05:14.348
      • Removing BIMC records for

Appreciate your help on this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 24, 2014 at 07:42 AM

    Hi,

    if "_SYS_REPO" user doesn't have "select" privilege on your schema, you will get this error while validation of view.

    Please fallow below procedure:

    1. go to security node of your HANA DB-->user-->

    2. click on _SYS_REPO user

    3. go to object Privilege tab

    4. add either your schema or table then provide select privilege on it.

    now try to validate your view again. Validation will go through now.

    regards,

    sai Krishna.

    Add comment
    10|10000 characters needed characters exceeded