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

book

Article ID: 156599

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

When accessing an IT Analytics report, the error "An error has occurred during report processing. Query execution failed for dataset 'dataset_name'." occurs.

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

Cause

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 Report Server (SSRS) and a full explanation of the error then occurs:

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

Resolution

Remove the custom data classes from the dataset's properties and any embedded SQL in the report while using Microsoft Report Builder and then save the report.

Related Article

Can custom data classes and resources be added into IT Analytics?
http://www.symantec.com/business/support/index?page=content&id=HOWTO9932