SSRS error on preview : "The size necessary to buffer the XML content exceeded the buffer quota" hides original error

Question

I understand that there is definitely something wrong with my report (e.g. columns missmatcch) and I need to correct it but what I see is the WCF error message that hides actual problem and exactly this hiding irritates me much more than original problem: columns missmatch.

I guess we need to adjust the WCF 'buffer size' and we will get original problem message. But where is the config file? Text search of "system.serviceModel" in the C:\Program Files (x86)\Microsoft Visual Studio 10.0 doesn't bring good idea...

P.S. Since this is just preview of report I do not think that it is SSRS configuration problem. Problem localised somewhere in DevStudio process or int the DevStudio's internal web server process ...

P.P.S Please help me too improve the question. I see that responders doesn't understand what kind of help I need.

Answer 1

I have encountered multiple "flavors" of this bug in SSRS Preview. It seems the renderer for Preview mode is quite fragile.

There is a simple way to solve this. Ignore the error and attempt to upload the RDL file to your reporting server. The uploader will happily tell you exactly what is wrong with your file - it will tell you exactly what field has a problem and what that problem is. If there are multiple errors, you will get told each and every field and the error associated with each one.

I can create this bogus XML buffer error with any of the following:

• Add a new Tablix, start to connect it to a dataset, then cancel out.
• Copy/paste some text into a textbox from a MS Word document where one or more lines have a negative right indent (right column end is outside page margin).
• Connect a dataset with a varchar(8000) returned value.

Answer 2

Please Check if any of your report items are referencing fields that are not in existing dataset scope.

This indeed worked for me.

See Below link for more information: http://connect.microsoft.com/SQLServer/feedback/details/742913/ssdt-reporting-services-designer-error