ProblemAfter installing RES Reporting and opening any of the Dashboard an error could be displayed with the following information;
An error has occurred during report processing. (rsProcessingAborted)
The execution failed for the shared data set 'dw_roa_dataset_Top10MostActive'. (rsDataSetExecutionError)
Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable
CauseThis error is displayed because the data import tasks have never run.
SolutionThe data import tasks can be ran manually by going to Reporting > Setup > Product > Schedule and clicking 'RUN NOW"
If the error is still displayed after the import has finished successfully there might be issues with the SQL Cubes. To redeploy the cubes start "C:\Program Files\RES\Reporting\Utility\RES.Intelligence.ETLUtility.exe" /ui and type Ctrl+F7
After the cubes have been deployed successfully again go to Reporting > Setup > Product > Schedule and clicking 'RUN NOW".