IBM Support

"System.OutOfMemoryException" errors when using powerful Microsoft SQL database server with large amounts of RAM

Troubleshooting


Problem

Users intermittently receive errors performing tasks inside Controller. Most commonly, these errors will include the text "System.OutOfMemoryException". However, other (less common) errors may also be seen.

Symptom

Common example:
Excel link:

    Standard Error
    Number: 5
    Source: FrangoDirect.ExcelLinkD.FetchValuesBulk#ControllerProxyClient
    Description: System.Web.Services.Protocols.SoapException: Server was unable to process request.---> System.OutOfMemoryException: Insufficient memory to continue the execution of the program.
    at Cognos.Controller.Proxy.CCRWS.ExcelLinkB_FetchValuesBulk(String.....
    <...>
    [OK]

Rarer examples:
Ad Hoc Reports:
    Standard Error
    Number: 5
    Source: FrangoDirect.ReportAdHocD.AdHocCNR#ControllerProxyClient.frmReportAdHoc....<....>
    Description: System.Web.Services.Protocols.SoapException: Server was unable to process request.---> System.Runtime.InteropServices.COMException (0x80070008): Creating an instance of the COM component with CLSID (xxxxxx) from the IClassFactory failed due to the following error: 80070008.
    at Cognos.Controller.Proxy.CCRWS.ReportAdHoc...
    <....>
    [OK]

Import from Flat Files:
    Standard Error
    Source: ControllerProxyClient
    Description: System.Web.Services.Protocols.SoapException: Server was unable to process request.---> System.Runtime.InteropServices.COMException (0x8004005): Data provider or other service returned an E_FAIL status.
    at FrDImportBT.cls...
    <...>
    [OK]

    Standard Error
    Source: ControllerProxyClient
    Description: System.Web.Services.Protocols.SoapException: Server was unable to process request.---> System.NotSupportedException: Object doesn't support this property of method
    at FrDImportBT.cls......
    <...>
    [OK]
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1;8.5","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Cognos Controller

Software version:
8.5.1, 8.5

Operating system(s):
Windows

Document number:
165193

Modified date:
08 May 2025

UID

swg21506563

Manage My Notification Subscriptions