I am getting System Out of Memory Exception. Need assistance how to resolve this issue. below are issue details.
System.outOfMemoryException: Exception of type
'System.OutOfMemory' was thrown.
at System.Diagnostics.NtProcessInfoHelper.GetProcessInfoS(IntPtrdataPtr)
at System.Diagnostics.NtProcessInfoHelper.GetProcessInfoS()
at System.Diagnostics.ProcessManager.GetProcessInfoS(String MachinName)
at System.Diagnostics.Process.EnsureStste(State state)
at System.Diagnostics.Process.get_MinWindowHandle()
at System.Diagnostics.Process.closeMainWindow()
at MS_ExcelVBO.CloseInstance(Int32 Handle, Boolean SaveWorkbooks)
at MS_ExcelVBO.CloseInstance(Decimal handle, Boolean Savechanges)
Either your PC spec is too low, or more likely the process you are running is doing something to consume all the available memory. Try enabling the memory logging feature, reboot, then run the process to induce the problem again, then study the logs to see where the build up is.
I am facing the same problem. I have 8GB Ram on all the resources. I am using Select on filter query on collection where I am getting this error. Can I use GC action from C# object after each stage to make sure memory is released.
It has to be what your process is doing that is easting memory. Study the session logs to see how/where the memory builds up. If the Excel files you are using are very large, it could be that you need to take a different approach that does not handle all the data all at once.
It is not about memory. I have done the RCA on this reducing the data and avoiding calculation with in collection can solve your issue. Pass data in collection in small chunks instead of large data.Hope it will help you.