KB37160: "[DFCENGINE] Engine Logic: Insufficient privileges: can not execute a report that uses multiple data source" error message appears when running a report in MicroStrategy Web.

• Strategy

This KB addresses an error seen regarding insufficient privileges when running a report in MicroStrategy Web.

SYMPTOM:
The following error occurs when attempting to run a report from Strategy Web 9.x and 10.x:


SQLEngine got an Exception from DFC: Engine Logic: Insufficient privileges: can not execute a report that uses multiple data sourceError in  Process method of Component: SQLEngineServer, Project #####, Job 9718, Error Code= -2147212800.)

The report uses only one database instance and the report database instance is not the primary database instance for the Project.
CAUSE:
The license key used does not provide the use of Multisource feature.
ACTION:
To execute the Multisource reports, two conditions need to meet:

License key applied should provide MultiSource option.
User running the report should have been assigned the 'Execute multiple sources report' privilege as show below:

Refer to the following KB for related causes of the above error:
KB32672: "[DFCENGINE] Engine Logic: Insufficient privileges: can not execute a report that uses multiple data sources" error message appears when running a multisource report in MicroStrategy Desktop 9.x

Comment

0 comments

Details

Knowledge Article

Published:

April 7, 2017

Last Updated:

June 30, 2022