Tool to analyse TM1 web dumps

Post Reply
JamiseBondi
Posts: 127
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Tool to analyse TM1 web dumps

Post by JamiseBondi » Thu Nov 09, 2017 11:09 am

Hi All,

Does anyone here have any suggestions on what tool/s you use to analyse the web dump files that are generated from time to time?
These would be
core*.dmp
heapdump*.phd
javacore*.txt

I'm just interested to know if there is a tool that would be able to give us an indication of the problem without having to create a PMR (which I may end up doing anyway, but wanted to get my facts straight before going to a PMR each time it happens.).

Thanks.

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

Re: Tool to analyse TM1 web dumps

Post by Steve Rowe » Thu Nov 09, 2017 5:19 pm

Hi Jamie,
I don't have a direct answer for you but our experience suggests that majority of crashes are because TM1 Web is running out of memory. The main cause of this tends to be.

1. The shipped default is too low, it should be increased.
2. Too much white space in an excel sheet.
The white space arises from user error, i.e. user accidently puts something in column XFD and publishes the workbook. TM1 web will attempt to render all the columns.
Active forms are also very easy to publish defined out to column 1000 (ALL).

TM1 Web in the PA world contains some cfg such that you can limit the maximum cell count and prevent the white space issue from occurring.

HTH

JamiseBondi
Posts: 127
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Tool to analyse TM1 web dumps

Post by JamiseBondi » Fri Nov 10, 2017 9:59 am

Awesome! Thanks Steve. Good to know.

Post Reply