Bad news here guys... :-/
Still sometimes hangs on "Commit changes", }StatsBy... cubes hangs in "cub$" state and the only way is to kill the process manually.
Any other suggestions?
Search found 110 matches
- Sat May 05, 2018 7:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 instance stuck on restart on StatsBy... cub files
- Replies: 8
- Views: 5110
- Sat May 05, 2018 12:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
Ok, understood but I suppose this has nothing to do with the RAM consumption, right?
- Fri May 04, 2018 9:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
Few additional notes but not sure if it changes anything... I'm using this code in a TI process that is run by Hustle in 12 parallel threads, approx. 380 calls in total (total number of Organization_parent members). This code is wrapped in a WHILE loop which loops over all leaf products -> the outpu...
- Fri May 04, 2018 9:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 instance stuck on restart on StatsBy... cub files
- Replies: 8
- Views: 5110
Re: TM1 instance stuck on restart on StatsBy... cub files
Hmm, that's interesting... It seems that it works!
Let's wait for a while if the issue is resolved. Thank you sir!
- Fri May 04, 2018 12:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 instance stuck on restart on StatsBy... cub files
- Replies: 8
- Views: 5110
- Fri May 04, 2018 12:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
How about posting the actual code you used to create and zero suppress the view? ViewCreate(sCubeName, sViewName, 1); ViewExtractSkipZeroesSet(sCubeName, sViewName, 1); ViewExtractSkipRuleValuesSet(sCubeName, sViewName, 0); ViewExtractSkipCalcsSet(sCubeName, sViewName, 0); # Rows ViewRowDimensionSe...
- Fri May 04, 2018 12:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
Agree with Steve and everyone else: feed the rules, it is the right solution. Even if exporting simple data (with zero suppression on source temporary data form enabled) there's quite big RAM consumption. So it seems to me that correct feeding doesn't solve the issue... :-/ Any other suggestions?
- Thu May 03, 2018 7:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 instance stuck on restart on StatsBy... cub files
- Replies: 8
- Views: 5110
Re: TM1 instance stuck on restart on StatsBy... cub files
I think there is some conflicting between the two functions. If you use savedataall, it is unnecessary to use CubeSaveData to save all cubes. I don't think that this is the reason - sometimes it is restarted successfully, but most of the times it is stuck. Btw. when I don't run CubeSaveData and kil...
- Wed May 02, 2018 9:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 instance stuck on restart on StatsBy... cub files
- Replies: 8
- Views: 5110
- Wed May 02, 2018 7:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 instance stuck on restart on StatsBy... cub files
- Replies: 8
- Views: 5110
TM1 instance stuck on restart on StatsBy... cub files
Hi guys, we are experiencing weird behavior when trying to restart a TM1 instance. It is stuck on "TM1ServerImpl::Destroy: Commit changes" and it never ends. So the only way is to kill the process itself... In the Data folder I can see that all "StatsBy..." cubes are being overwr...
- Fri Apr 13, 2018 6:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
Changing a value in a cube clears the cache for that cube and any 'downstream' cubes ie those which are linked back to that cube. Ok, let's try it this way... After each file is generated and the TI process goes to its Epilog part I will put a value somewhere to the source cube. Let's see what happ...
- Thu Apr 12, 2018 9:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
If your dataset is not fed then the RAM consumption on exporting will be much larger than it needs to be, how much bigger depends on the level of sparsity. How many zero values are in the flat file (assuming you don't filter them out on export). Every zero will cost just as much as a value. The onl...
- Thu Apr 12, 2018 7:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
I think this is my problem here... All cells in the cube are calculated (and unfortunately not fed - the model is too complicated to be fed correctly but as far as I understand even exporting correctly fed cells won't solve the issue) so all memory is cunsumed by calculations and therefore not rele...
- Thu Apr 12, 2018 5:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
Once a TI process is finished (at least in 10.2.2 and above) this memory is released back to the OS unlike memory for calculation and view cache which stays in TM1's insternal garbage recycling. This was a surprise to me the first time I saw it. I think this is my problem here... All cells in the c...
- Thu Apr 12, 2018 3:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Re: Exporting data from view to file consuming memory
If memory is really constrained you could clear the cache periodically by changing a value somewhere and changing it back again What do you mean by clearing the cache? Do you mean deleting stargate views? I'm afraid it won't release garbage memory which is what I need... Or am I wrong? The other wa...
- Thu Apr 12, 2018 2:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Exporting data from view to file consuming memory
- Replies: 19
- Views: 14473
Exporting data from view to file consuming memory
Hi guys, is there any difference when exporting data to files and importing it back to the target cube and moving data between cubes using CellPutN in regards of memory consumption? I'm exporting quite a huge amount of data to files but it consumes a lot of RAM and after the export is finished it''s...
- Wed Mar 28, 2018 11:24 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ForceReevaluationOfFeedersForFedCellsOnDataChange & no conditional feeders
- Replies: 0
- Views: 2830
ForceReevaluationOfFeedersForFedCellsOnDataChange & no conditional feeders
Hi guys,
just a quick check - if we don't use any conditional feeders, we can safely turn off ForceReevaluationOfFeedersForFedCellsOnDataChange in cfg, right?
We need to leave it in the cfg because of PM but we can switch it off by setting it to "F".
Is it correct?
BR
Vladino
just a quick check - if we don't use any conditional feeders, we can safely turn off ForceReevaluationOfFeedersForFedCellsOnDataChange in cfg, right?
We need to leave it in the cfg because of PM but we can switch it off by setting it to "F".
Is it correct?
BR
Vladino
- Thu Mar 01, 2018 2:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel run vs. ICX
- Replies: 11
- Views: 9704
Re: Parallel run vs. ICX
If it's not the same cube then view names could be the same. If dimensions are common even if cubes aren't then the subsets need to be uniquely named if there is any manipulation (editing) of the subsets . You could use the same subset name where all the TI processes don't touch or edit the subset ...
- Thu Mar 01, 2018 2:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel run vs. ICX
- Replies: 11
- Views: 9704
Re: Parallel run vs. ICX
I guess it depends on what is the purpose of both processes?
- Thu Mar 01, 2018 6:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Parallel run vs. ICX
- Replies: 11
- Views: 9704
Re: Parallel run vs. ICX
All object names need to be unique. For parallel processing from/to the same cube it is important that all views and all subsets be uniquely named. Even if all views are using the same subset for products, measures etc? It's not the same cube, I'm just exporting the data from the cube to the text f...