TM1 Out of Memory

[Ajay]

Hi All

Wondering if any of you have had a similar experience. As you can see from the screenshot I have encountered a "TM1 is out of memory, exiting" message and as you can see from the task manager there is approx 67GB RAM on the server and about 51GB RAM available with the rest committed.

My tm1s.cfg file has the "MaximumViewSize=60000" so I think I have enough memory to cater for most views.

The error message occurred when amending one of my views via TI, which is based on a cube with is quite small in memory approx 380KB but does contain one dimension with approx 20million elements representing composite keys...which is telling me uses 4.8GB of memory.

I am wondering why, with so much memory available, not to mention approx 97GB of page file memory, why TM1 has run out.

Any words of wisdon would be appreciated

Thanks
Ajay

[Martin Ryan]

I've not seen that error before but I'd surmise that it's not a server problem, but a client problem. I suspect you have an enormous dimension that you're opening and the PC that you're running it on can't cope with it.

Try turning off the properties window, that might help a bit.

Martin

[Ajay]

Hi Martin

The screenshot is actually from the server.

I have a copy of perspectives which is installed on the server itself.

The dimension has 20million elements

Ajay

[Martin Ryan]

Ah. Thought you'd doctored the screenshot to show a client and the server together.

Can't find any suitable cfg parameters to suggest to you.

Could you post the TI code, highlighting the stage where it goes bad? Is it in the subset creation, or the view creation?

Martin

[Ajay]

Sorry, I mistaken wrote "amend via TI", I am actually using the "Export as ASCII data" to amend a very basic view of the cube.

I am wondering whether I should amend the view using a bit of TI instead, but everything still points to why is the system out of memory when so much is available ?

Ajay

[John Hammond]

The limit you are exceeding is on the server and seems to be the maximum size of a subset that can be edited. You possibly built this via TI and this is the first time you are editing it and 20m elements is mhoosive.

You could build a smaller subset of the most likely values and point the user to that as a starting point or your design may have to change in that you split your composite key into multiple dimensions.

[harrytm1]

Hi all,

Some of my users are experiencing this error message "TM1 out of memory, exiting ..." on their PC. They are using 9.5.2 FP1 and they are connected via WAN. Their office is located about 150km from the server.

It was reported that, when they opened a cube view, CPU utilisation on their PC goes up to 95%.

FYI, MaximumViewSize=500 is used in the tm1s.cfg. However, another group of users who are located at the Data Centre are able to open the said cube view without error.

So it seems that it is not related to the parameter. Anyone has any idea how to resolve this? Many thanks!

harry

[qml]

I would try and replace the dynamic subset you seem to be using with a static one. Maybe the subset recalculation is what takes up all this memory?