Export Error in Firefox

[Rob ONeill]

Hi,

I can get an error when exporting a grid in Firefox (but only inconsistently)

Selected the ‘Export to Excel’ button within a FF browser and the following error was thrown:

‘An unhandled Microsoft .NET Framework exception occurred in w3wp.exe [40604]’

An unhandled exception of type 'System.NullReferenceException' occurred in Syncfusion.XlsIO.Base.dll

See attached image of the error we get.

Any ideas ?

Cheers ... Rob.

Attachment: FF_export_e5d28fd3.zip

[Prasanna Kumar Viswanathan]

Hi Rob,

 

Thanks for contacting Syncfusion support.

 

Query : “An unhandled Microsoft .NET Framework exception occurred in w3wp.exe [40604]”

 

This exception is caused by the updates of .Net Framework 4.5. To resolve the issue, refer to the below link and uninstall the last update.

 

http://anishantha87.blogspot.in/2014/09/an-unhandled-microsoft-net-framework.html

Aruna Nishantha's blogspot: An unhandled Microsoft .NET ... An unhandled Microsoft .NET Framework exception occurred in w3wp.exe I encountered this error while developing a website with web forms in asp.net 4.5.1 I ran it with ... Read more...

 

Query : “An unhandled exception of type 'System.NullReferenceException' occurred in Syncfusion.XlsIO.Base.dll”

 

We created a sample in exporting but we are unable to reproduce the mentioned exception. So please confirm the following details

 

1.       Are you performing any filter/sorting operation before exporting?

 

2.       Is this exception throws only in excel exporting?

 

3.       Share the code example.

 

4.        Essential Studio version details.

 

Please find the attached sample

 

Sample Link: http://www.syncfusion.com/downloads/support/forum/121111/ze/Sample142103850084694

 

Try the above sample and still if you face the issue, please reproduce the issue in the above sample and get back to us.

 

Regards,

Prasanna Kumar N.S.V

[Rob ONeill]

Hi,

The error I get is An unhandled Microsoft .NET Framework exception occurred in w3wp.exe  and then if I debug the exception it says the error is An unhandled exception of type 'System.NullReferenceException' occurred in Syncfusion.XlsIO.Base.dll

It is all part of the same error.

The exception only seems to be thrown on the export, and with Firefox. It happens without sorting or grouping, and our version is 13.3.0.7

Cheers ... Rob.

[Prasanna Kumar Viswanathan]

Hi Rob,

We have tried with mentioned version but we are unable to reproduce the issue. So, please provide the following details to provide a prompt solution.

1.       Are you using any adapters like URL or RemoteSave adapter?

2.       Share the code example.

3.       A sample or modify the attached sample.

4.       Please confirm this exception whether it has been thrown while exporting to Excel? Please find the screenshot,

               This exception will throw when there is mismatch in the columns and datasource of exporting data. So, please ensure that there is no mismatch in the datasource.




Sample: http://www.syncfusion.com/downloads/support/forum/121111/ze/Sample142103_(2)1432083486

Regards,
Prasanna Kumar N.S.V

---

RO Rob ONeill November 18, 2015 03:21 PM UTC

Hi,

Further examination, and we have this error in the log ....

Exception Info: System.NullReferenceException

Stack:

   at Syncfusion.XlsIO.Implementation.ApplicationImpl.get_IsSaved()

   at Syncfusion.XlsIO.Implementation.WorkbookImpl.Close(Boolean, System.String)

   at Syncfusion.XlsIO.Implementation.WorkbookImpl.Finalize()

Is the finalize method trying to set a property that is null ?

1.       Are you using any adapters like URL or RemoteSave adapter? No

2.       Share the code example. We can't share our code and can't reproduce it in your example code

4.       Please confirm this exception whether it has been thrown while exporting to Excel? Please find the screenshot, Yes it is

Hope this helps

Cheers ... Rob.

---

PK Prasanna Kumar Viswanathan Syncfusion Team November 19, 2015 12:18 PM UTC

Hi Rob

IsSaved property is used to identify whether the workbook is saved or not. The reported exception will throw when a workbook in workbooks collection is Null. When the memory usage of the application increases, the garage collector will dispose the unused objects. So an unused workbook might be disposed in workbooks collection, which might lead to this exception. 

It would be grateful if you could share the number of rows and columns that you are exporting. If the limit is more, try to reduce the rows and columns count while exporting and check whether the issue is reproduced or not.

Regards,
Prasanna Kumar N.S.V

SIGN IN To post a reply.

[Rob ONeill]

Hi,

Further examination, and we have this error in the log ....

Exception Info: System.NullReferenceException

Stack:

   at Syncfusion.XlsIO.Implementation.ApplicationImpl.get_IsSaved()

   at Syncfusion.XlsIO.Implementation.WorkbookImpl.Close(Boolean, System.String)

   at Syncfusion.XlsIO.Implementation.WorkbookImpl.Finalize()

Is the finalize method trying to set a property that is null ?

1.       Are you using any adapters like URL or RemoteSave adapter? No

2.       Share the code example. We can't share our code and can't reproduce it in your example code

4.       Please confirm this exception whether it has been thrown while exporting to Excel? Please find the screenshot, Yes it is

Hope this helps

Cheers ... Rob.

[Prasanna Kumar Viswanathan]

Hi Rob

IsSaved property is used to identify whether the workbook is saved or not. The reported exception will throw when a workbook in workbooks collection is Null. When the memory usage of the application increases, the garage collector will dispose the unused objects. So an unused workbook might be disposed in workbooks collection, which might lead to this exception. 

It would be grateful if you could share the number of rows and columns that you are exporting. If the limit is more, try to reduce the rows and columns count while exporting and check whether the issue is reproduced or not.

Regards,
Prasanna Kumar N.S.V