How to solve SystemOutOfMemory errors when running reports?

Post Reply
Stanislav2
Posts: 31
Joined: Tue Aug 20, 2013 5:53 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: -

How to solve SystemOutOfMemory errors when running reports?

Post by Stanislav2 »

Hi,
we are executing reports using Cognos BI 10.2.1 against TM1 server. We have migrated TM1 from version 10.1.1 64-bit Fixpack 2 to version 10.2.2 64-bit Fixpack 6.

What we are now seeing as a problem in new TM1 server (previous TM1 server working fine) is some of the reports returning error (cubes haven't changed in size or similar):

Code: Select all

XQE-GEN-0010 'XQERuntimeException'
XTM-JAP-0002 An error was reported by the TM1 API. The TM1 error code is: "SystemOutOfMemory". The TM1 error message is: "SystemOutOfMemory".
I have checked on Windows system where TM1 is running and there is 30 GB of memory and during execution of particular report Windows server never consumes more then 20 GB of memory, so there is 10 GB of memory available. Don't understand how it can be system out of memory problem.

Has someone experience this problem and is there a solution to it?
Regards
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: How to solve SystemOutOfMemory errors when running reports?

Post by jim wood »

What setting do you have for view size?
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
Stanislav2
Posts: 31
Joined: Tue Aug 20, 2013 5:53 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: -

Re: How to solve SystemOutOfMemory errors when running reports?

Post by Stanislav2 »

@Jim, in tm1 v10.1.1 I didn't use any special parameters, but now after migration in tm1 10.2.2 I noticed some warnings in log file and searched the web and suggested solution was to increase the MaximumViewSize parameter, I did and warnings were gone. I set parameter value to:

Code: Select all

MaximumViewSize=2048
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: How to solve SystemOutOfMemory errors when running reports?

Post by jim wood »

Glad to hear that it's fixed.
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
Stanislav2
Posts: 31
Joined: Tue Aug 20, 2013 5:53 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: -

Re: How to solve SystemOutOfMemory errors when running reports?

Post by Stanislav2 »

Jim, no we don't understand each other. After installing TM1 10.2.2 I notice some of the warnings in log file and so set MaximumViewSize=2048. I was just letting you to know that this setting is not set as default 500 as it was in TM1 10.1.1. I still haven't fixed "SystemOutOfMemory" problem. Do you think I should increase this parameter even more? Is this parameter influencing the "system out of memory"? How do I calculate the size of this parameter to set it optimal?
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: How to solve SystemOutOfMemory errors when running reports?

Post by Duncan P »

This APAR might be relevant depending on the version of BI you are using.
Stanislav2
Posts: 31
Joined: Tue Aug 20, 2013 5:53 am
OLAP Product: TM1
Version: 10.1.1
Excel Version: -

Re: How to solve SystemOutOfMemory errors when running reports?

Post by Stanislav2 »

Duncan, I am using Cognos 10.2.1 64-bit fixpack 12, so this should not be a problem. According to the APAR it should be fixed in fixpack 4.
I am also not getting the same error message. My error message is as posted in my first post in this thread.
Sebastian Ortlieb
Posts: 4
Joined: Fri Mar 31, 2017 5:51 am
OLAP Product: TM1
Version: 10.2.2 FP 6 /FP 7
Excel Version: 2013
Location: Frankfurt, Germany

Re: How to solve SystemOutOfMemory errors when running reports?

Post by Sebastian Ortlieb »

Can you build the view with TM1 Architect? would be a test if it is more a tm1 or a BI issue.
Post Reply