Tool to analyse TM1 web dumps

Post Reply
JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Tool to analyse TM1 web dumps

Post by JamiseBondi »

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: 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: Tool to analyse TM1 web dumps

Post by Steve Rowe »

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
Technical Director
www.infocat.co.uk
JamiseBondi
Posts: 141
Joined: Wed Nov 14, 2012 10:37 am
OLAP Product: TM1
Version: 2.0
Excel Version: Office 365

Re: Tool to analyse TM1 web dumps

Post by JamiseBondi »

Awesome! Thanks Steve. Good to know.
Post Reply