Troubleshooting
Problem
A previously working "IBM Planning Analytics Spreadsheet Services" service cannot be started after the server machine was rebooted, or after the service was stopped by script, for example by using this Windows command:
NET STOP tm1web
Or by using this Powershell command:
Stop-Service -force tm1web
The tm1web-stdout.YYY-MM-DD.log contains the following error:
"Failed to start tm1web server"
Cause
The process run by "IBM Planning Analytics Spreadsheet Services" service is "prunsrv.exe".
This process is responsible for running and stopping the javaw.exe, which is in fact the actual "TM1 Web" (based on WebSphere Liberty Profile).
When the "prunsrv.exe" is stopped too quickly, it has no time to properly close "javaw.exe".
Then, at next startup of the service, the running javaw.exe is detected and TM1 Web cannot start.
Resolving The Problem
For an immediate resolution, check again that "IBM Planning Analytics Spreadsheet Services" service is stopped, open Windows Task Manager and kill javaw.exe (by right-click "End task"), and delete the whole content of these directories (which contain WebSphere Liberty temporary files):
C:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web\workarea\
C:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\.classCache\
Finally, restart the service.
C:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web\workarea\
C:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\.classCache\
Finally, restart the service.
In order to prevent this issue from happening:
-Don't use the "-Force" option in order to let the service stop by itself.
-Open "Regedit.exe", go to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control", find the "WaitToKillServiceTimeout" parameter (which is in milliseconds) and increase it so that Windows waits some more time before to kill the service.
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":"a8m3p000000PC7XAAW","label":"Planning Analytics-\u003EWeb PASS Contributor Application"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
24 June 2022
UID
ibm16598387