Thursday, May 24, 2012

query execution failed for dataset

I got this error in attempting to run an SSRS report:

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

 
 

It didn't happen for all reports in a project. Rather, it happened for all but one report. One report worked just fine. This led me to believe that there wasn't anything wrong with the data source that was set up. The reports that were handed to me that wouldn't work were supposedly legit. What was messed up? It turned out that the queries in all but one of the reports reached into views which did joins out to another database. The user at the data source just needed its permissions updated to be able to "see" into the other database. I did not solve this problem via enabled remote errors. :P

No comments:

Post a Comment