Page 1 of 1

Chore Splitting

Posted: Thu Mar 01, 2012 4:44 pm
by AmbPin
I have a chore with a lot of processes that controls a daily data load and dimension maintenance tasks etc. This chore has been running successfully for quite some time until today. Yesterday I added a process that emails people when their password is about to expire using the following line of code in the data section of a TI process.
ExecuteCommand(sCmdLine, 0);
Where the command line calls a BAT file which in turn calls a VBS. This is all fairly standard practice which to be honest I cribbed from this and other forums.
I placed this process fairly near the beginning of the chore and what I noticed was that for every email generated a separate execution of all of the remaining processes in the chore took place! Has anyone seen anything like this behaviour?

Re: Chore Splitting

Posted: Thu Mar 01, 2012 5:29 pm
by Martin Ingram
Never - but it may help others if you say which version of the software you're running...

Re: Chore Splitting

Posted: Fri Mar 02, 2012 10:28 am
by AmbPin
Oops - Running 9.5.2 on Windows 2008 R2 Server.

Re: Chore Splitting

Posted: Sat Mar 03, 2012 12:47 am
by Alan Kirk
AmbPin wrote:I have a chore with a lot of processes that controls a daily data load and dimension maintenance tasks etc. This chore has been running successfully for quite some time until today. Yesterday I added a process that emails people when their password is about to expire using the following line of code in the data section of a TI process.
ExecuteCommand(sCmdLine, 0);
Where the command line calls a BAT file which in turn calls a VBS. This is all fairly standard practice which to be honest I cribbed from this and other forums.
I placed this process fairly near the beginning of the chore and what I noticed was that for every email generated a separate execution of all of the remaining processes in the chore took place! Has anyone seen anything like this behaviour?
- Are you using ExecuteProcess anywhere in your code?
- Are the log files showing anything about a rollback occurring?

Re: Chore Splitting

Posted: Mon Mar 05, 2012 2:52 pm
by AmbPin
Not using ExecuteProcess and no sign of any rollback in the log files.