Hi All,
I have a Master process that kicks off a whole heap of other TI processes using the EXECUTEPROCESS function
however when it encounters a TI that errors it aborts the Master process and does not continue onto the next TI process unlike a chore.
Is there a way for the process to keep on going to the next processes without it aborting??
Cheers
Zark
Master Process aborts when nested process fails
-
- MVP
- Posts: 3705
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Master Process aborts when nested process fails
You need to give an actual example of the code you are using, what the called process is doing (including maybe the code) and the error that is in tm1server.log and the process error log.
Usually "shelling out" to another process can actually be a god way of avoiding a process quitting as the major error happens in the called process and the calling process continues just reporting that the sub.process encountered an error.
If the whole thing is aborting then you probably have a major error that you need to debug and handle in any case.
Usually "shelling out" to another process can actually be a god way of avoiding a process quitting as the major error happens in the called process and the calling process continues just reporting that the sub.process encountered an error.
If the whole thing is aborting then you probably have a major error that you need to debug and handle in any case.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 81
- Joined: Tue May 31, 2011 6:29 am
- OLAP Product: TM1 and EV
- Version: 9.1 SP3
- Excel Version: Excel 2010
Re: Master Process aborts when nested process fails
Hi Lotsa,
Thanks for the feedback. The error is in relation population of attiribute values for a personnel dimension,where and element shares the same attribute value, so when the data attribute value is being populated it cannot populate it since it already exists.
So just a general question, if a sub process fails regardless of whether its nasty or not, will the subsequent processes run or will they stop ( this is what I have found ), BUT does it depend on severity of the fail? i.e. if its a minor error will it just continue on?
Since this morning load needs to continue on regardless of whether there is an error in process ( like a chore ) is there and equivalent to cmd line utility like RUNTI but for chores i.e. RUNCHORE??. If so can you point me where i might be able to find this tool?
Cheers
Zark
Thanks for the feedback. The error is in relation population of attiribute values for a personnel dimension,where and element shares the same attribute value, so when the data attribute value is being populated it cannot populate it since it already exists.
So just a general question, if a sub process fails regardless of whether its nasty or not, will the subsequent processes run or will they stop ( this is what I have found ), BUT does it depend on severity of the fail? i.e. if its a minor error will it just continue on?
Since this morning load needs to continue on regardless of whether there is an error in process ( like a chore ) is there and equivalent to cmd line utility like RUNTI but for chores i.e. RUNCHORE??. If so can you point me where i might be able to find this tool?
Cheers
Zark
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Master Process aborts when nested process fails
By default the master process will be fine to continue and just report minor errors itself if its sub processes have minor errors. You can however use the process returned value to quit the master process on any error if you desire.
Declan Rodger
- Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Master Process aborts when nested process fails
Your best bet is to properly trap and test for the error before it occurs rather than try and run your code such that a fatal error has a lower impact.
I think you are trying to update an alias (rather than an attribute) and sometimes the alias value already exists as an element?
If so suggest you do a dimix test on the alias value before you update the dimension, if the dimix test returns greater than 0 then don't do the update operation.
HTH
Cheers,
I think you are trying to update an alias (rather than an attribute) and sometimes the alias value already exists as an element?
If so suggest you do a dimix test on the alias value before you update the dimension, if the dimix test returns greater than 0 then don't do the update operation.
HTH
Cheers,
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Posts: 81
- Joined: Tue May 31, 2011 6:29 am
- OLAP Product: TM1 and EV
- Version: 9.1 SP3
- Excel Version: Excel 2010
Re: Master Process aborts when nested process fails
Thanks Steve, yep that will fix it.
However I always thought that in the event of
Any error sub processes fired from within
A master process using the Executeprocess function
the master process would still continue on. I
was surprised that this was not the case, even
If the sub process aborted in the case where it is fatal.
Since, the master process executes in sequence
roughly 80 processes which form the part of our
Morning load it is essential that all processes
Continue on regardless of the prior state of the previous
Process. Running a chore essentially bull dozes
It's way through regardless of the state of the
Previous process and in this circumstance is safer
IMO. I agree that fixing the root cause is
Important here and substantial time will be required
To build this in. But in this case running this via a chore
( Via mike cowies cmd line tool ) Taking into account all the benefits of running
This in a master TI comes up trumps for me.
However I always thought that in the event of
Any error sub processes fired from within
A master process using the Executeprocess function
the master process would still continue on. I
was surprised that this was not the case, even
If the sub process aborted in the case where it is fatal.
Since, the master process executes in sequence
roughly 80 processes which form the part of our
Morning load it is essential that all processes
Continue on regardless of the prior state of the previous
Process. Running a chore essentially bull dozes
It's way through regardless of the state of the
Previous process and in this circumstance is safer
IMO. I agree that fixing the root cause is
Important here and substantial time will be required
To build this in. But in this case running this via a chore
( Via mike cowies cmd line tool ) Taking into account all the benefits of running
This in a master TI comes up trumps for me.