TM1 Server crash on saving dimension (status Suspended)

Post Reply
Ken Vuong
Posts: 25
Joined: Wed Jul 02, 2008 1:20 pm

TM1 Server crash on saving dimension (status Suspended)

Post by Ken Vuong » Thu Feb 07, 2019 11:34 am

Hi everyone,

It's been a while since since I posted anything. Hope everyone is doing splendidly well! ;)

We have recently been getting intermittent PA server (11.0.5.79-0 on cmplst file) crashes when saving dimensions in Edit Dimension Structure.
Our dimension are rather small but when it happens, the status on the PA server goes into 'Suspended', the ram would drop then increase like it was trying to reload and then tm1sd.exe disappears.

There is nothing in the Tm1server file, the model is tiny and there is ample of Ram (server loads at 1GB. 5GB used. 58GB available)
I have moved the model to Dev and it works it annoyingly work fine every time.

Has anyone encountered anything like this?

Many thanks in advance,
Ken
Attachments
TM1sd suspend crash.JPG
TM1sd suspend crash.JPG (45.12 KiB) Viewed 311 times

lotsaram
MVP
Posts: 3210
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: TM1 Server crash on saving dimension (status Suspended)

Post by lotsaram » Thu Feb 07, 2019 12:55 pm

This is common when using the Architect dimension editor with a v11 server. Especially if the dimension has alternate hierarchy.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
Steve Rowe
Site Admin
Posts: 1884
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: TM1 Server crash on saving dimension (status Suspended)

Post by Steve Rowe » Thu Feb 07, 2019 12:56 pm

Hi Ken,

We have seen this a few times as well.

The only repeatable instance we have had is when two people were in the perspectives dimension editor at the same time and had both performed edits (obviously not best practice but it does happen). We have raised this with IBM. (TS001876885)

We have instances of server crashes when using the perspectives editor without two people being in as well though, nothing we have been able to reproduce so nothing with IBM as yet.

So you are not alone...

Cheers,

Ken Vuong
Posts: 25
Joined: Wed Jul 02, 2008 1:20 pm

Re: TM1 Server crash on saving dimension (status Suspended)

Post by Ken Vuong » Thu Feb 07, 2019 1:37 pm

Thanks guys.

Good to know it's not only me. Looks like I will try to do this after hours or setup a TI to do it.

Our reseller (sempre) suggest playing around with some CFG parameter to see if that helps.
I will update if I can re-produce this problem and get something concrete to IBM.

...feels like we going back in time to the TM1 Version 6 days! lol

Ken

User avatar
PavoGa
Community Contributor
Posts: 314
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.05
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: TM1 Server crash on saving dimension (status Suspended)

Post by PavoGa » Thu Feb 07, 2019 3:11 pm

Hi Ken,

We had the same thing and were able to isolate at least one cause which was 100% repeatable.

When loading data, if there is an element that does not exist in a dimension, we add that element to a consolidation called "Unregistered" to deal with later. If that consolidation is the first element in the dimension, when we open the cube, it crashes the server (may have to close it once and then reopen it, but never more than twice opening will cause the crash). The dimension with this apparently suicidal structure has to be the first dimension in the cube.

Sounds nuts, but can do it right now and cause a crash. Do not recall if we tried another name for the consolidation because once we confirmed this, simply made sure "Unregistered" showed up at the bottom and problems went away.
Ty
Cleveland, TN

User avatar
Steve Rowe
Site Admin
Posts: 1884
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: TM1 Server crash on saving dimension (status Suspended)

Post by Steve Rowe » Thu Feb 07, 2019 4:50 pm

Hi PavoGa,

What's your version number please? Did you get this acknowledged by IBM?

Cheers,

User avatar
PavoGa
Community Contributor
Posts: 314
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.05
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: TM1 Server crash on saving dimension (status Suspended)

Post by PavoGa » Thu Feb 07, 2019 5:22 pm

Steve Rowe wrote:
Thu Feb 07, 2019 4:50 pm
Hi PavoGa,

What's your version number please? Did you get this acknowledged by IBM?

Cheers,
Yes, we did. PA 2.0.05
Ty
Cleveland, TN

User avatar
Steve Rowe
Site Admin
Posts: 1884
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: TM1 Server crash on saving dimension (status Suspended)

Post by Steve Rowe » Thu Feb 07, 2019 5:35 pm

In response to our defect we've been told that there was a defect relating to "re-ordering elements" in the dim editor (rather than formally setting the sort order) causing the server to fail.

This was fixed in 205 IF 3 and 206

We tested our use case and have confirmed the issue is resolved.

Since nearly any change to a dimension must involve reordering the list in some way I'm guessing that this may solve many peoples issue.

APAR for the resolved defect was PH01140
HTH

User avatar
PavoGa
Community Contributor
Posts: 314
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.05
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: TM1 Server crash on saving dimension (status Suspended)

Post by PavoGa » Thu Feb 07, 2019 5:41 pm

Thank you, Steve. When I get a chance, I'll try it again.
Ty
Cleveland, TN

Ken Vuong
Posts: 25
Joined: Wed Jul 02, 2008 1:20 pm

Re: TM1 Server crash on saving dimension (status Suspended)

Post by Ken Vuong » Fri Feb 08, 2019 9:30 am

Thanks Steve.

I will upgrade to 206.
Cheers,

Ken

Wim Gielis
MVP
Posts: 2011
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.6
Excel Version: 2016 - Office 365
Location: Brussels, Belgium
Contact:

Re: TM1 Server crash on saving dimension (status Suspended)

Post by Wim Gielis » Fri Feb 08, 2019 12:11 pm

Ken Vuong wrote:
Fri Feb 08, 2019 9:30 am
Thanks Steve.

I will upgrade to 206.
Cheers,

Ken
Anyone has an idea when 2.0.7 will be out ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Active form claustrophobia

Post Reply