TM1 Web Memory Leak

Post Reply
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

TM1 Web Memory Leak

Post by Radhika »

Hi All,

We are running TM1 9.4.1. MR1 FP001 64 BIT on a Windows 2003 Enterprise 64 BIT. The server has 16 gigs of RAM and 2 quad core processors.

With only 2 users hitting the TM1WEB site many times over a 30 minute period of time the w3wp.exe (I.e. www service) on the server had reached using 2 gigabytes of memory. Each time a page is loaded the memory goes up 10 mb. If the user logs out, the memory is not purged. If the same user logs in and then logs out it keeps accumulating steadily.

What happens if 50 users start accessing the TM1 web site?

There appears to be a serious memory leak.

Is there a config setting, IIS setting, patch, etc to fix this?

Does IIS know it has lots of RAM and will clean up memory when it needs to?

Please help me.

Thanks & Regards,
Radhika
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: TM1 Web Memory Leak

Post by rkaif »

Have you tried bouncing your Windows Services (including IIS & Tm1 Excel service)?

You can also check which version of .NET Framework is being used.

This could be a bug. There is an existing PMR with IBM PM28227 related to the same issue. Have you checked with IBM support on this?
Cheers!
Rizwan Kaif
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

Re: TM1 Web Memory Leak

Post by Radhika »

Hi Kaif,

We tried restarting the services for that point it's fine, but again when we retrieve the reports from TM1 web the behaviour recurs again.
I looked into the IBM PMR but till now there is no solution updated.

Anyother alternative solutions.

Thanks,
Radhika
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 Web Memory Leak

Post by paulsimon »

Hi

Have you checked which process is using the memory? Are you sure that it is TM1 Web rather than TM1? Are the users retrieving the same information from TM1 or are they retrieving different data?

Regards

Paul Simon
User avatar
ykud
MVP
Posts: 148
Joined: Sat Jan 10, 2009 10:52 am
Contact:

Re: TM1 Web Memory Leak

Post by ykud »

You can try limiting IIS object cache to force 'freeing memory'.

http://www.microsoft.com/technet/prodte ... x?mfr=true -- take a look at Memory Optimization section.

- Yuri.
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

Re: TM1 Web Memory Leak

Post by Radhika »

Thank you all for your response.
I tried all the above said options with our IIS Admin to get rid of this memory leak but unsuccessful.

Planning to raise a PMR with IBM.

Thanks,
Radhika
Yash
Posts: 2
Joined: Tue Sep 20, 2011 4:06 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: MS 2007

Re: TM1 Web Memory Leak

Post by Yash »

Hi Radhika,

I also running into the same memory issue with w3wp service on TM1 web server. Were you able to find any resolution ?

Thanks
Yash
nick_leeson
Posts: 98
Joined: Sat Feb 11, 2012 11:13 am
OLAP Product: TM1 9x, BPC, Hyperion, HANA
Version: TM1 10
Excel Version: Excel 2003 - 2010

Re: TM1 Web Memory Leak

Post by nick_leeson »

A quick google search comes up with this.

http://support.microsoft.com/kb/2556002

The fact that the PMR hasn't been updated and you are on TM1 9.4.1. chances of a resolution are remote.

How about a simple .aspx page stopping the TM1Web Service and seeing whether memory increases ? This would isolate it from a TM1 issue rather and a IIS issue.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: TM1 Web Memory Leak

Post by rmackenzie »

nick_leeson wrote:A quick google search comes up with this.
http://support.microsoft.com/kb/2556002
Sorry, don't mean to be overly harsh, but that seems to be a pretty irrelevant link given that the KB item refers to users of Microsoft Commerce Server 2007 or 2009... I'm not sure what you hope to achieve by posting that information on this thread?
Robin Mackenzie
nick_leeson
Posts: 98
Joined: Sat Feb 11, 2012 11:13 am
OLAP Product: TM1 9x, BPC, Hyperion, HANA
Version: TM1 10
Excel Version: Excel 2003 - 2010

Re: TM1 Web Memory Leak

Post by nick_leeson »

Oops !! Apologies to everybody !!
Post Reply