-----------------------------------------------------------------------------------------------------------
There appears to be a bug in the Load on Demand property for cubes.
I encountered a number of problems loading our 8.2.12 production data in 9.1 SP4. Most of the time the server wouldn't start at all, with the service generating an error "TM1 Server Abort: System Out Of Memory." The TM1Server.log file read:
Code: Select all
308 ERROR 2008-11-16 23:02:09,092 TM1.Server.Memory CommonAlloc - alloc (size = 131072) failed: Not enough storage is available to process this command.
On that occasion the server started and appeared to be running normally... except that it wouldn't let anyone, not even TM1Top, connect to it. This in itself may be a separate bug, but I need to chase this down further to be able to replicate it. (Unless it's something that you're already aware of.)
I took out the large cube again and restarted the server. What I found was that every data cube which has rules had ignored the Load On Demand property for every cube that has rules in it, even if the rules are purely internal. (No calculations reading from the cube, no feeders going out from the cube.)
This isn't what the documentation says happens; it states that:
"By default, TMI loads all cubes into memory when a server starts. While this allows fast access to TM1 data, it can consume significant server resources. If your server contains infrequently accessed cubes, you can conserve resources by setting those cubes to load only when a client attempts to access the cube data."
Clearly, this isn't what's happening here. (Nor are any chores running which access the cubes. Only one chore is active on the 9.1 SP4 test server, and all it does is a scheduled data save.)
I've attached a screenshot showing the cube memory usage, with the properties dialog of the first cube (showing the load on demand checkbox checked) ovberlaid. There is no way on earth those first 10 or so cubes aren't fully loaded into memory.
On the other hand a couple of significant data cubes which have no rules at all show memory usage of only about 30k, which is what I'd expect.
Could you please investigate and advise.
Thank you.