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.