Unhandled exception:Bucket SST Offset can not be larger then MAX record size. On each Continue Record offset must be started from zero.

[Marco Ensing]

I''ve been using the Excel R/W feature for a while and no problems, till today. Anybody has a clue how to go on from here? Marco An unhandled exception of type ''System.ArgumentOutOfRangeException'' occurred in syncfusion.excelrw.dll Additional information: Bucket SST Offset can not be larger then MAX record size. On each Continue Record offset must be started from zero. ---------------------- See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.ArgumentOutOfRangeException: Bucket SST Offset can not be larger then MAX record size. On each Continue Record offset must be started from zero. Parameter name: BucketSSTOffset Actual value was 8225. at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTInfoSubRecord.set_BucketSSTOffset(UInt16 value) at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTRecord.UpdateOffsets(ArrayList records) at Syncfusion.ExcelRW.Parser.Biff_Records.OffsetArrayList.UpdateBiffRecordsOffsets() at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName) at Reporting.ReportingView.btnExportTermReport_Click(Object sender, EventArgs e) at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) ************** Loaded Assemblies ************** mscorlib ---------------------------------------- xxx---------------------------------------- System.Windows.Forms Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll ---------------------------------------- System Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll ---------------------------------------- xxx---------------------------------------- System.Data Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll ---------------------------------------- System.Xml Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll ---------------------------------------- System.Drawing Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll ---------------------------------------- Syncfusion.Tools Assembly Version: 2.0.2.1 Win32 Version: 2.0.2.1 CodeBase: file:///c:/windows/assembly/gac/syncfusion.tools/2.0.2.1__3d67ed1f87d44c89/syncfusion.tools.dll ---------------------------------------- Syncfusion.Shared Assembly Version: 2.0.2.1 Win32 Version: 2.0.2.1 CodeBase: file:///c:/windows/assembly/gac/syncfusion.shared/2.0.2.1__3d67ed1f87d44c89/syncfusion.shared.dll ---------------------------------------- xxx ---------------------------------------- xxx ---------------------------------------- Syncfusion.Edit Assembly Version: 2.0.2.1 Win32 Version: 2.0.2.1 CodeBase: file:///c:/windows/assembly/gac/syncfusion.edit/2.0.2.1__3d67ed1f87d44c89/syncfusion.edit.dll ---------------------------------------- Syncfusion.Grid Assembly Version: 2.0.2.1 Win32 Version: 2.0.2.1 CodeBase: file:///c:/windows/assembly/gac/syncfusion.grid/2.0.2.1__3d67ed1f87d44c89/syncfusion.grid.dll ---------------------------------------- Accessibility Assembly Version: 1.0.5000.0 Win32 Version: 1.1.4322.573 CodeBase: file:///c:/windows/assembly/gac/accessibility/1.0.5000.0__b03f5f7f11d50a3a/accessibility.dll ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- Syncfusion.ExcelRW Assembly Version: 2.0.2.1 Win32 Version: 2.0.2.1 CodeBase: file:///c:/windows/assembly/gac/syncfusion.excelrw/2.0.2.1__3d67ed1f87d44c89/syncfusion.excelrw.dll ---------------------------------------- RegexAssembly59_0 Assembly Version: 0.0.0.0 Win32 Version: n/a CodeBase: ---------------------------------------- ************** JIT Debugging ************** To enable just in time (JIT) debugging, the config file for this application or machine (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the machine rather than being handled by this dialog.

[Marco Ensing]

I made a workaround that every sheet is saved in a different xls file. That worked.

I had 5 sheets with cells dimensions:

startRow 2, endRow2, startColumn1, endColumn4
startRow 2, endRow10, startColumn1, endColumn4
startRow 2, endRow115, startColumn1, endColumn4
startRow 2, endRow93, startColumn1, endColumn4
startRow 2, endRow153, startColumn1, endColumn4

So we have a scalibilty issue in the syncfusion component. Don''t know if it is still in time for the big release?

Keep up the good work.

Regards,

Marco

[greg ware]

We just started getting this message as well, but all of our reports write to sheet1 only, and the particular report in question is only about 500 rows, 10 columns (i.e. nothing too taxing). Any suggestions?

>I made a workaround that every sheet is saved in a different xls file. That worked.
>
>I had 5 sheets with cells dimensions:
>
>startRow 2, endRow2, startColumn1, endColumn4
>startRow 2, endRow10, startColumn1, endColumn4
>startRow 2, endRow115, startColumn1, endColumn4
>startRow 2, endRow93, startColumn1, endColumn4
>startRow 2, endRow153, startColumn1, endColumn4
>
>So we have a scalibilty issue in the syncfusion component. Don''t know if it is still in time for the big release?
>
>Keep up the good work.
>
>Regards,
>
>Marco
>
>

[Administrator]

Hi Greg,

1) Which version of Essential ExcelRW are you using?

2) If possible, could you please send the sample so that I can test it with the latest internal build.

Thanks.

Best regards,

Stephen.

>We just started getting this message as well, but all of our reports write to sheet1 only, and the particular report in question is only about 500 rows, 10 columns (i.e. nothing too taxing). Any suggestions?
>
>
>>I made a workaround that every sheet is saved in a different xls file. That worked.
>>
>>I had 5 sheets with cells dimensions:
>>
>>startRow 2, endRow2, startColumn1, endColumn4
>>startRow 2, endRow10, startColumn1, endColumn4
>>startRow 2, endRow115, startColumn1, endColumn4
>>startRow 2, endRow93, startColumn1, endColumn4
>>startRow 2, endRow153, startColumn1, endColumn4
>>
>>So we have a scalibilty issue in the syncfusion component. Don''t know if it is still in time for the big release?
>>
>>Keep up the good work.
>>
>>Regards,
>>
>>Marco
>>
>>

[[email protected]]

Hi Stephen,

we are also facing the same issue right now.
the error is:

Bucket SST Offset can not be larger then MAX record size. On each Continue Record offset must be started from zero. Parameter name: BucketSSTOffset Actual value was 8229.
at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTInfoSubRecord.set_BucketSSTOffset(UInt16 value)
at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTRecord.UpdateOffsets(ArrayList records)
at Syncfusion.ExcelRW.Parser.Biff_Records.OffsetArrayList.UpdateBiffRecordsOffsets()
at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName, ExcelSaveType saveType)
at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName)

1. Can you please let us know why this problem is occuring and how to over come it?
2. for the error report by Mr.l.a.marco(previous) have you found any workarround or any fix.
3. this problem is very critical, if you could give us the direct contact No:, thatwould be great.

Thanks
Prabhakar

>Hi Greg,
>
>1) Which version of Essential ExcelRW are you using?
>
>2) If possible, could you please send the sample so that I can test it with the latest internal build.
>
>Thanks.
>
>Best regards,
>
>Stephen.
>
>>We just started getting this message as well, but all of our reports write to sheet1 only, and the particular report in question is only about 500 rows, 10 columns (i.e. nothing too taxing). Any suggestions?
>>
>>
>>>I made a workaround that every sheet is saved in a different xls file. That worked.
>>>
>>>I had 5 sheets with cells dimensions:
>>>
>>>startRow 2, endRow2, startColumn1, endColumn4
>>>startRow 2, endRow10, startColumn1, endColumn4
>>>startRow 2, endRow115, startColumn1, endColumn4
>>>startRow 2, endRow93, startColumn1, endColumn4
>>>startRow 2, endRow153, startColumn1, endColumn4
>>>
>>>So we have a scalibilty issue in the syncfusion component. Don''t know if it is still in time for the big release?
>>>
>>>Keep up the good work.
>>>
>>>Regards,
>>>
>>>Marco
>>>
>>>

[Administrator]

Hi Prabhakar,

