This project has moved. For the latest updates, please go here.

Complex issue Problem with IsolatedStorage while downloading Excel

Dec 10, 2012 at 7:22 AM
Edited Dec 10, 2012 at 1:28 PM

Hi

We have hosted our website on two severs U1 and P1.

We are able to generate excel of more than 35MB on U1 and also few other excels on P1.

We have a problem with generating saving our excel data. This only happens with some queries, but not with others. And it works perfectly in U1.

Does anyone have any idea what we can do to get around this?

Unable to create the store directory. (Exception from HRESULT: 0x80131468)

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.IO.IsolatedStorage.IsolatedStorageException: Unable to create the store directory. (Exception from HRESULT: 0x80131468)

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: 

[IsolatedStorageException: Unable to create the store directory. (Exception from HRESULT: 0x80131468)]
   System.IO.IsolatedStorage.IsolatedStorageFile.GetRootDir(IsolatedStorageScope scope, StringHandleOnStack retRootDir) +0
   System.IO.IsolatedStorage.IsolatedStorageFile.InitGlobalsNonRoamingUser(IsolatedStorageScope scope) +148
   System.IO.IsolatedStorage.IsolatedStorageFile.GetRootDir(IsolatedStorageScope scope) +229
   System.IO.IsolatedStorage.IsolatedStorageFile.GetGlobalFileIOPerm(IsolatedStorageScope scope) +213
   System.IO.IsolatedStorage.IsolatedStorageFile.Init(IsolatedStorageScope scope) +53
   System.IO.IsolatedStorage.IsolatedStorageFile.GetStore(IsolatedStorageScope scope, Type domainEvidenceType, Type assemblyEvidenceType) +68
   MS.Internal.IO.Packaging.ReliableIsolatedStorageFileFolder.GetCurrentStore() +34
   MS.Internal.IO.Packaging.ReliableIsolatedStorageFileFolder..ctor() +64
   MS.Internal.IO.Packaging.PackagingUtilities.GetDefaultIsolatedStorageFile() +54
   MS.Internal.IO.Packaging.PackagingUtilities.CreateUserScopedIsolatedStorageFileStreamWithRandomName(Int32 retryCount, String& fileName) +122
   MS.Internal.IO.Packaging.SparseMemoryStream.SwitchModeIfNecessary() +373
   MS.Internal.IO.Packaging.SparseMemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count) +189
   MS.Internal.IO.Packaging.CompressEmulationStream.Write(Byte[] buffer, Int32 offset, Int32 count) +60
   MS.Internal.IO.Packaging.CompressStream.Write(Byte[] buffer, Int32 offset, Int32 count) +138
   MS.Internal.IO.Zip.ProgressiveCrcCalculatingStream.Write(Byte[] buffer, Int32 offset, Int32 count) +170
   MS.Internal.IO.Zip.ZipIOModeEnforcingStream.Write(Byte[] buffer, Int32 offset, Int32 count) +86
   System.IO.StreamWriter.Flush(Boolean flushStream, Boolean flushEncoder) +98
   System.IO.StreamWriter.Write(String value) +109
   System.IO.TextWriter.Write(String format, Object arg0) +76
   OfficeOpenXml.ExcelWorksheet.UpdateRowCellData(StreamWriter sw) +6265
   OfficeOpenXml.ExcelWorksheet.SaveXml() +537
   OfficeOpenXml.ExcelWorksheet.Save() +217
   OfficeOpenXml.ExcelWorkbook.Save() +472
   OfficeOpenXml.ExcelPackage.GetAsByteArray(Boolean save) +34
   ACTagging.Admin.DumpExcel(DataTable tbl, String filename, String sheetname) in C:\Users\PSivaShankar\Desktop\DIR Mapping  - V2\ACTagging\Admin.aspx.cs:183
   ACTagging.Admin.BtnExcelReportAdmin_Click(Object sender, CommandEventArgs e) in C:\Users\PSivaShankar\Desktop\DIR Mapping  - V2\ACTagging\Admin.aspx.cs:139
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563


Developer
Dec 11, 2012 at 7:17 PM

There is an issue with large files, IIS and isolated storage. A solution is on the way - the next release will not utlize system.io.packaging (which in its turn uses isolated storage) - but I cannot say when that release will be.

It has been discussed before in this thread: http://epplus.codeplex.com/discussions/215730

Regards, Mats

Dec 12, 2012 at 7:46 AM

Hi Swmal,

We are able download  35MB of file in U1 sever but same file is causing error in P1 sever and one more thing in P1 sever we are able to donwload other excel files.

Dec 12, 2012 at 8:51 PM

I have the same exception with eeplus.
When i try do write a large excel file (~of over 5MB), it's not possible to save the result : IsolatedStorageException.

How it's possible to fix that ?

Editor
Dec 12, 2012 at 9:55 PM

there are two way to fix this:

 

1) add the folder and set the permission as described here > http://labs.episerver.com/en/Blogs/Svante-Seleborg/Dates/2008/10/IsolatedStorage-Access-Denied/

2) try the new (beta) version with DotNetZip instead IO.Packaging > http://epplus.codeplex.com/SourceControl/changeset/view/af16b68ec2e5