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 » Wed May 02, 2018 7:54 pm

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
Community Contributor
Posts: 653
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

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

Post by macsir » Wed May 02, 2018 9:13 pm

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 » Wed May 02, 2018 9:58 pm

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
Community Contributor
Posts: 653
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1, SSAS
Version: 9.5 - 10.2
Excel Version: 97 - 2013
Contact:

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

Post by macsir » 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.
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 » Thu May 03, 2018 7:02 am

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: 740
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

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

Post by gtonkin » Thu May 03, 2018 7:18 am

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 » 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!

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 » Fri May 04, 2018 9:23 pm

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 » Sat May 05, 2018 7:50 pm

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