We are using below code to export gridview data to excel. It is working fine when export 2 or 3 months data with more than 120,000 rows but we can try to export data for more than 12 months which almost contain 480,000 rows so it generates error
"System is out of memory exception" ....
[Code]....
View 4 RepliesI am working on a ASP.NET 2.0 application. I get the following exception sometimes when i access the web application. I believe it is related to the server where the application is hosted? Exception of type 'System.OutOfMemoryException' was thrown. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.]
System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +43
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +127
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +142
System.Reflection.Assembly.Load(String assemblyString) +28
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +46
[ConfigurationErrorsException: Exception of type 'System.OutOfMemoryException' was thrown.]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +613
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +203
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +105
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +178
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +54
System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +227
System.Web.Compilation.BuildManager.CompileGlobalAsax() +52
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +337
[HttpException (0x80004005): Exception of type 'System.OutOfMemoryException' was thrown.]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +58
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +512
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +729
[HttpException (0x80004005): Exception of type 'System.OutOfMemoryException' was thrown.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8890735
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +85
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +259
What can be the reason for this error and what to check on the code or the server?
I've got an asp.net application, it's running on DotNetNuke, under load we get the occasional out of memory exception. I've got a dump loaded it into windbg. the end of !dumpheap -stat is
1192a588 88684 2128416 AutoMapper.MappingEngine
79333594 9482 2266348 System.Byte[]
134b0034 88695 2838240 System.EventHandler`1[[AutoMapper.TypeMapCreatedEventArgs, AutoMapper]]
13d8703c 88684 4611568 System.Collections.Generic.Dictionary`2[[Castle.DynamicProxy.Generators.CacheKey, AutoMapper],[System.Type, mscorlib]]
13d86dc8 88684 4611568 Castle.DynamicProxy.ModuleScope
13d865bc 88684 4611568 System.Collections.Generic.Dictionary`2[[AutoMapper.Internal.TypePair, AutoMapper],[AutoMapper.IObjectMapper, AutoMapper]]
79327434 88703 4612556 System.Collections.Generic.Dictionary`2[[System.String, mscorlib],[System.Int32, mscorlib]]
6c38e4e4 88684 5675776 System.Threading.ReaderWriterLockSlim
79330b24 87736 6458012 System.String
000d9c88 129 24186884 Free
793042f4 221202 101117016 System.Object[]
6c38e4a0 22703104 544874496 System.Threading.ReaderWriterCount
I can't find much information on the System.Threading.ReaderWriterCount, as it seems to be the problem. What is the likely cause? Or failing that what's the best next step to work that out? Based on the pointer from the given answer I had a look at ReaderWriterLockSlim. I wasn't using it directly, but I saw that it had 88684 instances, digging deeper I saw quite a few classes with that number of instances, pointing to AutoMapper.MappingEngine. This should be a singleton, so I've had a look at where it's being created. I suspect that it's the DI container and have made some changes around that to see if it helps
I am facing a problem wherein, whenever I am trying to export a large recordset to excel (over 50k records) I am getting the System.OutOfMemoryException. I want to know a couple of things :
1. How do I handle this exception as try - catch does not seem to work?
2. I am pasting sample code. I just want to know if there is a better way of doing this :
[code]....
An unhandled exception of type 'System.InvalidOperationException' occurred in System.Xml.dll
View 1 RepliesHow can I export data from a Gridview to excel and once exported the data should be formatted in right to left (arabic) manner. How can I achieve this?
View 2 Repliesi use this code to export data into word.
Protected Sub Export(sender As Object, e As EventArgs) Handles btn_printexcel.Click
Response.Clear()
Response.Buffer = True
[Code]....
but the export docs will be downloaded into the user computer.
what should i do so that the exported docs is save into the server?
We have the requirement to export the data from the grid excel. We can't install the Excel on the server. The excel generated need to be in the printable format. The excel generated needs to have custom headers, footers, repeatble rows, columns and landscape / portrait orientation style.
View 1 RepliesI am exporting a gridview in MS Excel as mentioned in the following link:
[URL]
I want to set orientation of excel pages as landscape. Is there any way to do that? Any header information to be added for file being exported to set orientation of pages as landscape?
i have table something like this on click of export to excel i need to save that or export that to excel file .can u plz help me how i can do this.one more thing how i can desing and build that big html table into excel is there any simple way i can do the same
View 1 Repliesi have try to export data to excel using gridview.
I have export it successfully but some data is missing which is due to the column format in the exported excel file is not TEXT .
[Code]....
I need to set the exported excel file column format to TEXT but find no solution on this.
i have in grid view that grid view have very long string. when i export grid view export in excel it that string shows in single line
View 1 RepliesI have a web form that contains a GridView, which impliments Search in Grid with a TextBox and Button control in the footer. This works as I have it now. I have also implimented a Export to Excel function. The Export to Excel works by itself if the Search in Grid function is not included in the footer.The Export to Excel function errors when trying to render the Grid for the export. Is there a better way to incorporate both functions and accomplish the same thing? Am I missing something simple?
[Code]...
How to isolate an out of memory exception
View 2 RepliesI have a large XML file that contains invalid hex characters. I'm trying to test a function that removes invalid characters from the XML file but it must be stored in a string. When I try to read the XML file into a string I receive an out of memory exception. The file is 149MB. Can anyone tell me if there is another way to do this?
Code:
[code]....
I have a strange problem with ASP.NET. Several sites on my web server run the exact same application. The application has a page that contains a Tab Container from the Ajax Control Toolkit which in itself contains a Calendar control.
If I set my culture in the web.config to be:
<globalization culture="en-GB" uiCulture="en-GB" />
Then everything works fine. However, by changing this to:
<globalization culture="en-US" uiCulture="en-US" />
When attempting to load the page I get an out of memory exception and w3wp.exe seems to use all available memory.
I'm not sure why but on random occassions after I have added an update to my site via ftp and then try to access the site through the browser I get an "out of memory" exception. But there are no infinite loops or problems like that. Then after some time it will then work (I assume the web hosts restart IIS or something) and all is fine again. Server Error in '/' Application. Exception of type 'System.OutOfMemoryException' was thrown. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
Source Error:
[Code]....
Stack Trace:
[Code]....
I have a requirement that to create a image with 300DPI, but during the composition of image, like addding the resources (font, images) I am getting out of memory exception.
using (Bitmap pg = new Bitmap(GetPixelsFromInches(float.Parse(pageWidth), dpi, actualDpi), GetPixelsFromInches(float.Parse(pageHeight), dpi, actualDpi)))
{
pg.SetResolution(float.Parse(dpi), float.Parse(dpi));
Graphics gr = Graphics.FromImage(pg);
gr.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic;
System.Drawing.Rectangle pgRect = new System.Drawing.Rectangle(0, 0, pg.Width, pg.Height);
SolidBrush solidWhite = new SolidBrush(Color.White);
gr.FillRectangle(solidWhite, pgRect);
currentPageDisplayed = xNode.Attributes["id"].Value;
foreach (XmlElement xElement in xNode)
{
//Here I am writing each elements, like texts or images.
DrawImageForElements(xElement, , dpi, actualDpi);
}
MemoryStream myMemoryStream = new MemoryStream();
//pg.Save(myMemoryStream, System.Drawing.Imaging.ImageFormat.Bmp);
String filename=@"c:images" + currentPageDisplayed + "+.png";
pg.Save(filename, System.Drawing.Imaging.ImageFormat.Png);
myMemoryStream.Dispose();
gr.Dispose();
pg.Dispose();
}
I have been trying to get the data display on the datagrid after selecting a customer.
With the same connection it populates the selection right. But just do not seem to extract the following SQL.
The litABC is to check the flow of control.
There is no syntax error but in the debug menu,
I got A first chance exception of type 'System.Data.Odbc.OdbcException' occurred in System.
Where did I do wrong?
[code]....
When i fill my sql adapter daAuthors.Fill(dsPubs, "MYTable") sometime i get A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dllmy code can run for a lot hours without any problems but sometime i get the message
View 1 Repliesthese below codes give whole data of my Rehber datas. But if i want to show web page via Gridview send me out of memory exception error.
[code]....
im using sap crystal report version 13.0.2000.0. i've 27,000 records to be printed but when i run my application the exception error is displayed "Out Of Memory".. i've my appliation in VS2010 and OS is server 64bit and 4GB RAM..
View 1 RepliesI'm using SqlBulkCopy to load large file into databse, but a file bigger than 200k give me an error outofmemoryexception. Is there any way to append data into database from a file splitted in two. the first time I can use SqlBulkCopy, but to append second file into my table.
View 1 RepliesI've got an .rdlc report which I print from my .net app (C# Visual Studio 2005), where I use a RemoteReportPrinter object. I give it as parameters the server name, report name, report parameters, etc. Works fine. My question is, I would live to do an analagous export of that report to Excel. Set it up exactly the same, but have it export to Excel rather than print, probably using some other type of object than RemoteReportPrinter.
View 1 Replies