IBM Support

How to reduce "Out Of Memory" errors when using Excel Link and ERO, by using BULKCOMPRESS

Troubleshooting


Problem

User is receiving "Out Of Memory" errors when using the Excel link. They have tried other methods to solve the problem (e.g. enable Optimise2 / ERO) but they still get errors. Are there any other improvements that they can enable?

Symptom

The error messages will vary (between Controller versions and Microsoft Excel versions) but generally they will include one of the following:
  • System.OutOfMemoryException
  • Out Of Memory

[{"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":"","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"}}]

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 the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. 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, 8.4, 8.3, 10.1, 10.1.1

Operating system(s):
Windows

Document number:
470185

Modified date:
08 May 2025

UID

swg21588640

Manage My Notification Subscriptions