TM1 instance stuck on restart on StatsBy... cub files

Post Reply
vladino
Posts: 110
Joined: Sat Nov 06, 2010 10:10 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel 2013

TM1 instance stuck on restart on StatsBy... cub files

Post by vladino »

Hi guys,
we are experiencing weird behavior when trying to restart a TM1 instance.

It is stuck on "TM1ServerImpl::Destroy: Commit changes" and it never ends. So the only way is to kill the process itself...

In the Data folder I can see that all "StatsBy..." cubes are being overwritten (there are *.cub$ files).

How to resolve this please? Appreciate any help!

BR
Vladino
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by macsir »

Never heard about that before. Did you manually save data before restarting?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
vladino
Posts: 110
Joined: Sat Nov 06, 2010 10:10 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel 2013

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by vladino »

macsir wrote: Wed May 02, 2018 9:13 pm Never heard about that before. Did you manually save data before restarting?
Sure, I have written a process that runs CubeSaveData for all cubes and before restarting the instance I'm also running SaveDataAll.
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by macsir »

I think there is some conflicting between the two functions. If you use savedataall, it is unnecessary to use CubeSaveData to save all cubes.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
vladino
Posts: 110
Joined: Sat Nov 06, 2010 10:10 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel 2013

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by vladino »

macsir wrote: Thu May 03, 2018 4:46 am I think there is some conflicting between the two functions. If you use savedataall, it is unnecessary to use CubeSaveData to save all cubes.
I don't think that this is the reason - sometimes it is restarted successfully, but most of the times it is stuck.

Btw. when I don't run CubeSaveData and kill the process then all data changes for cubes that aren't logged are gone... This is the reason why I'm running both CubeSaveData and SaveDataAll.
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by gtonkin »

Are your saves in Epilog?-had issues previously with these in Prolog.
vladino
Posts: 110
Joined: Sat Nov 06, 2010 10:10 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel 2013

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by vladino »

gtonkin wrote: Thu May 03, 2018 7:18 am Are your saves in Epilog?-had issues previously with these in Prolog.
Both CubeSaveData and SaveDataAll are in Prolog... I will give it a try and let you know guys, thanks!
vladino
Posts: 110
Joined: Sat Nov 06, 2010 10:10 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel 2013

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by vladino »

vladino wrote: Fri May 04, 2018 12:36 pm
gtonkin wrote: Thu May 03, 2018 7:18 am Are your saves in Epilog?-had issues previously with these in Prolog.
Both CubeSaveData and SaveDataAll are in Prolog... I will give it a try and let you know guys, thanks!
Hmm, that's interesting... It seems that it works! :)

Let's wait for a while if the issue is resolved. Thank you sir!
vladino
Posts: 110
Joined: Sat Nov 06, 2010 10:10 am
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel 2013

Re: TM1 instance stuck on restart on StatsBy... cub files

Post by vladino »

Bad news here guys... :-/

Still sometimes hangs on "Commit changes", }StatsBy... cubes hangs in "cub$" state and the only way is to kill the process manually.

Any other suggestions?
Post Reply