Troubleshooting
Problem
Although WorkbookMaxCellCount parameter was set to a high value (for example 2,000,000), a small report with far less data cells is throwing this error in TM1 Web or Planning Analytics Spreadsheet Services:
Limits exceeded
The action has been terminated because it exceeds the configured maximum memory limit.
The action has been terminated because it exceeds the configured maximum memory limit.
tm1web.log contains this kind of message:
2021-10-15 17:53:51,726 [Default Executor-thread-6954] ERROR () com.ibm.cognos.tm1.publish.Workbook - [] Workbook TM1://appli/blob/PUBLIC/.\}externals\TM19246.xlsx_20210420133745.xlsx exceeds maximum cell count.
Or
There is no error, but the websheet is abnormally slow in TM1 Web (performance issue)
Cause
At least on one sheet, cells from empty columns on the right of the report are taken into account because some format was applied to them by mistake.
Resolving The Problem
In either TM1 Perspectives or Planning Analytics for Excel, in each sheet that needs it, delete all empty columns on the right of the existing report. Easy steps:
- Zoom out in order to get a better picture of the report
- Select a column very close to the right limit of the report
- Maintain Shift+Control keys and press the right-arrow key from the keyboard: it selects all columns from here to the end.
- Right-click in that selection and select "Delete"
- Save the report and republish it to TM1 Web
The report now opens in TM1 Web with no problem, and even more quickly.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m50000000KzKhAAK","label":"Planning Analytics for Microsoft Excel-\u003EReporting"},{"code":"a8m0z000000blfjAAA","label":"Troubleshooting"},{"code":"a8m0z0000001i7nAAA","label":"perspective"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m3p000000PC7WAAW","label":"Planning Analytics-\u003EPerspectives-\u003EPerformance"},{"code":"a8m3p000000PC8sAAG","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel-\u003EPerformance"},{"code":"a8m3p000000PC7eAAG","label":"Planning Analytics-\u003EPlanning Analytics Workspace-\u003EPerformance"},{"code":"a8m3p000000PC7XAAW","label":"Planning Analytics-\u003EWeb PASS Contributor Application"},{"code":"a8m3p000000PC7jAAG","label":"Planning Analytics-\u003EWeb PASS Contributor Application-\u003EPerformance Memory"}],"Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
10 February 2023
UID
ibm16508515