Page 1 of 1
Multicommit Chore runtime issue
Posted: Tue Dec 03, 2013 4:07 pm
by vinnusea
Hi,
I have a chore with 3 process (below). If i run Process 1 and process 2 separately they are running fine but it i put them in a chore and make it multicommit they are running for hours (22-33hrs) . Total time of chore should be not more than 16min. (process1 6min, Process2 10min ). I noticed the save data chore is overlapping this chore.
Chore Processes:
1.updating actuals to cube A,
2. a. Update actuals from Cube A to B b. Update forecast numbers from Cube F to Cube B
Does my multicommit mode could cause this issue or save data chore is causing this issue ? Can any one focus some light in which direction i should be investigate ?
TM1 10.1.1
ParallelInteraction=T
Thank you all taking time.
Thanks,
Re: Multicommit Chore runtime issue
Posted: Tue Dec 03, 2013 5:20 pm
by TableManagerOne
Sounds like it could be the SaveDataAll cache issue referenced
here.
User "whitej_d" suggested invalidating upstream cubes to set the cache right again. Perhaps you could insert a 4th process (just after the process containing the SaveDataAll) to force an invalidation?
Re: Multicommit Chore runtime issue
Posted: Wed Dec 04, 2013 5:26 am
by failurehappening
Does the same thing happen when the chore is run manually compared to when it is scheduled?
Re: Multicommit Chore runtime issue
Posted: Wed Dec 04, 2013 6:17 am
by BariAbdul
[quote="vinnusea"]Hi,
I have a chore with 3 process (below). If i run Process 1 and process 2 separately they are running fine but it i put them in a chore and make it multicommit they are running for hours (22-33hrs) .
The OP clearly mentions when the process run manually it throws no error.Thanks
Re: Multicommit Chore runtime issue
Posted: Wed Dec 04, 2013 10:21 am
by Edward Stuart
and failurehappening means if you run the chore without overlapping with the SaveDataAll chore does it take 22-33 hours
Re: Multicommit Chore runtime issue
Posted: Thu Dec 05, 2013 12:12 am
by failurehappening
BariAbdul wrote:vinnusea wrote:Hi,
I have a chore with 3 process (below). If i run Process 1 and process 2 separately they are running fine but it i put them in a chore and make it multicommit they are running for hours (22-33hrs) .
The OP clearly mentions when the process run manually it throws no error.Thanks
Yes I understood that when the processes are run manually they run ok, but I asked about the chore being run manually not the processes. It's an important difference...
http://www.tm1forum.com/viewtopic.php?f=3&t=9631
Re: Multicommit Chore runtime issue
Posted: Thu Dec 05, 2013 5:14 am
by BariAbdul
failurehappening wrote:BariAbdul wrote:vinnusea wrote:Hi,
I have a chore with 3 process (below). If i run Process 1 and process 2 separately they are running fine but it i put them in a chore and make it multicommit they are running for hours (22-33hrs) .
The OP clearly mentions when the process run manually it throws no error.Thanks
Yes I understood that when the processes are run manually they run ok, but I asked about the chore being run manually not the processes. It's an important difference...
http://www.tm1forum.com/viewtopic.php?f=3&t=9631
Thanks for link which explains the nuance between the two.Appreciate it.
Re: Multicommit Chore runtime issue
Posted: Thu Dec 05, 2013 8:02 pm
by vinnusea
Yes, I have disabled the savedata chore and still the issue continues. Tomorrow am planning to split the chore into 2
Chore1:
updating actuals to cube A
Chore2:
1.Update actuals from Cube A to B
2.Update forecast numbers from Cube F to Cube B
Hope this helps.