EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB263106: “You are not allowed to perform the manipulation that requires SQL regeneration because you do not have privileges” error when running a document or dashboard based on a Live Connection data import source


Community Admin

• Strategy


In MicroStrategy 10, users may get an error message when trying to execute a document or dashboard based on a Live Connection data import source: “You are not allowed to perform the manipulation that requires SQL regeneration because you do not have privileges”

SUMMARY:
In Strategy 10, users may get an error message when trying to execute a document or dashboard based on a Live Connection data import source. This document explains the cause of this issue and how it can be resolved.
 
DESCRIPTION / SYMPTOM:
When users try to run a document or dashboard based on a Live Connection data import source, they may encounter the following error message:

ka04W000000OhoBQAS_0EM4400000025ZA.jpeg


You are not allowed to perform the manipulation that requires SQL regeneration because you do not have privileges Modify the list of report objects (use object browser) or Web modify the list of report objects (use object browser – all objects). Internal Error: DSSDocumentExecuteTask::Run(): Error calling DocumentInstance::Execute(), job 156, Error Code=-2147213443

Users are able to successfully execute the same document or dashboard when it is based on an In-Memory data import source.
CAUSE:
The Live Connection data import feature is a new feature in 10 that allows live connections to the database rather than having to import a dataset and store it in memory. Since the connection to the database is live, SQL is executed against the database any time a change is made to the dashboard, and this causes the list of report objects within Strategy to change.
 
ACTION:
Grant users the privilege “Web modify the list of report objects (use object browser – all objects)” under Web Professional privileges if users need to be able to run the document/dashboard in Strategy Web.
Grant users the privilege “Modify the list of report objects (use object browser)” under Developer privileges if users need to be able to run the document/dashboard in Strategy Developer.
 


Comment

0 comments

Details

Knowledge Article

Published:

April 13, 2017

Last Updated:

April 13, 2017