Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 (58861 B)
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question