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"}}]

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

Modified date:
08 May 2025

UID

swg21588640