TI Chore and Process EXEs

Ideas and tips for enhancing your TM1 application

TI Chore and Process EXEs

Postby Mike Cowie » Sat Sep 06, 2008 9:34 pm

Hi everyone,

I thought I'd post something we put together quite a few years ago (in VC++) that I've since updated to correct a few bugs. Included are TM1ChoreExecute.exe and TM1ProcessExecute.exe, which might be of some use to anyone wanting to execute a TI process or chore from a command-line. The Readme gives some basic instruction/documentation, but feel free to send me a PM if you have any problems or questions.

TIExecute.zip
TM1 Process and Chore Executables
(426.49 KiB) Downloaded 1960 times

Version 0.2 Updated 9/6/2008

The usual disclaimers apply... no warranties and not responsible for what the TI process or chore you run does to your TM1 server.

Regards,
Mike
User avatar
Mike Cowie
Site Admin
 
Posts: 404
Joined: Sun May 11, 2008 7:07 pm
Location: North Carolina, USA
OLAP Product: TM1, MSAS
Version: Anything thru 10.x
Excel Version: 2003 - 2010

Re: TI Chore and Process EXEs

Postby wudznet » Thu Feb 04, 2010 11:52 pm

Hi,

I tried using the TM1ChoreExecute.exe and I always get an error of SystemServerNotfound. I am using TM1 9.4

I am wondering if you can help me..

Thanks very much

Wudz
wudznet
 
Posts: 4
Joined: Thu Feb 04, 2010 11:48 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: TI Chore and Process EXEs

Postby Steve Rowe » Sat Feb 06, 2010 9:35 am

Wudz, this means that the script is not finding your tm1 host server, either you've not set the parameter for the box running your TM1 server or it can't be seen from where you are running the script.
User avatar
Steve Rowe
Site Admin
 
Posts: 1223
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 9.0 9.1 9.5
Excel Version: Nearly all of them

Re: TI Chore and Process EXEs

Postby wudznet » Tue Feb 09, 2010 1:19 am

Thanks Steve ..

I am just newbie in this kind of things .. I am not sure if I need to setup anything from the server or from my batchfile to run TM1ChoreExecute.exe.

Please see below the command from my batch file

TM1ChoreExecute.exe ServerName TM1instance(servername) userID password Chorename

I am not sure if I need anything in my batch file ..

Thanking you
wudznet
 
Posts: 4
Joined: Thu Feb 04, 2010 11:48 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: TI Chore and Process EXEs

Postby Steve Rowe » Tue Feb 09, 2010 9:14 am

Say you have a TM1 server called TM1Server and it's running on a physical server called TM1Host and you want to run the chore Test, your call should read.

TM1ChoreExecute.exe TM1Host TM1Server User Password Test

Where a user and password is a valid log in with read access to the chore.
User avatar
Steve Rowe
Site Admin
 
Posts: 1223
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 9.0 9.1 9.5
Excel Version: Nearly all of them

Re: TI Chore and Process EXEs

Postby wudznet » Wed Feb 10, 2010 12:39 am

Steve Rowe wrote:Say you have a TM1 server called TM1Server and it's running on a physical server called TM1Host and you want to run the chore Test, your call should read.

TM1ChoreExecute.exe TM1Host TM1Server User Password Test

Where a user and password is a valid log in with read access to the chore.

Hi Steve,

I have the same parameter in my batch .. what I did was add another command to log on to the server then execute the TM1ChoreExecute ..

However, I have a different error now TM1ChoreExecute error code 1 .. I am not sure what this is ..

Thanks again ...
wudznet
 
Posts: 4
Joined: Thu Feb 04, 2010 11:48 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: TI Chore and Process EXEs

Postby Steve Rowe » Wed Feb 10, 2010 7:28 am

Yous shouldn't need to log onto the server seperatly, the chore code handles that. Like you I don't know what the message means, a guess would be that user you are using is only allowed one login (see }client properties) and when the chore execute process logs in it can't?

Cheers
User avatar
Steve Rowe
Site Admin
 
Posts: 1223
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 9.0 9.1 9.5
Excel Version: Nearly all of them

Re: TI Chore and Process EXEs

Postby MarioRubbo » Wed Jun 30, 2010 1:21 pm

Does anyone know if a UNIX version of these utilities exists somewhere? I need to kick off a cube build from an external scheduling utility called AutoSys. TM1 is running on an AIX server. Alternately, if anyone can suggest an approach for developing this utility, I would appreciate it. For example, use the TM1 API to create a Java executable on the UNIX server to execute a TI Process/Chore.

Thanks!
MarioRubbo
 
Posts: 44
Joined: Wed Nov 04, 2009 3:50 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: TI Chore and Process EXEs

Postby MarioRubbo » Fri Jul 16, 2010 5:36 pm

Here is a UNIX utility that I've developed using the Java API. For UNIX environments, you can use this to kick off TM1 Chores from an external OS utility and/or scheduling program AutoSys, etc.
utilities.zip
UNIX shell scripts to build and run, Java source and binary to run
(83.5 KiB) Downloaded 116 times
MarioRubbo
 
Posts: 44
Joined: Wed Nov 04, 2009 3:50 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: TI Chore and Process EXEs

Postby Mike Cowie » Sat Oct 09, 2010 2:51 pm

Hi everyone:

I've just posted a totally new version of a command-line TI process/chore execution utility here:
http://forums.olapforums.com/viewtopic.php?f=21&t=3486

Sorry for the delay. This replaces the older TM1ChoreExecute and TM1ProcessExecute command-line utilities included in this thread, and now has support for CAM login methods.

Regards,
Mike
User avatar
Mike Cowie
Site Admin
 
Posts: 404
Joined: Sun May 11, 2008 7:07 pm
Location: North Carolina, USA
OLAP Product: TM1, MSAS
Version: Anything thru 10.x
Excel Version: 2003 - 2010

Re: TI Chore and Process EXEs

Postby jim wood » Mon Oct 11, 2010 11:58 am

Thanks Mike. We have been using the original schedule execute version without a problem fro around 12 months.

Excellent stuff and fine example of what this community is capable of.
Legal Advisory: These are my personal opions... My opinion is I'm right most of the time.
ACG TM1 / Essbase Consulting
Server(s): Windows Server 2008 SP1 64-bit. TM1 Version: 9.5.2 Client(s): Windows XP.
User avatar
jim wood
Site Admin
 
Posts: 2385
Joined: Wed May 14, 2008 1:51 pm
Location: 1639 Route 10, Suite 107, Parsippany, NJ
OLAP Product: TM1
Version: TM1 9.5.2 EV 9.5.0
Excel Version: 2007

Re: TI Chore and Process EXEs

Postby Mike Cowie » Tue Oct 12, 2010 11:43 am

jim wood wrote:Thanks Mike. We have been using the original schedule execute version without a problem fro around 12 months.


Hi Jim,

Thanks very much for the feedback. You bring up a very good point that I should have highlighted: there is no reason to stop using TM1ProcessExecute or TM1ChoreExecute if they are already working well for you. The newer version is mainly intended to address the need for additional login methods for things like Cognos Express (which were tough to squeeze into the existing EXE's command-line structure) and to allow some client SSL configuration.

Regards,
Mike
User avatar
Mike Cowie
Site Admin
 
Posts: 404
Joined: Sun May 11, 2008 7:07 pm
Location: North Carolina, USA
OLAP Product: TM1, MSAS
Version: Anything thru 10.x
Excel Version: 2003 - 2010


Return to Useful code, tips and tricks

Who is online

Users browsing this forum: No registered users and 1 guest

Loading