February 4, 2014 at 10:26 am
I've written and deployed around 100 reports to our web server in the past few weeks all of which work great.
But, just one of them will not run from the server, it's fine in Development Studio, works really well, when I deploy it to the server, attach the shared datasource the run it - I get the following error.
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'ds_DATASET1' (rsErrorExecutingCommand)
All the reports use individual Stored Procedures on the same server, and they all run well.
Some of the things I've tried.
1) Re-writing the report on the server and testing it on the server - again works from Development studio, but not when deployed
2) Re-initilised the data source
3) Created a new data source, just for this report.
4) Re-written the Stored Procedure
5) Executing the stored procedure manually - works fine returns all the data in the correct format with no errors
6) Checked coding errors from the development studio for the report and there are none.
7) I've even got one of the other developers to test/deploy/run the report and it fails for him also.
Any idea's of what I could try next would be much appreciated.
Thanks
February 5, 2014 at 5:28 pm
Have you looked in the ReportServer error logs? I have found the "execution failed for dataset" message that SSRS provides covers a wide variety of issues, and often the error logs will have more helpful detail (query was a deadlock victim, etc.).
February 5, 2014 at 5:40 pm
I have also found that running the report from ReportServer url instead of report manager also produces better information. It's worth a shot.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply