We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

11662 Mar 12,2004 02:42 PM UTC Aug 8,2006 09:36 AM UTC Windows Forms 6
loading
Tags: XlsIO
Marco Ensing
Asked On March 12, 2004 02:42 PM UTC

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
Replied On March 12, 2004 03:25 PM UTC

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
Replied On November 9, 2004 04:00 PM UTC

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 [Syncfusion]
Replied On November 9, 2004 08:43 PM UTC

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 >> >>

Prabhakar.krishna@kla-tencor.com
Replied On May 23, 2005 07:55 PM UTC

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 [Syncfusion]
Replied On May 26, 2005 03:28 AM UTC

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 [Syncfusion]
Replied On August 8, 2006 09:36 AM UTC



>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: rivers_david24@yahoo.com

thank you kindly

Mr. david rivers

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;