- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- HANA Trial Cloud User does not have permission to ...
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
HANA Trial Cloud User does not have permission to create Analytic View
Guru009
Discoverer
Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 10-30-2015 5:22 AM
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
- Validation of p754360trial.gurihdb::V_CRIME_CITY
- 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
- 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"?>
I have also checked user analytic privilege and also trying to grant analytic privilege. please check attached file.
Regards
Gursharanjit
- SAP Managed Tags:
- SAP Business Technology Platform
Accepted Solutions (1)
Accepted Solutions (1)
former_member18
Participant
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
10-30-2015
1: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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Answers (0)
Ask a Question
Related Content
- Use CRUD Opreations with SAP Datasphere Command-Line-Interface in Technology Blogs by SAP
- Streamlining Time Sheet Approvals in SuccessFactors: Time Sheet Approval Center in Technology Blogs by Members
- SAP Analytics Cloud - Performance statistics and zero records in Technology Blogs by SAP
- Consolidation Extension for SAP Analytics Cloud – Automated Eliminations and Adjustments (part 1) in Technology Blogs by Members
- Consuming SAP with SAP Build Apps - Connectivity options for low-code development - part 2 in Technology Blogs by SAP
Top Q&A Solution Author
| User | Count |
|---|---|
| 84 | |
| 10 | |
| 10 | |
| 10 | |
| 7 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.