Execute Command problem

Post Reply
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Execute Command problem

Post by AnonimusMax »

Hi,

I have the following problem. The server has 16 cores of 2.5.
I have a process that has 6 Execute Command in it. The code is placed in prolog Tab.
The problem is that this 6 processes that run from ExecuteCommand, don t start in parallel. They run 2 at once, after this 2 end another one start and so on. They don t start all 6 at once.
Why they are not running in parallel? there was nothing else running in TM1 at that moment.
Also i Checked the logfile and for example process A, start in parallel with processes B,C at 10:00. But when i further check the log, this process A starts also at 10:10 and finishes only once at 10:15. Why does it have 2 starts?

In the configuration file I have MTQ=-3 and maxnumberofthreads commented.

Thank you
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Execute Command problem

Post by Edward Stuart »

Do your processes lock each other up?

Take a look at Greeny Dangerous's blog post on the subject:
this is the most important part: one must design the runnable TI process in way that when it’s executed in separate threads the executions dont lock up each other
http://www.google.co.uk/amp/s/greenydan ... cores/amp/
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Execute Command problem

Post by AnonimusMax »

I already did what he suggested in the post.
It works. Thank you for the reply :)
AnonimusMax
Posts: 60
Joined: Thu Nov 17, 2016 2:13 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Execute Command problem

Post by AnonimusMax »

Reopen Topic.

I did what was suggest on the link that you sent me. So for my DEV environment everything is running in parallel.
I have 3 processes that update the same cube with data from DB. On my dev environment they run in parallel, on my INT environment they don t.
They put each other on HOLD. I ve looked at the configuration file, and they are the same. Except the one on int have MaximumCubeLoadThreads=12. i Had it commmented before and the behavior was the same. And now i set it to 12, i thought this was the solution.

Please advice what to do..
thank you
Post Reply