Server 9.1 SP3 U1 - Memory Exception

Post Reply
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Server 9.1 SP3 U1 - Memory Exception

Post by Martin Erlmoser »

Hi all,
anyone expirienced similar Memory Exception Problems in the TM1 Version 9.1 SP3 U1 ?
Today i encountered this problem twice - on two completely different TM1 Server running on different Hosts and different Adminservers on the same TM1Version.
The problem causes a serverhang and at the moment i don't know whats the reason for the problem..
While the server hangs we can't connect to the TM1Server with e.g. Architect (Cube Viewer: Out of Memory message) but connecting and logging in with tm1top works. (canceling the running threads don't work of course..)
important: both tm1 server had enough memory free AND didn't reach the 32bit limit. (server1 used around 1100Mb, server2 1500Mb
Server Os: Windows 2003 SP2 32bit

Code: Select all

44344   ERROR   2008-06-09 09:09:13,008   TM1.Cube   Used cube does not have any user information.  Used Cube: }ElementAttributes_companies_IHS, User Cube: 5
44344   ERROR   2008-06-09 09:09:13,024   TM1.Cube   Used cube does not have any user information.  Used Cube: }ElementAttributes_companies_IHS, User Cube: 1
44344   ERROR   2008-06-09 09:09:13,024   TM1.Cube   Used cube does not have any user information.  Used Cube: }ElementAttributes_companies_IHS, User Cube: 5
44344   ERROR   2008-06-09 09:09:13,133   TM1.Server.Memory   BIGAllocBlock - alloc (size = 150110) failed: Not enough storage is available to process this command.
44344   WARN   2008-06-09 09:09:22,133   TM1.Server.Memory   al_Alloc() outOfMemory Exception <<< MEMORY_ALMOST_FATAL_LEVEL >>> - threadID "44344" -  apifunc# "237"
44344   ERROR   2008-06-09 09:09:22,133   TM1.API   Request denied.  Insufficient memory.
44344   ERROR   2008-06-09 09:09:22,149   TM1.API   Request denied.  Insufficient memory.
44344   ERROR   2008-06-09 09:09:22,336   TM1.API   Request denied.  Insufficient memory.
44344   ERROR   2008-06-09 09:09:22,336   TM1.API   Request denied.  Insufficient memory.
44344   ERROR   2008-06-09 09:09:22,336   TM1.API   Request denied.  Insufficient memory. 
Attachments
clienterror.GIF
clienterror.GIF (8.22 KiB) Viewed 8430 times
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Server 9.1 SP3 U1 - Memory Exception

Post by jim wood »

Have just added a post about 9.1 SP3 issues. I'm not sure we are experiencing the same erro but it does sound spookily similar. When our error occurs the server becomes unavailable, a core dump occurs but Unix still thinks the service is running. It's very bizzare. Here's the thing, we also have memory available. That's why I think it might be similar,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
rossi
Posts: 29
Joined: Tue Jun 10, 2008 8:50 pm
Location: London UK

Re: Server 9.1 SP3 U1 - Memory Exception

Post by rossi »

Sounds like 9.1 SP3 U1 is going to cause more issues than resolve them

Do not think we will move there very quick

Paolo
Martin Erlmoser
Community Contributor
Posts: 125
Joined: Wed May 28, 2008 1:22 pm
OLAP Product: TM1, Cognos Express,..
Version: 9.1.4 FP1
Excel Version: 2010
Location: Vienna
Contact:

Re: Server 9.1 SP3 U1 - Memory Exception

Post by Martin Erlmoser »

today in the morning
on a different server (i call him server3 ) which is installed on the same machine as server1

memory exception !
one servercrash in the morning .. one server hang or freeze 50 minutes later..

Code: Select all

1452   WARN   2008-06-13 08:13:46,575   TM1.Server.Memory   al_Alloc() outOfMemory Exception <<< MEMORY_TEMP_POOL_EXCEEDED >>> - threadID "1452" -  apifunc# "166" - pool# "0" - poolsize "256.000000"
1452   ERROR   2008-06-13 08:16:43,478   TM1.Server.Memory   CommonAlloc - alloc (size = 131072) failed: Not enough storage is available to process this command.
2520   ERROR   2008-06-13 08:16:51,494   TM1.API   Request denied.  Insufficient memory.
1452   WARN   2008-06-13 08:16:52,478   TM1.Server.Memory   CommonAlloc() outOfMemory Exception <<< MEMORY_ALMOST_FATAL_LEVEL >>> - threadID "1452" -  apifunc# "166"
1452   ERROR   2008-06-13 08:16:52,494   TM1.Server.Memory   CommonAlloc - alloc (size = 131072) failed: Not enough storage is available to process this command.

