Sunday, November 18, 2012 11:20 AM
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'.
Sunday, November 18, 2012 11:44 AMYou 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
Sunday, November 18, 2012 10:47 PM
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.
Monday, November 19, 2012 2:53 AMModerator
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.
TechNet Community Support
- Marked As Answer by meridius10 Tuesday, November 20, 2012 1:22 PM
Monday, November 19, 2012 10:38 PM
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?