Troubleshooting
Problem
Planning Analytics Workspace books fail to render embedded web sheets with the following error:
"The action has been terminated because it exceeds the configured maximum memory limit error"
"The action has been terminated because it exceeds the configured maximum memory limit error"
Symptom
Cause
The maximum cell count of a workbook to be rendered over Planning Analytics Spreadsheet Services/TM1 Web by default is 500000. Any websheet exceeding the default cell count value will fail to render with error as per screen-print shared above.
Planning Analytics Workspace uses Planning Analytics Spreadsheet Services in the background to render web sheets hence the default cell count value applies to Planning Analytics Workspace books as well.
Resolving The Problem
The maximum cell count of a workbook can be increased by updating below parameter in tm1web_config.xml(webapps\tm1web\WEB-INF\configuration\tm1web_config.xml). The parameter change requires a restart of TM1 application server to become effective.
<add key="WorkbookMaxCellCount" value="500000" />
- Leaving this parameter blank or setting it to less than 0 indicates that an unlimited cell count for workbooks is allowed.
- Before IBM Planning Analytics version 2.0.7, the default value is -1, which indicates an unlimited number of cells are allowed in a workbook.
- As of IBM Planning Analytics version 2.0.7, the default value is 500000.
Note: The value should not be left blank or increased to a very high value in one go. It should instead be increased in small iterations and the book should be reviewed wherever feasible to identify scope of size reduction. Rendering massive books can cause performance degradation.
Related Information
Document Location
Worldwide
[{"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":"a8m50000000KzIzAAK","label":"Planning Analytics Workspace"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
23 May 2022
UID
ibm16405802