empty TI Parameter in the Chore
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
empty TI Parameter in the Chore
Hi Gents,
I have noticed a very annoying thing: when one of the TI's in the chore has a parameter and you forget to set a default value (silly me), then the chore errors out and an error a Temp log file gets created for the failed process...like TM1ProcessError_processname.log$. Annoying thing is that the file "hangs" (hence $ indicates that) and you cant delete it until you re kick the server.
While solution is obvious - don't forget to set the parameter... I just find it to be rather irritating error-handling procedure....
You thoughts gentlemen?
EvgenyT
I have noticed a very annoying thing: when one of the TI's in the chore has a parameter and you forget to set a default value (silly me), then the chore errors out and an error a Temp log file gets created for the failed process...like TM1ProcessError_processname.log$. Annoying thing is that the file "hangs" (hence $ indicates that) and you cant delete it until you re kick the server.
While solution is obvious - don't forget to set the parameter... I just find it to be rather irritating error-handling procedure....
You thoughts gentlemen?
EvgenyT
-
- MVP
- Posts: 3241
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: empty TI Parameter in the Chore
I agree, it's annoying (although I never ran into that situation of erroring out).
My preference is to have 1 TI process that kicks off other TI processes.
The first TI could be scheduled in a chore, but I dislike having say 15 TI's in 1 chore, all with similar parameter values (scenario, year, period, ...)
Possibly, store the parameter values in a cube and get them from there.
My 2ç.
My preference is to have 1 TI process that kicks off other TI processes.
The first TI could be scheduled in a chore, but I dislike having say 15 TI's in 1 chore, all with similar parameter values (scenario, year, period, ...)
Possibly, store the parameter values in a cube and get them from there.
My 2ç.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: empty TI Parameter in the Chore
Very true Wim,
I know there are several work-arounds, but from error-handling perspective its very annoying and not intuitive at all, plus you cant open the error log since its a corrupted $ file
Basically trial and error, approach here...
Perhaps its been fixed in 10.2, but I havent looked at bug fixes list as yet or tested new version.
Any ideas gentlemen?
Evgeny
I know there are several work-arounds, but from error-handling perspective its very annoying and not intuitive at all, plus you cant open the error log since its a corrupted $ file



Basically trial and error, approach here...
Perhaps its been fixed in 10.2, but I havent looked at bug fixes list as yet or tested new version.
Any ideas gentlemen?
Evgeny
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: empty TI Parameter in the Chore
I setup a quick process and chore in 10.2 to test this and received the following dialog box:
Seems to have been fixed in 10.2
Seems to have been fixed in 10.2
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: empty TI Parameter in the Chore
Great. About time



-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: empty TI Parameter in the Chore
I must confess to having wondered about this thread, because I know that in 9.0 SP3 U9 I couldn't create one without a default either, though I haven't tried in 9.5.2. Which means that it was presumably something that was broken between 9.0 and 10.1, then fixed again in 10.2. That is, until it gets broken again.EvgenyT wrote:Great. About time![]()
Curiously just recently I was reading a process with the API (one of the Iboglix-defined processes in one of the sample databases, no less) and it spat the dummy when reading the parameter defaults. Instead of a string the value capsule held an error value telling me that the parameter wasn't defined. So it's not just end users who forget...
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: empty TI Parameter in the Chore
I get the same dialog in TM1 10.1... (when adding a parametrized process to a chore).Edward Stuart wrote:I setup a quick process and chore in 10.2 to test this and received the following dialog box:
Seems to have been fixed in 10.2
Michel
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: empty TI Parameter in the Chore
my 2c this is a ridiculous inconsistency between various interfaces
ExecuteProcess needs named parameters and doesn't care about parameters that aren't passed and assumes the default value in this case. Values passed and default values can be empty strings.
Chores require an entry for each parameter, the parameter value can't be an empty string even if this is the default value.
Tools connecting vie the API (RunTI, ProcessExecute, Cubeware IMRUN, etc.) require a parameter array with the correct number of params for the process, each param requires a value but values can be empty.
IMO the approach with chores is wrong. Be consistent with either ExecuteProcess and take the default if the value is empty or allow a null value.
Rant over.
ExecuteProcess needs named parameters and doesn't care about parameters that aren't passed and assumes the default value in this case. Values passed and default values can be empty strings.
Chores require an entry for each parameter, the parameter value can't be an empty string even if this is the default value.
Tools connecting vie the API (RunTI, ProcessExecute, Cubeware IMRUN, etc.) require a parameter array with the correct number of params for the process, each param requires a value but values can be empty.
IMO the approach with chores is wrong. Be consistent with either ExecuteProcess and take the default if the value is empty or allow a null value.
Rant over.
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: empty TI Parameter in the Chore
I get the same dialog in TM1 10.1... (when adding a parametrized process to a chore).
Forgot to mention Im on 10.1.1
-
- Community Contributor
- Posts: 324
- Joined: Mon Jul 02, 2012 9:39 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: 2016
- Location: Sydney, Australia
Re: empty TI Parameter in the Chore
Thanks for all the input gents!