SSRS Query execution failed for dataset

sql-server sql-server-2008 reporting-services ssrs-2008
JsonStatham picture JsonStatham · Jun 1, 2012 · Viewed 165.1k times · Source

Have just deployed my Project on to my reporting Server.

I have multiple datasets which are referencing views which exist on the db on that server.

When I try to go into any report part I am getting this message:

An error has occurred during report processing. (rsProcessingAborted)
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 remote errors

Can anyone help?

Answer

JsonStatham picture JsonStatham · Jun 1, 2012

I enabled remote errors to pinpoint the problem.

I identified that a column in a particular dataset (one of my views) was throwing an error.

So using a tool "SQL Delta", I compared the development version of the database with the live version on the reporting server. I noticed that one of the views had an extra column on the development server, that was not on the live version of the db.

SQL Delta generated the script I needed to run to update the view on my live db.

I ran this script, re-ran the report, everything worked.

Related questions

"An item with the same key has already been added" Error on SSRS When Trying to Set Dataset

When i try to set the Dataset in SSRS IDE, i get the error you see in the snapshot. The query works totally fine in SQL Server Management Studio, i wonder where did i go wrong?! The connection to DB …

Read More
Comments in SSRS Report Expressions

I'm using some complicated expressions in Reporting Services to control the value, format etc of data in a report (see MSDN). Is it possible to insert code comments into these expressions, and if so, what is the syntax? By code …

Read More
Caching vs Report Snapshot in SSRS

I was reading an article on how to improve performance in SSRS at here and was wondering; What exactly is difference between Caching & Report Snapshot? What are the parameters that should be handy when deciding between Caching & Report …

Read More