I am afraid, this issue has not been reproduced in-house yet. However, a customer who had reported this issue when using version 2.1.0.9 did not see the problem in version 3.0. If you are using a version prior to version 3.2.1.0, then please try upgrading to this version. If the problem exists is version 3.2.1.0 then please send us a sample so that we can resolve this issue as soon as possible.

Thanks,

Stephen.

>Hi Stephen,
>
>we are also facing the same issue right now.
>the error is:
>
>Bucket SST Offset can not be larger then MAX record size. On each Continue Record offset must be started from zero. Parameter name: BucketSSTOffset Actual value was 8229.
>at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTInfoSubRecord.set_BucketSSTOffset(UInt16 value)
>at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTRecord.UpdateOffsets(ArrayList records)
>at Syncfusion.ExcelRW.Parser.Biff_Records.OffsetArrayList.UpdateBiffRecordsOffsets()
>at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName, ExcelSaveType saveType)
>at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName)
>
>1. Can you please let us know why this problem is occuring and how to over come it?
>2. for the error report by Mr.l.a.marco(previous) have you found any workarround or any fix.
>3. this problem is very critical, if you could give us the direct contact No:, thatwould be great.
>
>Thanks
>Prabhakar
>
>
>>Hi Greg,
>>
>>1) Which version of Essential ExcelRW are you using?
>>
>>2) If possible, could you please send the sample so that I can test it with the latest internal build.
>>
>>Thanks.
>>
>>Best regards,
>>
>>Stephen.
>>
>>>We just started getting this message as well, but all of our reports write to sheet1 only, and the particular report in question is only about 500 rows, 10 columns (i.e. nothing too taxing). Any suggestions?
>>>
>>>
>>>>I made a workaround that every sheet is saved in a different xls file. That worked.
>>>>
>>>>I had 5 sheets with cells dimensions:
>>>>
>>>>startRow 2, endRow2, startColumn1, endColumn4
>>>>startRow 2, endRow10, startColumn1, endColumn4
>>>>startRow 2, endRow115, startColumn1, endColumn4
>>>>startRow 2, endRow93, startColumn1, endColumn4
>>>>startRow 2, endRow153, startColumn1, endColumn4
>>>>
>>>>So we have a scalibilty issue in the syncfusion component. Don''t know if it is still in time for the big release?
>>>>
>>>>Keep up the good work.
>>>>
>>>>Regards,
>>>>
>>>>Marco
>>>>
>>>>

[Administrator]

