TM1ChoreExecute

[Andy Key]

Attached is the Applix utility to Execute TM1 Chores from the command line or batch files. Documentation is included.

This came from Applix, but use it at your own discretion!

[Mike Cowie]

Hi everyone,

A little bit of overlap, but I thought I'd post something similar we put together quite a few years ago (in VC++). The TM1ChoreExecute should be similar to the Applix-created EXE. Also included, however, is a TM1ProcessExecute.exe, which might be of some use. The Readme isn't incredibly detailed, but I at least took the time to do a find and replace on iTM1!

TIExecute.zip

TI Process and Chore Executeables

(426.49 KiB) Downloaded 1065 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

[daveed]

Something to be aware of with the TM1ChoreExecute.exe from Applix, is that it will not work with SSL.

[Mike Cowie]

Dave,

Can you clarify what you mean here? If the Applix-created TM1ChoreExecute.exe uses the TM1 API then it should work with 9.1, regardless of whether the SSL option is on or off.

One problem you may encounter is that the TM1 API has additional required files/folder in 9.1, in general (highlighted in bold):
* TM1API.DLL
* TM1LIB.DLL
* TM1SIP.DLL
* ssleay32.dll
* libeay32.dll
* \ssl subfolder

All of these files and folder can be found in the Applix/Cognos-installed \Bin folder.

I've needed these additional files even if I didn't have SSL activated. The Cognos TM1 API documentation still neglects to mention the need for these additional files. In terms of file locations, your best bet is often to put a copy of these API files and subfolder in the same location as the executable (TM1ChoreExecute.exe or TM1ProcessExecute.exe). This is particularly true since libeay32.dll and ssleay32.dll are open-source DLL's that may reside elsewhere in your machine's path and, if a different version, can result in errors. Note that you will typically get the same error if any of the above API files are missing: "File not found: TM1API.DLL".

Regards,

[daveed]

Mike,

I was advised by Cognos support, in the UK, that the TM1ChoreExecute.exe would not work with 9.1 using SSL.

[Mike Cowie]

Mike,

I was advised by Cognos support, in the UK, that the TM1ChoreExecute.exe would not work with 9.1 using SSL.

Dave,

Sorry for the delayed response - I hadn't had a chance to follow-up and do some quick tests.

I'm afraid Cognos support in the UK is mistaken.

I've been able to run Cognos' TM1ChoreExecute.EXE and the 2 EXE's I posted without a problem in TM1 9.1 SP3. This is good news for anyone who would still like to use these in TM1 9.1!

The only thing to watch out for is that you need to include all of the TM1 API-related files, including a few new files & folder for TM1 9.1, specifically (listed above in this thread), in the same folder as these EXEs (or somewhere in the machine path) in order for these EXEs to work. One word of caution on using the machine path for this: TM1 9.1 uses some open source DLLs (libeay32.dll and ssleay32.dll) that may already exist in other locations on your machine - if another, older copy of either of these DLLs is picked up earlier in the path you may encounter errors.

Cognos UK may have been mistaken about this because their own TM1 9.1 API documentation has been incorrect in terms of changes to required API files since 9.1 was released. I'm pretty sure I reported this problem long ago, but I haven't seen a correction to the PDF yet.

Hope that helps.

Regards,

[daveed]

Mike,

Thanks for the update.

Cheers
Dave

[wtrost]

Has anyone successfully used TM1ChoreExecute with a 64-bit installation?

[BigDSter]

We've had to stop using tm1choreexecute since we moved to 9.4.1 FP1 32 bit on a 64 bit server. For some reason it was causing a server crash pretty much every time it ran. We had to move all chores back into TM1 which is a bit of a bugger.

[lotsaram]

Haven't ever tried TM1ChoreExecute.exe on x64 but have used TM1ProcessExecute.exe with no problems (and since the advent of being able to call a process from another process this is just as good.) As the exe is 32 bit you just need to make sure that there is a client install on the box and the exe is in the x86 bin directory as it needs the 32 bit DLLs.

Note I don't think anyone has as yet written any command line utilities that support CAM authentication, but unless you are using CAM then this shouldn't be an issue.

[paulfelce]

The TM1sip.dll doesn't seem to be on my installation, either the 32 bit dev, nor the 64 bit production.

[Mike Cowie]

The TM1sip.dll doesn't seem to be on my installation, either the 32 bit dev, nor the 64 bit production.

I don't think that DLL exists in the more recent TM1 versions - it must have been dropped/folded into other components and, thus, is not required anymore. I think you'll find that this is the case in TM1 9.4 and up.

General note that I'm in the process (albeit much slower than I would like because of other work getting in the way) of trying to do a newer version of the Process/Chore executables that I originally posted. Among very basic improvements/fixes, I'm planning to add support for the new Cognos TM1/Cognos Express CAM login methods. The revised version should also be capable of working with the 32 or 64-bit API, not that it matters as much for these given the point lotsaram made previously about dropping the EXE in the BIN folder of the version you want to use.

Regards,
Mike

[ParisHilton]

9.5 Also seems to need

log4cxx.dll
and
TM1ULibDll.dll

both of which are in the cognos bin

although having installed those already, the TM1ProcessExecute, keeps returning with "Unable to retrieve TM1 server handle"

[Sandhya Kumar]

Can a deactivated chore be executed through TM1ChoreExecute.exe from a batch script?

I tried deactiavting Save Data chore in 9.1 server and executed it through a batch script with TM1ChoreExecute.exe. I get the message "Save Data executed normally" in tm1server.log. However I do not see my tm1s.log saved with the current timestamp. I am confused whether it actually executed or not. Could someone help?

[Steve Rowe]

It may be that there were no changes on the server so that there is no new file if it's empty

[Sandhya Kumar]

Oh! thanks Steve

[sakkie]

General note that I'm in the process (albeit much slower than I would like because of other work getting in the way) of trying to do a newer version of the Process/Chore executables that I originally posted. Among very basic improvements/fixes, I'm planning to add support for the new Cognos TM1/Cognos Express CAM login methods. The revised version should also be capable of working with the 32 or 64-bit API, not that it matters as much for these given the point lotsaram made previously about dropping the EXE in the BIN folder of the version you want to use.

Hi Mike, have you made any progress on the process executable to work with CAM. I’m trying to build a VB.Net app using the API to execute a TM1 process. I prefer not to re-event the wheel if you have the command line exe with CAM support available.

[Mike Cowie]

Hi:

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

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

Regards,
Mike

[winoth]

Hi Mike,

We are on TM1 10.1 FP1 version and wanted to know if the existing tm1choreexecute.exe and tm1processexecute.exe utilities will still work on this version. And, what are the library files required to be present in the directory from where we trigger the execution of these exe's? Appreciate your help!

Thanks,
winoth