Error occuring in report processing
I have certain rdls created in SSRS 2008 and deployed on a Share point server.Some of these reports fail on the server side with the following error: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'DataSet2'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors But when i download the same and preview them in VS the output is displayed.Sometimes when i redploy them the report start working at the server side as well. Can someone help me on this?
November 13th, 2010 8:19am

Hi, From your descriptioin, follow these suggestions to do futher troubleshooting: 1. Have you rights to access the database of the report data source? Check your datasource credential on the sharepoint site. 2. If your report calls a shared datasource, check if the datasource is also deployed on the sharepoint and can be access by the report dataset. 3. Is there any data returned by the report dataset? For example, you select some report parameter value to cause no data returned. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 9:43pm

The report does run some times.But this error comes at random. If there would be access related issue,then it would not run at all. This is why I am puzzled.
November 24th, 2010 5:45am

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

Other recent topics Other recent topics