An Error Occurred During Rendering Of The Report System.outofmemoryexception
One games Xbox 360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each https://support.microsoft.com/en-us/kb/909678 other. Join them; it only takes a minute: Sign up SSRS - OutOf MemoryException - is there a limit to the number of rows that can be displayed up vote 3 down vote favorite I have created an rdl doc that points at a proc that returns 90 000 rows and I am getting an out of memory http://stackoverflow.com/questions/542471/ssrs-outof-memoryexception-is-there-a-limit-to-the-number-of-rows-that-can-b exception. Is there a limit to how many rows the report projects can handle? Currently I have changed the proc that drives my report to just do a select Top 90 000. My specs are to be able to create a report with 120 000 rows. My report is a matrix. I swear last week I generated a report that has 106800 rows in it but now all of sudden I can't. I have written a rendering extension and here is part of the exception when I step into the code. eInfo: 2/12/2009 12:03:53 PM prairieFyre.ReportActions.RenderReport: Error rendering report Microsoft.Reporting.WinForms.LocalProcessingException: An error occurred during local report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at System.IO.MemoryStream.set_Capacity(Int32 value) at System.IO.MemoryStream.EnsureCapacity(Int32 value) at System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count) at System.IO.BinaryWriter.Write(String value) at Microsoft.ReportingServices.ReportProcessing.Persistence.IntermediateFormatWriter.ReportServerBinaryWriter.WriteString(String stringValue) .... reporting-services matrix max rows rdl share|improve this question edited May 11 '15 at 14:58 Sébastien Sevrin 3,40111131 asked Feb 12 '09 at 17:36 add a comment| 3 Ans
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server http://www.sqlservercentral.com/Forums/Topic317434-147-1.aspx 2005 » Business Intelligence » Reporting Services MemoryLimit Reporting Services MemoryLimit Rate Topic Display Mode Topic Options Author Message Andrew TregonningAndrew Tregonning Posted Monday, October 23, 2006 3:36 PM Ten Centuries Group: General Forum Members Last Login: Sunday, August 23, 2015 5:03 PM Points: 1,165, Visits: 146 HiWe're having trouble with memory configuration in Reporting Services 2k5 SP1, running on Win 2k3 SP1. We an error have a very large report, which we've been running to benchmark performance.First, here are the results of our testing:Initially, the server had 512mb of RAM. When running the report, the w3wp.exe process used up to 400mb of RAM and Reporting Services usually timed out before delivering the report.We increased the RAM in the server to 1024mb, and found we could run the report. an error occurred It took around 02'30" to complete, and the w3wp.exe process peaked at 520mb of RAM usage. When we tried to run two instances of the report concurrently, RAM usage peaked around 800mb, and Reporting Services timed out before delivering the reports.Increasing the server RAM to 1536mb, we found could run two reports at once. It took around 04'05" to deliver the reports, and the w3wp.exe process peaked at 920mb of RAM usage. When we tried running three reports concurrently, RAM usage peaked around 1,220mb of RAM and Reporting Services usually timed out before delivering the reports.Lastly, we put 2048mb of RAM in the server, and we could run three reports at once. It took around 06'58" to deliver the reports, and the w3wp.exe process peaked at 1,280mb of RAM usage. When we tried running four reports concurrently, RAM usage peaked around 1,290mb and Reporting Services died with a System.OutOfMemoryException exception.The pattern we noticed with the first three steps, was that Reporting Services isn't using more than 80% of the physical RAM available on the server:400mb / 512mb = roughly 80% 800mb / 1024mb = roughly 80% 1,220mb / 1536m