TM1 Web Memory Leak
-
- 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
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
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
- 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
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?
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
Rizwan Kaif
-
- 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
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
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
- 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
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
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
Re: TM1 Web Memory Leak
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.
http://www.microsoft.com/technet/prodte ... x?mfr=true -- take a look at Memory Optimization section.
- Yuri.
-
- 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
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
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
-
- 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
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
I also running into the same memory issue with w3wp service on TM1 web server. Were you able to find any resolution ?
Thanks
Yash
-
- 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
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.
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.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: TM1 Web Memory Leak
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?nick_leeson wrote:A quick google search comes up with this.
http://support.microsoft.com/kb/2556002
Robin Mackenzie
-
- 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
Oops !! Apologies to everybody !!