>I''ve been using the Excel R/W feature for a while and no problems, till today. Anybody has a clue how to go on from here?
>
>Marco
>
>
>An unhandled exception of type ''System.ArgumentOutOfRangeException'' occurred in syncfusion.excelrw.dll
>
>Additional information: Bucket SST Offset can not be larger then MAX record size. On each Continue Record offset must be started from zero.
>
>----------------------
>
>See the end of this message for details on invoking
>just-in-time (JIT) debugging instead of this dialog box.
>
>************** Exception Text **************
>System.ArgumentOutOfRangeException: Bucket SST Offset can not be larger then MAX record size. On each Continue Record offset must be started from zero.
>Parameter name: BucketSSTOffset
>Actual value was 8225.
> at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTInfoSubRecord.set_BucketSSTOffset(UInt16 value)
> at Syncfusion.ExcelRW.Parser.Biff_Records.ExtSSTRecord.UpdateOffsets(ArrayList records)
> at Syncfusion.ExcelRW.Parser.Biff_Records.OffsetArrayList.UpdateBiffRecordsOffsets()
> at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName)
> at Reporting.ReportingView.btnExportTermReport_Click(Object sender, EventArgs e)
> at System.Windows.Forms.Control.OnClick(EventArgs e)
> at System.Windows.Forms.Button.OnClick(EventArgs e)
> at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
> at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
> at System.Windows.Forms.Control.WndProc(Message& m)
> at System.Windows.Forms.ButtonBase.WndProc(Message& m)
> at System.Windows.Forms.Button.WndProc(Message& m)
> at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
> at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
>
>
>************** Loaded Assemblies **************
>mscorlib
>----------------------------------------
>xxx----------------------------------------
>System.Windows.Forms
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.573
> CodeBase: file:///c:/windows/assembly/gac/system.windows.forms/1.0.5000.0__b77a5c561934e089/system.windows.forms.dll
>----------------------------------------
>System
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.573
> CodeBase: file:///c:/windows/assembly/gac/system/1.0.5000.0__b77a5c561934e089/system.dll
>----------------------------------------
>xxx----------------------------------------
>System.Data
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.573
> CodeBase: file:///c:/windows/assembly/gac/system.data/1.0.5000.0__b77a5c561934e089/system.data.dll
>----------------------------------------
>System.Xml
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.573
> CodeBase: file:///c:/windows/assembly/gac/system.xml/1.0.5000.0__b77a5c561934e089/system.xml.dll
>----------------------------------------
>System.Drawing
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.573
> CodeBase: file:///c:/windows/assembly/gac/system.drawing/1.0.5000.0__b03f5f7f11d50a3a/system.drawing.dll
>----------------------------------------
>Syncfusion.Tools
> Assembly Version: 2.0.2.1
> Win32 Version: 2.0.2.1
> CodeBase: file:///c:/windows/assembly/gac/syncfusion.tools/2.0.2.1__3d67ed1f87d44c89/syncfusion.tools.dll
>----------------------------------------
>Syncfusion.Shared
> Assembly Version: 2.0.2.1
> Win32 Version: 2.0.2.1
> CodeBase: file:///c:/windows/assembly/gac/syncfusion.shared/2.0.2.1__3d67ed1f87d44c89/syncfusion.shared.dll
>----------------------------------------
>xxx
>----------------------------------------
>xxx
>----------------------------------------
>Syncfusion.Edit
> Assembly Version: 2.0.2.1
> Win32 Version: 2.0.2.1
> CodeBase: file:///c:/windows/assembly/gac/syncfusion.edit/2.0.2.1__3d67ed1f87d44c89/syncfusion.edit.dll
>----------------------------------------
>Syncfusion.Grid
> Assembly Version: 2.0.2.1
> Win32 Version: 2.0.2.1
> CodeBase: file:///c:/windows/assembly/gac/syncfusion.grid/2.0.2.1__3d67ed1f87d44c89/syncfusion.grid.dll
>----------------------------------------
>Accessibility
> Assembly Version: 1.0.5000.0
> Win32 Version: 1.1.4322.573
> CodeBase: file:///c:/windows/assembly/gac/accessibility/1.0.5000.0__b03f5f7f11d50a3a/accessibility.dll
>----------------------------------------
>----------------------------------------
>----------------------------------------
>----------------------------------------
>----------------------------------------
>Syncfusion.ExcelRW
> Assembly Version: 2.0.2.1
> Win32 Version: 2.0.2.1
> CodeBase: file:///c:/windows/assembly/gac/syncfusion.excelrw/2.0.2.1__3d67ed1f87d44c89/syncfusion.excelrw.dll
>----------------------------------------
>RegexAssembly59_0
> Assembly Version: 0.0.0.0
> Win32 Version: n/a
> CodeBase:
>----------------------------------------
>
>************** JIT Debugging **************
>To enable just in time (JIT) debugging, the config file for this
>application or machine (machine.config) must have the
>jitDebugging value set in the system.windows.forms section.
>The application must also be compiled with debugging
>enabled.
>
>For example:
>
>
>
>
>
>When JIT debugging is enabled, any unhandled exception
>will be sent to the JIT debugger registered on the machine
>rather than being handled by this dialog.
>
>
>please help having the problem indicated. keep getting: when jit debugging is enabled, any unhandled exception will be sent to the jit debugger registered on the machine rather than being handled by this dilog.

Need help sovling this problem.
call davd # 2-347-365-5853
or post instructions: [email protected]

thank you kindly

Mr. david rivers