Multicommit Chore runtime issue

[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,

[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?

[failurehappening]

Does the same thing happen when the chore is run manually compared to when it is scheduled?

[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

[Edward Stuart]

and failurehappening means if you run the chore without overlapping with the SaveDataAll chore does it take 22-33 hours

[failurehappening]

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

[BariAbdul]

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.

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