TM1 Server crash on saving dimension (status Suspended)

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

TM1 Server crash on saving dimension (status Suspended)

Post by Ken Vuong »

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 10748 times
lotsaram
MVP
Posts: 3651
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 »

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: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe »

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,
Technical Director
www.infocat.co.uk
Ken Vuong
Posts: 29
Joined: Wed Jul 02, 2008 1:20 pm

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

Post by Ken Vuong »

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
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

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

Post by PavoGa »

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: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe »

Hi PavoGa,

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

Cheers,
Technical Director
www.infocat.co.uk
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

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

Post by PavoGa »

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: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe »

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
Technical Director
www.infocat.co.uk
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

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

Post by PavoGa »

Thank you, Steve. When I get a chance, I'll try it again.
Ty
Cleveland, TN
Ken Vuong
Posts: 29
Joined: Wed Jul 02, 2008 1:20 pm

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

Post by Ken Vuong »

Thanks Steve.

I will upgrade to 206.
Cheers,

Ken
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis »

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

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Ken Vuong
Posts: 29
Joined: Wed Jul 02, 2008 1:20 pm

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

Post by Ken Vuong »

Just an update on this log.

Finally updated the server to PA 207 to go to PAW, and the bug has gone. Server no longer crashes on saving Dimension.

Would recommend anyone who is on PA 205 to move away from it if possible.
Cheers,

Ken
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe »

Wow, that took a while to get organised, Merry Christmas Ken!
Technical Director
www.infocat.co.uk
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

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

Post by paulsimon »

Hi

It looks like Ken's problem was specific to the Dimension Editor, but from PavoGa's description it looks like a crash from a TI process. Is that the case?

We have also had some crashes with the Dimension Editor but fortunately only in Non-Production environments, as we don't really use the Dimension Editor in Prod.

We are on 2.0.5 and just had a crash in Production yesterday. There was nothing in the TM1Server.log at all to indicate the cause. There seemed to have been no activity at the time. It was late in the day and the only activity was a user logging chore, which according to the TM1Server.log finished executing successfully a few seconds before the crash.

I couldn't tell you what fix pack we are on. The version number on tm1sd.exe says 11.3.0.27, but I have long since given up trying to make any sense of IBM's approach to version numbering.

For the moment, we have reported the crash to IBM and put in additional logging to capture a crash dump if it happens again. Hopefully, it won't as 2.0.5 has actually been reasonably stable for us. We do restart the service every night, which may help.

We would be reluctant to upgrade without a full system test because of the risk that 2.0.7 cures one bug and introduces three brand new ones. At present we have a lot of projects on the go and don't have the capacity to carry out a full system test. In any case, we are going into Interims followed by Year End so there is no chance of us getting permission from our users to upgrade, or any resource to carry out the user side of testing.

So really just interested to hear if anyone has had crashes on 2.0.5 that were not attributable to the Dimension Editor?

Regards

Paul SImon
Ken Vuong
Posts: 29
Joined: Wed Jul 02, 2008 1:20 pm

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

Post by Ken Vuong »

Thanks Steve.

Wishing Happy Christmas to you and the Infocat guys. Have a splendid New Year too ;)

Cheers,

Ken
Post Reply