Stop TM1 running process

Post Reply
Dimitri
Posts: 4
Joined: Fri Mar 19, 2010 12:11 am
OLAP Product: Cognos TM1 9.1 SP4
Version: 9.1 SP4
Excel Version: 2003

Stop TM1 running process

Post by Dimitri »

Hi,

I have the processes which run 1-2 hours.

Does anobody know if it is possible to stop TM1 running process without rebooting the server?

Thank you,
Dimitri
User avatar
LoadzaGrunt
Posts: 72
Joined: Tue May 26, 2009 2:23 am
Version: LoadzaVersions
Excel Version: LoadzaVersions

Re: Stop TM1 running process

Post by LoadzaGrunt »

You have three options:

TM1 Top - use the C command to stop the ExecuteProcess thread
Services - stop the TM1 service
Task Manager - kill the tm1sd.exe process underlying your service

Stopping the service is preferable to killing the .exe, but using TM1 Top is the least disruptive method
Dimitri
Posts: 4
Joined: Fri Mar 19, 2010 12:11 am
OLAP Product: Cognos TM1 9.1 SP4
Version: 9.1 SP4
Excel Version: 2003

Re: Stop TM1 running process

Post by Dimitri »

Thank you Grunt,

The last two options actually stop the whole server? And it will be nesessary to start it agaig,
disrupting the work of users.


I will try C command.
User avatar
LoadzaGrunt
Posts: 72
Joined: Tue May 26, 2009 2:23 am
Version: LoadzaVersions
Excel Version: LoadzaVersions

Re: Stop TM1 running process

Post by LoadzaGrunt »

Yes, the last two options stop the entire TM1 server (not server as in the actual physical box), and this may be disruptive to other people who are using TM1 at the time your process is running. However, it might be that your process is actually preventing anyone else using TM1.

Using the C command in TM1 Top does not always stop a process that is having problems but it is very much worth while giving it a go.
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Stop TM1 running process

Post by Wim Gielis »

Hi

Perhaps not the answer you wanted (Grunt helped you already), but do you know why it takes 1-2 hours? Is this normal? Are there certain factors that lead to such a long time to execute the process? Do you turn off cube logging temporarily? And so on.

Wim
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply