An error has occurred during report processing. (rsProcessingAborted).. Query execution failed for data set
Hi All,I'm facing a strange problem..I've developed few reports. they are working fine in develop environment. after successfull testing they were published on web.in web version, all reports are executing for first time.. if I change any of parameters values or without chaning also..if I press "View Report" following error occurs.. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for data set 'dsMLGDB2Odbc'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors please suggest any alternative ways to overcome this issuethanks in adv.
September 11th, 2007 6:04pm

Try Enabling the Remote Errors. Follow this link : http://technet.microsoft.com/en-us/library/aa337165.aspx 1.) Go to the ReportsDB 2.) Drilldown to Tables and select the dbo.ConfigurationInfo 3.) Open the table and change the EnableRemoteErrors to TRUE in the Value column and run Execute SQL. Hope this helps...
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2007 6:17pm

I also had the same problem and got it corrected by doing following... * Right-Click on the report server and select properties. *Under general select "Enable my reports folder for each user" option. *Then select the appropriaterole from the drop down list.(Remember the user you want is in this member role group) Hope u will able to view your report then...
January 28th, 2009 8:15am

This, unfortunately, is a known issue. The problem is that if you are viewing the report and then you update it, there is some metadata which needs to be rebound when you press the View Report button. This doesn't get rebound correctly. The solution is to navigate back to the folder containing the report and run it again.Hope that helps,-LukaszGot a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
September 11th, 2009 5:56pm

I had the same problem. Problem was caused by SQL security - user run a report did not have select rights on specific View on MS SQL server
December 23rd, 2009 6:23pm

The first thing you might want to check is if you have permissions to run the query. I had the same issue, got permissions to run the stored procedure that this report calls and it started working fine.
Free Windows Admin Tool Kit Click here and download it now
February 12th, 2010 12:05am

I got the same error and then I realised the stored procedure for fetching the data itself was throwing error. Not sure this is important but also make sure the DB side is working properly -Rakesh
March 31st, 2010 8:58pm

in my case the problem is one virtual machine is for developers other for testers in developers i created a report, then save like *.rdl and copy to testers machine, does not work there the error what testers get is Error during the local report processing. Could not find a web-based application at http://developersMachine/AnalyticsReports/DataBaseConnector.rsds
Free Windows Admin Tool Kit Click here and download it now
August 1st, 2011 6:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics