Troubleshooting
Problem
"IBM Planning Analytics Spreadsheet Services" service (PASS, TM1 Web) is crashing.
Each crash generates a core*.dmp file and a javacore*.txt file in the \tm1web\bin64 directory.
In the javacore file or in the console.log file (\ibm\cognos\tm1web\wlp\usr\servers\tm1web\logs), the following exception appears:
java.lang.OutOfMemoryError: java heap size
Cause
Insufficient maximum Java heap size defined in jvm.options
Resolving The Problem
From \ibm\cognos\tm1web\wlp\usr\servers\tm1web directory, open jvm.options
Find -Xmx parameter and increase it.
For example, change this line:
-Xmx4096m
Into this line:
-Xmx8192m
Save the file and restart the "IBM Planning Analytics Spreadsheet Services" service.
Finding a good value for Xmx parameter depends on the following elements:
- The total memory and free memory on the server machine: this information can be obtained in Windows Task Manager, in "Performance" tab
- The size and complexity of the TM1 model
- The number of TM1 Web users
- What users are doing. More memory is needed:
- If the application contains numerous Excel websheets, or few large Excel websheets.
- If the Excel websheets make extensive use of conditional formatting
- If some formatting was wrongly applied to numerous empty cells. In that case, Excel files that were supposed to be small are taking more memory than really needed. The same solution as in this other document can be applied:
Small Excel report fails in TM1 Web with: "Limits exceeded", "exceeds maximum cell count", "exceeds the configured maximum memory limit"
Small Excel report fails in TM1 Web with: "Limits exceeded", "exceeds maximum cell count", "exceeds the configured maximum memory limit"
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":"a8m3p000000PC7jAAG","label":"Planning Analytics-\u003EWeb PASS Contributor Application-\u003EPerformance Memory"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
18 January 2023
UID
ibm16856169