Search code examples
reporting-servicesvisual-studio-2013ssrs-2014

Reporting Services Preview Host has stopped working


I am having an issue previewing SSRS reports using Visual Studio Professional 2013. The first time I preview a report it works, however, if I go back to design and then preview again I get the following error:

Reporting Services Preview Processing Host has stopped working

Problem signature:
Problem Event Name: CLR20r3
Problem Signature 01:   PreviewProcessingService.exe
Problem Signature 02:   12.0.2430.0
Problem Signature 03:   543f04a1
Problem Signature 04:   mscorlib
Problem Signature 05:   4.0.30319.34209
Problem Signature 06:   534894cc
Problem Signature 07:   4780
Problem Signature 08:   57
Problem Signature 09:   System.OutOfMemoryException
OS Version: 6.1.7601.2.1.0.256.48
Locale ID:  1033
Additional Information 1:   0a9e
Additional Information 2:   0a9e372d3b4ad19135b953a78882e789
Additional Information 3:   0a9e
Additional Information 4:   0a9e372d3b4ad19135b953a78882e789

When I close the program I get the following error:

Visual Studio First Error If I try to preview the report again, I get the following error: No endpoint listening I have verified that net.pipe listener service is running, and I've tried restarting it. I have uninstalled Visual Studio and SQL Server and installed it again. None of these have fixed the problem. What can I do to allow myself to preview a report more than once without restarting Visual Studio?


Solution

  • Without any definite answer, I assumed that the data set was too big, hence the System.OutOfMemoryException. That being said, after ensuring that the SQL for the dataset returned the smallest set of data possible, I seemed to be able to run my reports. I do wonder, what is the correlation between SQL Server system resourced and SSRS dataset size?