Error "Query execution failed for dataset 'dataset_name'" occurs when accessing an IT Analytics report

Products

• IT Analytics
• Client Management Suite
• Server Management Suite
• IT Management Suite

Issue/Introduction

When accessing an IT Analytics (ITA) report, the following error is returned:

An error has occurred during report processing. (rsProcessingAborted)
       Query execution failed for dataset '<dataset_name>'. (rsErrorExecutingCommand)
             For more information about this error navigate to the report server on the local server machine, or enable remote errors

Environment

ITMS 8.x

IT Analytics 8.x

Cause

1. A custom data class has been added incorrectly to an IT Analytics report. This can be found by accessing the modified report directly on the SQL Server Reporting Services (SSRS) server, which produces a more detailed error message:
   

   An error has occurred during report processing. (rsProcessingAborted)   
       Query execution failed for dataset '<dataset_name>'. (rsErrorExecutingCommand)             
           Invalid object name '<Inv_custom_data_class_name>'.

2. The account used by SSRS to query the ITA cubes is not a member of the Administrators role on the Analysis Services (SSAS) server.

Resolution

The following resolutions correspond to the causes listed in the Cause section of this article:

1. Using Microsoft Report Builder, remove the custom data class(es) from both the dataset properties and any embedded SQL within the report
2. Add the account used by SSRS for the data source connection to SSAS to the Administrators role on the SSAS server by following this procedure:
   1. Open SQL Server Management Studio (SSMS)
   2. Connect to the Analysis Services server hosting the ITA cubes
   3. In Object Explorer, right-click the hostname of the SSAS server and select Properties
   4. In the Analysis Server Properties window, select the Security page
   5. Click the Add... button
   6. In the Select Users or Groups window, enter the user or group object through which SSRS connects to SSAS
   7. Click the OK button to close the Select Users or Groups window
   8. Click the OK button to close the Analysis Server Properties window