An Unexpected Error Occurred In Report Processing. 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
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 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 have a very large report, which we've been running to benchmark performance.First, here are the results of https://support.microsoft.com/en-us/kb/909678 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. 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 http://www.sqlservercentral.com/Forums/Topic317434-147-1.aspx 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 / 1536mb = roughly 80% 1,290mb / 2048mb = roughly 63%Following the directions in "Configuring Available Memory for Reporting Services" (http://msdn2.microsoft.com/en-us/library/ms159206.aspx), we tried increasing the MemoryLimit of both the Web Service and the Windows Service.We changed the memoryLimit in machine.config to:
Hi , An unexpected error occurred in Report Processing. (rsInternalError) http://answers.flyppdevportal.com/MVC/Post/Thread/d0b6ae1a-8dc1-48cc-b9e5-1fe1ded6ba15?category=sqlreportingservices Get Online Help The type initializer for 'Microsoft.ReportingServices.Library.RSLocalCacheManager' http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=171752 threw an exception. The type initializer for 'Microsoft.ReportingServices.Diagnostics.MemoryAuditCollection' threw an exception. Exception of type 'System.OutOfMemoryException' was thrown. I get the above error message when i click to see the cube status on SSRS an unexpected home page under admin reports . probably all the TFS 2012 reports shows the same error message. Please advice... No space issue is seen for the Tfs report server DB or temp db. Below is what i find in the reporting an unexpected error service Logs.. processing!ReportServer_0-78!179c!04/30/2014-09:41:07:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.Library.RSLocalCacheManager' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.Diagnostics.MemoryAuditCollection' threw an exception. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at Microsoft.ReportingServices.Diagnostics.MemoryAuditCollection..cctor() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.MemoryAuditCollection.Register(MemoryAuditProxy map) at Microsoft.ReportingServices.Library.RSLocalCacheManager..ctor() at Microsoft.ReportingServices.Library.RSLocalCacheManager..cctor() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.SegmentCache.TryGetCache(Guid segmentId, Byte[]& buffer) at Microsoft.ReportingServices.Library.CacheStorageLayer.Read(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.Read(Int64 position, Byte[] buffer, Int32 offset, Int32 length) at Microsoft.ReportingServices.Library.StorageStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.FillBuffer(Int32& bytesRead) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.ReadByte() at System.IO.BinaryReader.ReadByte() An unexpected error occurr
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums Analysis Server and Reporting Services (2008) 'System.OutOfMemoryException' SSRS 2005 Error Reply to Topic Printer Friendly Author Topic Danny_SQL_9876 Starting Member 8 Posts Posted-02/23/2012: 17:55:27 Hi All,When i run a report from visual studio it gives me the following error"An error occurred during local report processing.An error has occurred during report processing.Exception of type 'System.OutOfMemoryException' was thrown"The query behind it is very simple returning 80000 records.the server i am running the report on is 64 bit, 14 GB Ram. 3 GHNote: when i run the query in SSMS it take 1 sec to return results, when i run the query on "Data" tab on the report itself the query takes 1 sec to return all the results. but when i design a table in "Layout" and try to preview the report it keeps rendering for around 2 minutes and throws the error.Any Help is appreciated. Thanks in advanceDanny visakh16 Very Important crosS Applying yaK Herder India 52326 Posts Posted-02/23/2012: 17:57:08 is the report having lots of images ,pictures etc in it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ Danny_SQL_9876 Starting Member 8 Posts Posted-02/23/2012: 18:00:48 Hi Visakh,Nop. there are no images, no fancy formatting at all. plain table with fields.Danny visakh16 Very Important crosS Applying yaK Herder India 52326 Posts Posted-02/23/2012: 18:33:56 whats the purpose of showing 80,000 records in report? I didnt understand what anyone will do all those rows. You might be better off applying further filters and also paging to show only subset of data and then make report interactive to show rest of data only if user is interested---------------------------------------------------------------------------