Skip to Content

HANA Trial Cloud User does not have permission to create Analytic View

Hi,

I am facing issue to create analytic view with HCP trial user. I am getting below error.

  • Execute validation rules
    • Validation of p754360trial.gurihdb::V_CRIME_CITY
      • No rule selected
  • Activation ID: 166845 (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 cascade two-phases.
    • p754360trial.gurihdb::V_CRIME_CITY
      • Internal deployment of object failed;Repository :  Encountered an error in repository runtime extension;Internal Error:Deploy Analytic View: transaction rolled back by an internal error: insufficient privilege: Not authorized(46)SQL: transaction rolled back by an internal error: column store error: <?xml version="1.0" encoding="utf-8"?>
        <createCubeResult version="1.0">
        <status>
        <message>
        Error during executing SQL statement</message>
        <errorCode>
        2116</errorCode>
        </status>
        <details>
        <errors>
        <detail>
        <element>
        CREATE COLUMN VIEW "_SYS_BIC"."p754360trial.gurihdb/V_CRIME_CITY" WITH PARAMETERS (DESCRIPTION='', INDEXTYPE=5, JOININDEX = "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", JOININDEXTYPE = 1, VIEWATTRIBUTE = ('Month', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Month", '', '', '', '', 'Month'), VIEWATTRIBUTE = ('Month_1', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Month", '', '', '', '', 'Month_1'), VIEWATTRIBUTE = ('Reported_by', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Reported by", '', '', '', '', 'Reported_by'), VIEWATTRIBUTE = ('Falls_within', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Falls within", '', '', '', '', 'Falls_within'), VIEWATTRIBUTE = ('Location', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Location", '', '', '', '', 'Location'), VIEWATTRIBUTE = ('LSOA_code', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "LSOA code", '', '', '', '', 'LSOA_code'), VIEWATTRIBUTE = ('LSOA_name', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "LSOA name", '', '', '', '', 'LSOA_name'), VIEWATTRIBUTE = ('Crime_type', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Crime type", '', '', '', '', 'Crime_type'), VIEWATTRIBUTE = ('Last_outcome_category', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Last outcome category", '', '', '', '', 'Last_outcome_category'), KEYFIGURE = ("Longitude", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", ATTRIBUTE="Longitude"), KEYFIGURE = ("Latitude", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", ATTRIBUTE="Latitude"), KEYFIGURE = ("Crime_Count", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", ATTRIBUTE="Crime type"), CHARACTERISTIC=('Month', KEYATTRIBUTE="Month"), CHARACTERISTIC=('Month_1', KEYATTRIBUTE="Month_1"), CHARACTERISTIC=('Reported_by', KEYATTRIBUTE="Reported_by"), CHARACTERISTIC=('Falls_within', KEYATTRIBUTE="Falls_within"), CHARACTERISTIC=('Location', KEYATTRIBUTE="Location"), CHARACTERISTIC=('LSOA_code', KEYATTRIBUTE="LSOA_code"), CHARACTERISTIC=('LSOA_name', KEYATTRIBUTE="LSOA_name"), CHARACTERISTIC=('Crime_type', KEYATTRIBUTE="Crime_type"), CHARACTERISTIC=('Last_outcome_category', KEYATTRIBUTE="Last_outcome_category"), OPTIMIZEMETAMODEL=1)</element>
        <code>
        46</code>
        <message>
        transaction rolled back by an internal error: insufficient privilege: Not authorized</message>
        </detail>
        </errors>
        </details>
        </createCubeResult>
        Create OLAP Scenario statement: CREATE OLAP SCENARIO '<?xml version="1.0" encoding="utf-8"?>
        <cubeSchema version="3" operation="createHanaCube">
        <cube name="_SYS_BIC:p754360trial.gurihdb/V_CRIME_CITY" registerCubeForApsFlag="false" registerCubeForSqlApsFlag="false">
        <cubeTables>
        <cubeTable name="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" type="f-table"/>
        </cubeTables>
        <joinConditions/>
        <joinPaths/>
        <dimensionAttributes>
        <dimensionAttribute name="Month">
        <columnMappings>
        <columnMapping name="Month" technicalName="Month" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Month" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Month_1">
        <columnMappings>
        <columnMapping name="Month_1" technicalName="Month_1" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Month" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Reported_by">
        <columnMappings>
        <columnMapping name="Reported_by" technicalName="Reported_by" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Reported by" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Falls_within">
        <columnMappings>
        <columnMapping name="Falls_within" technicalName="Falls_within" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Falls within" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Location">
        <columnMappings>
        <columnMapping name="Location" technicalName="Location" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Location" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="LSOA_code">
        <columnMappings>
        <columnMapping name="LSOA_code" technicalName="LSOA_code" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="LSOA code" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="LSOA_name">
        <columnMappings>
        <columnMapping name="LSOA_name" technicalName="LSOA_name" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="LSOA name" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Crime_type">
        <columnMappings>
        <columnMapping name="Crime_type" technicalName="Crime_type" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Crime type" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Last_outcome_category">
        <columnMappings>
        <columnMapping name="Last_outcome_category" technicalName="Last_outcome_category" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Last outcome category" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        </dimensionAttributes>
        <measures>
        <measure name="Longitude" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Longitude" aggregationType="sum" isVisible="true"/>
        <measure name="Latitude" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Latitude" aggregationType="sum" isVisible="true"/>
        <measure name="Crime_Count" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Crime type" aggregationType="sum" isVisible="true"/>
        </measures>
        <constraints/>
        </cube>
        </cubeSchema>
        '
      • Model deployment started: p754360trial.gurihdb/V_CRIME_CITY timestamp: 2015-10-30,01:09:50.703
      • Removing BIMC records for p754360trial.gurihdb/V_CRIME_CITY timestamp: 2015-10-30,01:09:50.704
      • Removing hierarchy views for p754360trial.gurihdb/V_CRIME_CITY timestamp: 2015-10-30,01:09:50.709
      • Start deployment of analytic view, timestamp: 2015-10-30,01:09:50.713
      • CREATE OLAP SCENARIO statement :  CREATE OLAP SCENARIO '<?xml version="1.0" encoding="utf-8"?>
        <cubeSchema version="3" operation="createHanaCube">
        <cube name="_SYS_BIC:p754360trial.gurihdb/V_CRIME_CITY" registerCubeForApsFlag="false" registerCubeForSqlApsFlag="false">
        <cubeTables>
        <cubeTable name="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" type="f-table"/>
        </cubeTables>
        <joinConditions/>
        <joinPaths/>
        <dimensionAttributes>
        <dimensionAttribute name="Month">
        <columnMappings>
        <columnMapping name="Month" technicalName="Month" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Month" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Month_1">
        <columnMappings>
        <columnMapping name="Month_1" technicalName="Month_1" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Month" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Reported_by">
        <columnMappings>
        <columnMapping name="Reported_by" technicalName="Reported_by" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Reported by" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Falls_within">
        <columnMappings>
        <columnMapping name="Falls_within" technicalName="Falls_within" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Falls within" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Location">
        <columnMappings>
        <columnMapping name="Location" technicalName="Location" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Location" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="LSOA_code">
        <columnMappings>
        <columnMapping name="LSOA_code" technicalName="LSOA_code" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="LSOA code" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="LSOA_name">
        <columnMappings>
        <columnMapping name="LSOA_name" technicalName="LSOA_name" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="LSOA name" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Crime_type">
        <columnMappings>
        <columnMapping name="Crime_type" technicalName="Crime_type" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Crime type" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        <dimensionAttribute name="Last_outcome_category">
        <columnMappings>
        <columnMapping name="Last_outcome_category" technicalName="Last_outcome_category" type="key" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Last outcome category" isVisible="true"/>
        </columnMappings>
        </dimensionAttribute>
        </dimensionAttributes>
        <measures>
        <measure name="Longitude" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Longitude" aggregationType="sum" isVisible="true"/>
        <measure name="Latitude" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Latitude" aggregationType="sum" isVisible="true"/>
        <measure name="Crime_Count" table="DEV_C3XC18ZMYT32DSXV6MIBBJUL3:Crime" column="Crime type" aggregationType="sum" isVisible="true"/>
        </measures>
        <constraints/>
        </cube>
        </cubeSchema>
        '
      • timestamp: 2015-10-30,01:09:50.714
      • CREATE OLAP SCENARIO statement executed, timestamp: 2015-10-30,01:09:50.736
      • Create Analytic View failed :  SQL: transaction rolled back by an internal error: column store error: <?xml version="1.0" encoding="utf-8"?>
        <createCubeResult version="1.0">
        <status>
        <message>
        Error during executing SQL statement</message>
        <errorCode>
        2116</errorCode>
        </status>
        <details>
        <errors>
        <detail>
        <element>
        CREATE COLUMN VIEW "_SYS_BIC"."p754360trial.gurihdb/V_CRIME_CITY" WITH PARAMETERS (DESCRIPTION='', INDEXTYPE=5, JOININDEX = "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", JOININDEXTYPE = 1, VIEWATTRIBUTE = ('Month', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Month", '', '', '', '', 'Month'), VIEWATTRIBUTE = ('Month_1', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Month", '', '', '', '', 'Month_1'), VIEWATTRIBUTE = ('Reported_by', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Reported by", '', '', '', '', 'Reported_by'), VIEWATTRIBUTE = ('Falls_within', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Falls within", '', '', '', '', 'Falls_within'), VIEWATTRIBUTE = ('Location', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Location", '', '', '', '', 'Location'), VIEWATTRIBUTE = ('LSOA_code', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "LSOA code", '', '', '', '', 'LSOA_code'), VIEWATTRIBUTE = ('LSOA_name', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "LSOA name", '', '', '', '', 'LSOA_name'), VIEWATTRIBUTE = ('Crime_type', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Crime type", '', '', '', '', 'Crime_type'), VIEWATTRIBUTE = ('Last_outcome_category', "DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", "Last outcome category", '', '', '', '', 'Last_outcome_category'), KEYFIGURE = ("Longitude", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", ATTRIBUTE="Longitude"), KEYFIGURE = ("Latitude", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", ATTRIBUTE="Latitude"), KEYFIGURE = ("Crime_Count", 1, FORMULA='', DESCRIPTION='', UNITCONVERSIONNAME='', EXPRESSION='', EXPRESSIONFLAGS=0, INDEXID="DEV_C3XC18ZMYT32DSXV6MIBBJUL3"."Crime", ATTRIBUTE="Crime type"), CHARACTERISTIC=('Month', KEYATTRIBUTE="Month"), CHARACTERISTIC=('Month_1', KEYATTRIBUTE="Month_1"), CHARACTERISTIC=('Reported_by', KEYATTRIBUTE="Reported_by"), CHARACTERISTIC=('Falls_within', KEYATTRIBUTE="Falls_within"), CHARACTERISTIC=('Location', KEYATTRIBUTE="Location"), CHARACTERISTIC=('LSOA_code', KEYATTRIBUTE="LSOA_code"), CHARACTERISTIC=('LSOA_name', KEYATTRIBUTE="LSOA_name"), CHARACTERISTIC=('Crime_type', KEYATTRIBUTE="Crime_type"), CHARACTERISTIC=('Last_outcome_category', KEYATTRIBUTE="Last_outcome_category"), OPTIMIZEMETAMODEL=1)</element>
        <code>
        46</code>
        <message>
        transaction rolled back by an internal error: insufficient privilege: Not authorized</message>
        </detail>
        </errors>
        </details>
        </createCubeResult>
        2015-10-30,01:09:50.736
      • End deployment of analytic view, timestamp: 2015-10-30,01:09:50.736
      • Model deployment ended: p754360trial.gurihdb/V_CRIME_CITY timestamp: 2015-10-30,01:09:50.736

I have also checked user analytic privilege and also trying to grant analytic privilege. please check attached file.

Regards

Gursharanjit

Error.jpg (58.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 30, 2015 at 01:00 PM

    Hi,

    First of all, you do not have the permission to add a privilege to anyone. And "you" is inside that set.

    regarding the analytic view creation, i think you are missing a step.

    Try to execute this command: GRANT SELECT ON SCHEMA "your schema" TO _SYS_REPO WITH GRANT OPTION;

    Best,

    Christoforos

    Add comment
    10|10000 characters needed characters exceeded