1452   WARN   2008-06-13 08:16:52,494   TM1.Server.Memory   CommonAlloc() outOfMemory Exception <<< MEMORY_ALMOST_FATAL_LEVEL >>> - threadID "1452" -  apifunc# "166"
1452   WARN   2008-06-13 08:16:52,494   TM1.Server.Memory   al_OpenPool() outOfMemory Exception <<< MEMORY_FATAL_LEVEL >>> - threadID "1452" -  apifunc# "166" - pool# "56"
1452   ERROR   2008-06-13 08:16:52,494   TM1.Server   TM1 Server Abort: System Out Of Memory.
2520   ERROR   2008-06-13 08:16:52,494   TM1.API   Request denied.  Insufficient memory.
1452   INFO   2008-06-13 08:16:52,494   TM1.Server   Closing...
2772   INFO   2008-06-13 08:18:35,102   TM1.Server   TM1 Server is ready
2772   INFO   2008-06-13 08:18:35,102   TM1.Server   Notifying the Admin server
5484   WARN   2008-06-13 08:38:18,228   TM1.Server.Memory   al_Alloc() outOfMemory Exception <<< MEMORY_TEMP_POOL_EXCEEDED >>> - threadID "5484" -  apifunc# "166" - pool# "0" - poolsize "256.000000"
5484   ERROR   2008-06-13 08:55:58,933   TM1.Server.Memory   BIGAllocBlock - alloc (size = 150110) failed: Not enough storage is available to process this command.


4256   ERROR   2008-06-13 08:55:59,058   TM1.Server.Memory   CommonAlloc - alloc (size = 131072) failed: Not enough storage is available to process this command.


4256   WARN   2008-06-13 08:55:59,058   TM1.Server.Memory   CommonAlloc() outOfMemory Exception <<< MEMORY_ALMOST_FATAL_LEVEL >>> - threadID "4256" -  apifunc# "121"
6124   ERROR   2008-06-13 08:56:01,167   TM1.API   Request denied.  Insufficient memory.
5484   WARN   2008-06-13 08:56:07,933   TM1.Server.Memory   al_Alloc() outOfMemory Exception <<< MEMORY_ALMOST_FATAL_LEVEL >>> - threadID "5484" -  apifunc# "166"
5904   ERROR   2008-06-13 08:56:15,151   TM1.Server.Memory   BIGAllocBlock - alloc (size = 150110) failed: Not enough storage is available to process this command.


5904   WARN   2008-06-13 08:56:15,151   TM1.Server.Memory   al_Alloc() outOfMemory Exception <<< MEMORY_ALMOST_FATAL_LEVEL >>> - threadID "5904" -  apifunc# "0"
6124   ERROR   2008-06-13 08:56:15,807   TM1.API   Request denied.  Insufficient memory.
1208   ERROR   2008-06-13 09:12:44,389   TM1.API   Request denied.  Insufficient memory.

 -- here i killed the tm1sd process because the server didn't respond..

Attachments
tm1top_romep_memoryexception.GIF
tm1top_romep_memoryexception.GIF (6.26 KiB) Viewed 8300 times
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Server 9.1 SP3 U1 - Memory Exception

Post by jim wood »

The problems we have had have caused a memory dump to the hard drive. We are working on getting what we need out of the dump and we are passing this on to Cognos Support. I suggest you try something similar. Even refernce our problem if you like. The more customers that experience the same issue, the more the chance of it being fixed quickly,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Server 9.1 SP3 U1 - Memory Exception

Post by jim wood »

Does your crash create a memory core dump in the data directory? Have you raised this issue with Cognos support? If not could you raise the issue? If you have raised it, could you let Keith Faulkner at Cognos UK know the details.

If you haven't raised the issue but you have core dump could you PM me so I can try to move this forward. I am trying to find out if we are hitting the issue,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Armand Mizan
Posts: 17
Joined: Thu Aug 07, 2008 11:24 pm
OLAP Product: TM1
Version: TM1 v 10.1.1
Excel Version: 2003

Re: Server 9.1 SP3 U1 - Memory Exception

Post by Armand Mizan »

Hi All

I am also experiencing similar problems.We have a 64 bit server -128gb of ram.
Screen dump of Warning message
Screen dump of Warning message
Memory Error.jpg (354.3 KiB) Viewed 8057 times
Any comments or ideas?

Cheers

Armand
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Server 9.1 SP3 U1 - Memory Exception

Post by jim wood »

The issue we encountered was a compiler issue that is fixed in U2,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply