Hi,
I know a TI Process can be manually killed using TM1Top. But I am looking for a functionality/workaround by which we can kill (cancel execution) a TI process if it has not finished execution after a certain period of time.
Any ideas/suggestions will be highly appreciated.
TI Process Execution Time out
- Steve Rowe
- Site Admin
- Posts: 2419
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: TI Process Execution Time out
Not sure if this approach is what you are after but...
1. Capture the start time when the TI launches.
2. Define the maximum run time of the TI.
3. Periodically test the elapsed run time of the TI in the TI and process break / quit if the run time in 2 has been exceeded.
If what you are looking for is something to automatically kill of "hung" TIs after a period of time then I can't help.
Cheers,
1. Capture the start time when the TI launches.
2. Define the maximum run time of the TI.
3. Periodically test the elapsed run time of the TI in the TI and process break / quit if the run time in 2 has been exceeded.
If what you are looking for is something to automatically kill of "hung" TIs after a period of time then I can't help.
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 3666
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TI Process Execution Time out
I like that idea. To kill a process "on demand" you could do a variation and have the process periodically check a directory for a specific file and if it exists then process break or quit. Should do the trick give or take a few seconds.Steve Rowe wrote:Not sure if this approach is what you are after but...
1. Capture the start time when the TI launches.
2. Define the maximum run time of the TI.
3. Periodically test the elapsed run time of the TI in the TI and process break / quit if the run time in 2 has been exceeded.
If what you are looking for is something to automatically kill of "hung" TIs after a period of time then I can't help.
Cheers,
-
- Posts: 103
- Joined: Mon Sep 21, 2009 7:09 pm
- OLAP Product: Cognos Tm1
- Version: 10.2.2
- Excel Version: 2016
Re: TI Process Execution Time out
Yes, this is something which I want to do. But I need bit more help.Steve Rowe wrote:Not sure if this approach is what you are after but...
1. Capture the start time when the TI launches.
2. Define the maximum run time of the TI.
3. Periodically test the elapsed run time of the TI in the TI and process break / quit if the run time in 2 has been exceeded.
How can we capture the start time of a TI? Is it by reading tm1server.log?
How to find the elapsed time of a TI?
- Alan Kirk
- Site Admin
- Posts: 6610
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: TI Process Execution Time out
Too complicated. Grab the start time and store it in a variable. See here for a rundown on all date and time functions. (Hint: Now() is what you want, typically assigned to a variable that you define in the Prolog.)ExApplix wrote:Yes, this is something which I want to do. But I need bit more help.Steve Rowe wrote:Not sure if this approach is what you are after but...
1. Capture the start time when the TI launches.
2. Define the maximum run time of the TI.
3. Periodically test the elapsed run time of the TI in the TI and process break / quit if the run time in 2 has been exceeded.
How can we capture the start time of a TI? Is it by reading tm1server.log?
Call the same function again. Compare it to the variable that you assigned earlier. If it exceeds the limit that you've set, quit.ExApplix wrote:How to find the elapsed time of a TI?
I had started to type out something similar to Steve's reply but left it aside because there are two complicating factors. One Steve mentioned; if for instance the thing has hung on an ODBC connection, this approach won't help you.
The other is one that you have to figure out for yourself; if you DO quit the process, is there any clean-up that you'll have to do? For instance, if you quit when only half of a data load has been done, do you need to roll back? You'll have to figure that one out for yourself depending on what the process is intended to do.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.