SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 44761: ERROR: Serious error trying to go offline. The workbook has not been taken off line because of errors.

DetailsHotfixAboutRate It

The following error might occur when you attempt to check out a form using the SAS® Solutions Services Add-In for Microsoft Office "Check Out Form" option. 

Serious error trying to go offline. The workbook has not been taken off line because of errors.

If you encounter this error, follow the instructions in SAS Usage Note 19846 (http://support.sas.com/kb/19/846.html) to generate the SAS® Add-In for Microsoft Office (AMO) log. 

Consider reducing the size of the form if the AMO log shows errors similar to the following:

[06/06/2011 13:10:43] Failure during offline data scan.
[06/06/2011 13:10:43] System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.Data.Index.MaintainDataView(ListChangedType changedType, Int32 record, Boolean trackAddRemove)
at System.Data.Index.InsertRecord(Int32 record, Boolean fireEvent)
at System.Data.Index.ApplyChangeAction(Int32 record, Int32 action, Int32 changeRecord)
at System.Data.DataTable.RecordStateChanged(Int32 record1, DataViewRowState oldState1, DataViewRowState newState1, Int32 record2, DataViewRowState oldState2, DataViewRowState newState2)
at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
at System.Data.DataRowCollection.Add(DataRow row)
at Com.Sas.Ses.OfficeIntegration.View.Book.scrapeZeroes(QueryResult ors, SingleDimAxis[] SDAs, PerfTimer diskSave)
[06/06/2011 13:10:43] ----------- END OF EXCEPTION REPORT ------------
[06/06/2011 13:10:43] VSTA_Main: Number of non-zero values saved: 3415924
[06/06/2011 13:10:47] --------------- EXCEPTION REPORT ---------------
[06/06/2011 13:10:47] Failure trying to save local state for going offline.
[06/06/2011 13:10:47] System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.

 

There is no full work-around for this issue.

Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Financial ManagementMicrosoft Windows 2000 Advanced Server5.25.39.1 TS1M2
Microsoft Windows 2000 Datacenter Server5.25.39.1 TS1M2
Microsoft Windows 2000 Server5.25.39.1 TS1M2
Microsoft Windows 2000 Professional5.25.39.1 TS1M2
Microsoft Windows NT Workstation5.25.39.1 TS1M2
Microsoft Windows Server 2003 Datacenter Edition5.25.39.1 TS1M2
Microsoft Windows Server 2003 Enterprise Edition5.25.39.1 TS1M2
Microsoft Windows Server 2003 Standard Edition5.25.39.1 TS1M2
Microsoft Windows XP Professional5.25.39.1 TS1M2
64-bit Enabled AIX5.25.39.1 TS1M2
64-bit Enabled Solaris5.25.39.1 TS1M2
Linux for x645.25.39.1 TS1M2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.