empty TI Parameter in the Chore

Post Reply
EvgenyT
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

Post by EvgenyT »

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
Wim Gielis
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

Post by Wim Gielis »

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ç.
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
EvgenyT
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

Post by EvgenyT »

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 :x :x :x

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
Edward Stuart
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

Post by Edward Stuart »

I setup a quick process and chore in 10.2 to test this and received the following dialog box:
Chore Parameters Dialog.jpg
Chore Parameters Dialog.jpg (19.14 KiB) Viewed 5667 times
Seems to have been fixed in 10.2
EvgenyT
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

Post by EvgenyT »

Great. About time :roll: :roll:
Alan Kirk
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

Post by Alan Kirk »

EvgenyT wrote:Great. About time :roll: :roll:
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.

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.
User avatar
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

Post by Michel Zijlema »

Edward Stuart wrote:I setup a quick process and chore in 10.2 to test this and received the following dialog box:
Chore Parameters Dialog.jpg
Seems to have been fixed in 10.2
I get the same dialog in TM1 10.1... (when adding a parametrized process to a chore).

Michel
lotsaram
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

Post by lotsaram »

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

Post by EvgenyT »

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
EvgenyT
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

Post by EvgenyT »

Thanks for all the input gents!
Post Reply