If you create a Read-Only (OLAP) table in SAS Financial Management, you might encounter an Out of Memory condition if the table has nested dimensions on the rows. This might occur if you attempt to create a new table or pivot an existing table, particularly if at least one of the nested dimensions includes many dimension members.
The Out of Memory condition is typically seen in the AMO log or might be displayed in an on-screen dialog box, such as a .NET Framework error. The contents of the error message typically include:
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder..ctor(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder..ctor(String value, Int32 capacity)
at System.Windows.Forms.Control.get_WindowText()
at System.Windows.Forms.TextBoxBase.get_WindowText()
at System.Windows.Forms.TextBoxBase.ScrollToCaret()
at SAS.CLRUtilities.MessageLog.WriteLine(String msg)
or
Failure in StateProvider.
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap(QueryChunkMember qcm, QueryChunkMember[] vector, ArrayList vectors, Int32 depth)
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap(QueryChunkMember qcm, QueryChunkMember[] vector, ArrayList vectors, Int32 depth)
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap(QueryChunkMember qcm, QueryChunkMember[] vector, ArrayList vectors, Int32 depth)
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap(QueryChunkMember qcm, QueryChunkMember[] vector, ArrayList vectors, Int32 depth)
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap(QueryChunkMember qcm, QueryChunkMember[] vector, ArrayList vectors, Int32 depth)
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap(QueryChunkMember qcm, QueryChunkMember[] vector, ArrayList vectors, Int32 depth)
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.produceMap()
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.getQueryChunkMember(Int32 hierarchyIndex, Int32 memberIndex)
at Com.Sas.Ses.OfficeIntegration.Model.QueryChunk.getMember(Int32 hierarchyIndex, Int32 memberIndex)
at Com.Sas.Ses.OfficeIntegration.View.Table.getMember(ViewCoordinate vcoord)
at SASSESExcelAddIn.ClientState.isCoordinateOk(ClientStateItem clientItem, Object userData)
at Com.Sas.Ses.OfficeIntegration.Model.FMStateProvider.itemReturnState(ClientStateItem item, Object userData)
This is a client-side error, and the server logs do not reveal this error.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This is marked as fixed in SAS Financial Management 5.3.
For additional information please contact SAS Technical Support.
For information about enabling the AMO log, please refer to SAS Note 19846.
For default SAS Financial Management log locations, please refer to SAS Note 20058.
Operating System and Release Information
SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2008 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows XP Professional | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Windows Vista | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
Windows Vista for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
*
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.