rsProcessing aborted error msg

Question

I am getting this error msg in report manager after building and deploying reports from SSRS. It worked before, but this happened over a month ago. I am using VS 2008. Any ideas?

An error has occurred during report processing. (rsProcessingAborted)
The execution failed for the shared data set 'DataSet1'. (rsDataSetExecutionError)
Query execution failed for dataset ''. (rsErrorExecutingCommand)
Invalid object name 'Employees'.

Answer 1

You can see what query is running under DataSet1 definitions and check it for Employees object. Just run this query in SSMS and  you would probably same error.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
MS SQL Consultants: Improves MS SQL Database Performance

Answer 2

Everything is fine in preview mode. I even ran another report using the Report Server Project Wizard. The problem is just in Report Manager/Server and this is now happening with every single report.

There is no problem with the T-SQL when I run it as a query under the corresponding database in SSMS.

Answer 3

Hi Meridius,

Do you make changes to the shared dataset? If so, please redeploy the report to Report Server. (Note: please make sure the “Overwrite Data Sources" and "Overwrite Datasets" properties are set to “True” in the deploy configuration dialog box.)

If the issue persists, please share the error log with us. This file is located at \Microsoft SQL Server\<SQL Server Instance>\Reporting Services\LogFiles. It benefit us for doing further analysis.

Regards,
Fanny Liu

---

Fanny Liu

TechNet Community Support

Answer 4

Many Thanks. This has resolved the problem. I also found this good article: http://msdn.microsoft.com/en-us/library/ms155802%28v=sql.100%29.aspx

I am not sure how I am supposed to use a shared data source? Should I create a new data source and dataset for each new report?