IBM Support

Error 'Not enough memory' when Refreshing (F9) Excel link report

Troubleshooting


Problem

User launches Excel. User opens Excel link report (.XLS spreadsheet file). User clicks 'Controller - Logon'. User logs onto Controller. User clicks on 'Controller - Reports - Refresh F9'. Report takes a few minutes, but works OK. Afterwards, user *again* clicks on 'Controller - Reports - Refresh F9'. After a few minutes, an error message appears. If the user clicks OK, another error messages appears. If the user clicks OK, another error messages appears... NOTE: * For Office 2000, the problem may appear after only a few successive refreshes (e.g. 2) * For Office XP, the problem may appear after only a few more successive refreshes (e.g. 5) * For Office 2003, the problem may require multiple successive refreshes (e.g. 21)

Symptom

The error messages are different, depending on which version of Excel the client PC is using:


** Excel 2000 **

Error #1, 2, 3, ....10:
    Microsoft Excel
    Not enough memory.
    OK

Error #11:
    Information
    Standard Error
    Number: -2147467261
    Source: interop.Excel
    Description: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
    OK

Error #12:
    Information
    Standard Error
    Number: -2147467261
    Source: interop.Excel
    Description: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
    OK

Error #13:
    Microsoft Excel
    Not enough system resources to display completely.
    OK

Error #14, 15, 16...
    Microsoft Excel
    Not enough memory.
    OK

Error #17:
    Information
    Standard Error
    Number: 7
    Source: interop.Excel
    Description: Insufficient memory to continue the execution of the program.
    OK

** Excel XP (2002) **

Microsoft Excel
Excel cannot complete this task with available resources. Choose less data or close other applications.
OK

** Excel 2003 **

IBM Cognos 8 Controller Link
Exception of type 'System.OutOfMemoryException' was thrown.
OK

Cognos 8 Controller Link
Out of memory
OK

Microsoft Visual C++ Runtime Library
Runtime Error!
Program: C:\Program Files\Microsoft Office\Office11\Excel.exe
This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information
OK

CiceroUIWndFrame: Excel.exe - Application error
The exception unknown software exception (0x40000015) occurred in the application at location 0x54b48b37.
Click on OK to terminate the program
Click on CANCEL to debug the program
OK Cancel

TIP: There also may be entries inside the Event Log on client PC, similar to:
    Event Type: Error
    Event Source: Application Error
    Event Category: (100)
    Event ID: 1000
    Date: 14/03/2008
    Time: 16:25:16
    User: N/A
    Computer: SERVERNAME
    Description:
    Faulting application EXCEL.EXE, version 11.0.6560.0, faulting module pdm.dll, version 8.0.50727.42, fault address 0x00028b37.

[{"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;8.4;8.3;10.1;10.1.1","Edition":"Not Applicable","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.

Historical Number

1038666

Document Information

Modified date:
08 May 2025

UID

swg21365015

Page Feedback