SSRS SQL 2008 R2 - An unexpected error occurred in Report Processing

kellaro · November 23rd, 2011, 05:31 PM

I recently upgraded to SQL 2008 R2 and I have created a new report in BIDS. I can preview this new report and everything works and looks great, however when I try to deploy this report I get the error message of "An Unexpected Error Occurred In Report Processing". It may be worth mentioning my report uses multiple parameters. I have narrowed down the problem to a few pie charts that I have included. When I remove the pie charts the report deploys perfectly.

Additionally, I tried creating a totally new report with a single pie chart, removed all parameters and tried to deploy it as well, with no luck.

Does anyone know if there is a know issue with deploying pie charts in SSRS 2008?

Thanks in advance

Rich

Paul_Turley · November 23rd, 2011, 05:50 PM

There is certainly not a general problem with pie charts or any other type of charts in SSRS 2008 or SSRS 2008 R2. Many companies are using these and other features in thousands of production deployments.
Check the version compatibility property for your report project and make sure it matches the version of your target server. If this isn't the issue, I suspect a component registration problem of some kind.
Does the problem occur if you upload the RDL file directly in Report Manager or SharePoint?
I recommend that you uninstall/reinstall Reporting Services on the server or test with an alternate server.

kellaro · November 23rd, 2011, 06:00 PM

Thanks for the response Paul. I will look into the version and registration potential issues you mentioned. Additionally, I get the same error message when I try to upload the file directly into Report Manager.

I found a similar occurrence in a technet forum thread (that I also posted to earlier today).

http://social.technet.microsoft.com/...8-5ea44769d592

Thanks again for taking the time and I will try your suggestions.

Rich

kellaro · November 24th, 2011, 09:46 AM

A quick update;

I right clicked on the 'Details' under the Category Group properties for the pie chart and deleted the category group and this seems to have fixed my deployment issue.

Thanks again

Rich

Paul_Turley · November 29th, 2011, 04:23 PM

This is certainly not very helpful error feedback. If you are able to reproduce this behavior in a current product verison, please post a bug/feedback for the SSRS product team at Connect.Microsoft.com.

Thanks for letting me know what you found.