outofMemory Exception TM1 9.5.2 64bit

Post Reply
krishnadixit
Posts: 31
Joined: Fri Oct 14, 2011 6:44 am
OLAP Product: TM1, COGNOS
Version: TM1 9_5 Cognos Planning 8_4
Excel Version: 2007
Location: Mumbai, India

outofMemory Exception TM1 9.5.2 64bit

Post by krishnadixit »

Recently We upgraded our RAM & Number of cores on our server. Initially we had 32GB RAM & 2 Processors on our Prod server. Since we did not wanted to disturb existing environment we setup a new server machine with following configuration:

Windows 2008 R2 Enterprise SP1
2 Processors - 6 Cores
48GB RAM
64-bit os
TM1 9.5.2 64 bit
Drives:
a. C: 58GB free & pagefile.sys 1GB
b. E: 29GB free & pagefile.sys 71GB (since we wanted to keep C drive free we created a big pagefile on E: drive, which is our swap drive)
c. F: 140GB free & no pagefile.sys. Our TM1 installation is in this drive.

The existing (old) environment has just 2 processors - 2 cores & just 32GB RAM installed. It has 15GB pagefile.sys in E: Drive (Swap drive)

Now when I started TM1 data server on new machine the server crashed displaying 'outofMemory' exception. The log file says:.

3268 [] INFO 2014-07-08 18:43:06.089 TM1.Cube Loading cube Payroll
3268 [] INFO 2014-07-08 18:43:14.076 TM1.Server TM1CubeImpl::ProcessFeeders: Computing feeders for base cube 'Payroll'.
3268 [] INFO 2014-07-08 18:43:14.092 TM1.Cube.Dependency Adding cube dependency: cube "Income_Statement" depends on cube "Payroll"
3268 [] INFO 2014-07-08 18:43:43.388 TM1.Cube.Dependency Adding cube dependency: cube "COGS_Detail" depends on cube "Payroll"
3268 [] ERROR 2014-07-08 18:46:10.511 TM1.Server.Memory AllocateBlockFromOS: alloc (size = 8388608) failed: Not enough storage is available to process this command.

3268 [] WARN 2014-07-08 18:46:10.511 TM1.Server.Memory CommonAllocateBlock() outOfMemory Exception <<< MEMORY_FATAL_LEVEL >>> - apifunc# "0"
3268 [] INFO 2014-07-08 18:46:10.511 TM1.Server TM1CubeImpl::ProcessFeeders: Exception, done computing feeders for base cube 'Payroll'.
3268 [] ERROR 2014-07-08 18:46:10.511 TM1.Server Phase 1 of server load failed
=====

I am surprised to see 'Not enough storage is available to process this command' error. The server starts & loads on existing old server normally & is working fine.

Any ideas or suggestions?

Krishna
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: outofMemory Exception TM1 9.5.2 64bit

Post by jim wood »

Have you checked on the old box to see how much physical and page memory is being used? Have you checked memory usage on start up on the new machine? How big is your page file on the new machine?
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
tomok
MVP
Posts: 2832
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: outofMemory Exception TM1 9.5.2 64bit

Post by tomok »

You still have to have a paging file equal to the amount of RAM, even if you will likely never use it.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
krishnadixit
Posts: 31
Joined: Fri Oct 14, 2011 6:44 am
OLAP Product: TM1, COGNOS
Version: TM1 9_5 Cognos Planning 8_4
Excel Version: 2007
Location: Mumbai, India

Re: outofMemory Exception TM1 9.5.2 64bit

Post by krishnadixit »

@Jim & @tomok
Thanks for your suggestions. The Old box has 32GB RAM & 15GB Page memory. The memory usage on new box without tm1 startup is just 3GB out of 48GB & has page memory of 1GB & 71GB on C & E drives respectively.

Any idea?
User avatar
Steve Rowe
Site Admin
Posts: 2417
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: outofMemory Exception TM1 9.5.2 64bit

Post by Steve Rowe »

Maybe you have installed the 32 bit version of the instance on the new 64 bit box which (I think) would limit you to 4GB?

(I can't really remember if the above is possible but it seems to ring a bell....)

Cheers,
Technical Director
www.infocat.co.uk
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: outofMemory Exception TM1 9.5.2 64bit

Post by Duncan P »

It is possible, and would certainly account for this error as there would be 32 bit address space fragmentation to contend with. See here.

In Task Manager the TM1S process would have *32 next to its name if this were the case.
krishnadixit
Posts: 31
Joined: Fri Oct 14, 2011 6:44 am
OLAP Product: TM1, COGNOS
Version: TM1 9_5 Cognos Planning 8_4
Excel Version: 2007
Location: Mumbai, India

Re: outofMemory Exception TM1 9.5.2 64bit

Post by krishnadixit »

@Duncan & Steve,

Thank you. You were correct, I'd installed 32bit version. My bad :D
Now installed 64bit & is working. Thanks for the solution. I appreciate it.

Krishna
Post Reply