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
Execute Command problem
-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
-
- 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
Do your processes lock each other up?
Take a look at Greeny Dangerous's blog post on the subject:
Take a look at Greeny Dangerous's blog post on the subject:
http://www.google.co.uk/amp/s/greenydan ... cores/amp/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
-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Execute Command problem
I already did what he suggested in the post.
It works. Thank you for the reply
It works. Thank you for the reply

-
- Posts: 60
- Joined: Thu Nov 17, 2016 2:13 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Execute Command problem
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
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