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

Article:TECH190935  |  Created: 2012-06-13  |  Updated: 2012-06-13  |  Article URL http://www.symantec.com/docs/TECH190935
Article Type
Technical Solution


Issue



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


Error



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'.


Solution



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




Article URL http://www.symantec.com/docs/TECH190935


Terms of use for this information are found in Legal Notices