Urgent Help!!!!

Post Reply
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Urgent Help!!!!

Post by jim wood »

Guys,

As usual Cognos support are currently nowhere to be seen. Basically I kicked a process off yesterday and for some reason it has taken an age and I killed it this morning. It says in the log file that it has been stopped but it TM1 Top it says it is still going and doing a "Commit". Any idea what the hell it is doing?

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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: Urgent Help!!!!

Post by Steve Vincent »

How did you kill it? If via the TM1top option to kill a thread, all it does is insert a command to stop but i has to have finished the current data line first before it reads the command. If the TI is in an endless loop it'll never read the command, the only option then is to manually kill the service and restart it.
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
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Urgent Help!!!!

Post by jim wood »

As things always go I started to create a backup option on another server and everything came back. I killed it by crashing excel. I then couldn't kill it in TM1 Top. I did try killing it in TM1 Top before killing excel. I'm now guessing on what I have seen today that when it says "Commit" it is updating some feeders or something,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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: Urgent Help!!!!

Post by Steve Vincent »

Ah, killing Excel kills nothing, not when a TI is concerned anyway. If top didn't sort it then my guess is it got in to a loop, a good old while n < y with no n = n + 1 would do the trick, although its not always that obvious...
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
Post Reply