TM1 Tops

Post Reply
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

TM1 Tops

Post by Eric »

I have referred to the limited TM1 Tops documentation.
http://www.applix.com/doc_lib/ENG/wwhel ... wwhelp.htm

I am trying to cancel a thread; however, I have tried the C & V command and nothing happens any clues?

Version 9.0 SP3

Could it be the security setting
SecurityPackageName=Kerberos
IntegratedSecurityMode=3

Think it is being finicky with IntegratedSecurityMode=3 setting?
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
Alan Kirk
Site Admin
Posts: 6606
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: TM1 Tops

Post by Alan Kirk »

I am trying to cancel a thread; however, I have tried the C & V command and nothing happens any clues?
I don't think that cancelling a thread has a 100% success rate; I'm sure that I read of instances in the old Forum where it just didn't work, and indeed I've had one or two myself on 9.1SP3. As Mike C explained it at the time TM1 Top was released:
The Tm1Top utility will not "kill" a thread. It is designed to cancel thread processing when a thread is involved in doing a lengthy calculation. (The prompt for the thread ID reads "Cancel processing of a thread".) The Tm1Top functionality merely sets a "please exit" bit in the thread header which is periodically checked by the thread. If the bit is set the threads exits through the normal channels. It is not "killed" which would not release locks, private objects, and other resources.
The implication as I read it is that if you have a thread which never checks the said header, or does so only very, very infrequently, it's entirely possible that you'll be waiting an awfully long time for the thread to end.

If I were to choose an analogy, the cancel thread command in TM1 top is like putting up a "Stop" sign in front of a speeding driver. If the driver is well behaved / programmed, they'll stop.

A TRUE thread killing tool would be like pumping a few 9mm slugs into the car's tyres, but alas a metaphorical 92FS Beretta isn't part of the TM1 Top arsenal.
"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.
ScottW
Regular Participant
Posts: 152
Joined: Fri May 23, 2008 12:08 am
OLAP Product: TM1 CX
Version: 9.5 9.4.1 9.1.4 9.0 8.4
Excel Version: 2003 2007
Location: Melbourne, Australia
Contact:

Re: TM1 Tops

Post by ScottW »

As far as I am aware the tm1top "C" command to kill a thread works for the following scenarios only
- cancels a TI process (by inserting ProcessQuit command)
- cancels construction of a view

For anything else (such as saving a bad rule that has gone haywire ... ) the "C" command will not work.
Cheers,
Scott W
Cubewise
www.cubewise.com
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: TM1 Tops

Post by Eric »

I apologize, my post must be unclear.

I literally go to the Cmd can entered C.....waited..... nothing happened. Read documentation where it states upon hitting C you should be prompted to input the thread ID to cancel. That did not happen. Upon further review I saw comments regarding entering V in the cmd to validate the user. I type v and hit enter....wait....nothing happened again!

Thought that the security level setup was causing the issue, but maybe not. If no one has any ideas I will submit a ticket to insight, YEA! :(
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
User avatar
Martin Ryan
Site Admin
Posts: 1988
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: TM1 Tops

Post by Martin Ryan »

Are you typing in capitals? I think it has to be capital V and capital C.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: TM1 Tops

Post by Steve Vincent »

yep, must be SHIFT+C or SHIFT+V to get it to work...
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: TM1 Tops

Post by Eric »

GRRRRRR!!!!!

Well that is one way to make a guy feel like a jack@@@. It works now.
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
ScottW
Regular Participant
Posts: 152
Joined: Fri May 23, 2008 12:08 am
OLAP Product: TM1 CX
Version: 9.5 9.4.1 9.1.4 9.0 8.4
Excel Version: 2003 2007
Location: Melbourne, Australia
Contact:

Re: TM1 Tops

Post by ScottW »

Traps for young players eh.
I did mention the "C" command not the "c" command didn't I ;)
Cheers,
Scott W
Cubewise
www.cubewise.com
User avatar
Eric
MVP
Posts: 373
Joined: Wed May 14, 2008 1:21 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003
Location: Chicago, IL USA

Re: TM1 Tops

Post by Eric »

grumble.... grumble...grumble. Yes you and all of the documentation said "C" not "c". Stupid case sensitivity!

Man, I just got my He-Man Sword of Power in the mail.... Please don't make me return it. :(
Regards,
Eric
Blog: http://tm1-tipz.blogspot.com
Articles: http://www.google.com/reader/shared/use ... /label/TM1


Production: 32 bit 9.0 SP2, Windows 2000 Advanced Server. Web: 32 bit 9.0 SP2, Windows 2000 Server. Excel 2003
Post Reply