Search found 110 matches

by vladino
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: 4991

Re: TM1 instance stuck on restart on StatsBy... cub files

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?
by vladino
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: 12802

Re: Exporting data from view to file consuming memory

tomok wrote: Sat May 05, 2018 10:48 am FWIW, these are a waste of time in a TI process as each cell is read as a single record with no concept of context, rows, or columns. These statements are for views you intend to view in the Cube Viewer
Ok, understood but I suppose this has nothing to do with the RAM consumption, right?
by vladino
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: 12802

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...
by vladino
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: 4991

Re: TM1 instance stuck on restart on StatsBy... cub files

vladino wrote: Fri May 04, 2018 12:36 pm
gtonkin wrote: Thu May 03, 2018 7:18 am Are your saves in Epilog?-had issues previously with these in Prolog.
Both CubeSaveData and SaveDataAll are in Prolog... I will give it a try and let you know guys, thanks!
Hmm, that's interesting... It seems that it works! :)

Let's wait for a while if the issue is resolved. Thank you sir!
by vladino
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: 4991

Re: TM1 instance stuck on restart on StatsBy... cub files

gtonkin wrote: Thu May 03, 2018 7:18 am Are your saves in Epilog?-had issues previously with these in Prolog.
Both CubeSaveData and SaveDataAll are in Prolog... I will give it a try and let you know guys, thanks!
by vladino
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: 12802

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...
by vladino
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: 12802

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?
by vladino
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: 4991

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...
by vladino
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: 4991

Re: TM1 instance stuck on restart on StatsBy... cub files

macsir wrote: Wed May 02, 2018 9:13 pm Never heard about that before. Did you manually save data before restarting?
Sure, I have written a process that runs CubeSaveData for all cubes and before restarting the instance I'm also running SaveDataAll.
by vladino
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: 4991

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...
by vladino
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: 12802

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...
by vladino
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: 12802

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...
by vladino
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: 12802

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...
by vladino
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: 12802

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...
by vladino
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: 12802

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...
by vladino
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: 12802

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...
by vladino
Wed Mar 28, 2018 11:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ForceReevaluationOfFeedersForFedCellsOnDataChange & no conditional feeders
Replies: 0
Views: 2244

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
by vladino
Thu Mar 01, 2018 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 8967

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 ...
by vladino
Thu Mar 01, 2018 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 8967

Re: Parallel run vs. ICX

Drg wrote: Thu Mar 01, 2018 1:51 pm dear friend, let's imagine a situation where you open an architect and run one of your processes. after you run another architect and try to log in and execute the second process.
what result will you get?
I guess it depends on what is the purpose of both processes? :)
by vladino
Thu Mar 01, 2018 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 8967

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...