Running TI Processes from Command Line: TM1RunTI.exe

[Alan Kirk]

Does anybody feel strong enough to raise an SR to find out what on earth TM1Guardian is, and why IBM haven't bothered to document it? I'm rather buried in my 400gig model at present.

Yeah, I'll do it. I actually want to find out what the intended status of the process running tool is anyway; whether it's intended to be properly supported / released and if so, when.

OK, I've raised it; S/R 14164,999,616. Essentially I asked for the whole smash:
- When is TM1RunTI.exe going to be generally released;
- Is it regarded as a final version;
- Is it supported (Norman was advised that it was, but if so... why is it being only kinda-sorta distributed in the fashion that it is?);
- Where can TM1Guardian be found, if anywhere;
- Is that going to be generally released and if so when;
- What, specifically does it do and how does it interact with the TM1RunTI.exe application. And by gee, a manual on it would be nice;
- Will that TM1Guardian be supported.

[Alan Kirk]

Does anybody feel strong enough to raise an SR to find out what on earth TM1Guardian is, and why IBM haven't bothered to document it? I'm rather buried in my 400gig model at present.

Yeah, I'll do it. I actually want to find out what the intended status of the process running tool is anyway; whether it's intended to be properly supported / released and if so, when.

Well I have answers, but frankly I'm not feeling that much more enlightened about Guardian.

- TM1RunTI.exe is intended to be released in the next 9.5.2 fix pack. This has been scheduled but the schedule may change, so I don't have a date.
- It's a finished product and supported, as Norman had been advised previously.
- TM1Guardian has not been released yet (which is why none of us can find it) but is intended for release in the same fix pack as TM1RunTI.exe.

Now, as for how it works... this was my exact question:

How does the tm1guardian.exe utility work in terms of interacting with the TM1RunTI command line utility, and by what method does it "achieve the desired results" mentioned in the document? (A manual relating to the .exe would be somewhat useful...)

And this was the exact answer:

There will be doc of course with the fix pack release, but TM1RunTI can be used in conjunction with the TM1Guardian utility to group processes and thus ensure that TurboIntegrator scripts that need to run in parallel can do so to avoid blocking and unnecessary waiting.

Which really doesn't tell us much beyond what's already in the TM1RunTI.exe document that we have.

[ub14]

Hi,

We are trying to execute TI Process with tm1runti command utiltity of 9.5.1 Hot Fix 14, with following respective parameters. its throwing below error SystemServerNotFound. Anyone having the idea about this.

tm1runti -process PROC_CTV -adminhost mylab –server mytm1server –username ***** –pwd *****

Error:
(TM1 API Error) SystemServerNotFound
Server connection failed

[Alan Kirk]

Hi,

We are trying to execute TI Process with tm1runti command utiltity of 9.5.1 Hot Fix 14, with following respective parameters. its throwing below error SystemServerNotFound. Anyone having the idea about this.

tm1runti -process PROC_CTV -adminhost mylab –server mytm1server –username ***** –pwd *****

Error:
(TM1 API Error) SystemServerNotFound
Server connection failed

I imagine that that's not the real name of your server; if so, does the real name have any spaces in it? Come to that, do any of the arguments? And if so, have you enclosed the arguments in quotes?

[AndrewCT]

Hi All,

I am fairly new to TM1 and also currently don't have the HotFix installed that includes TM1RunTI.exe.

Does TM1RunTI.exe only allow you to run processes through the command or can you use it to run a chore as well?

I'd like to be able to run multiple processes. Would it be best to create another process to mimic a chore or call TM1RunTI.exe multiple times?

For now I'm tempted to just use TIExecute.exe (http://www.tm1forum.com/viewtopic.php?f=21&t=3486) which looks like an easier / better option.

All advice appreciated.

Thanks
Andrew

[Alan Kirk]

Hi All,

I am fairly new to TM1 and also currently don't have the HotFix installed that includes TM1RunTI.exe.

Does TM1RunTI.exe only allow you to run processes through the command or can you use it to run a chore as well?

I'd like to be able to run multiple processes. Would it be best to create another process to mimic a chore or call TM1RunTI.exe multiple times?

For now I'm tempted to just use TIExecute.exe (http://www.tm1forum.com/viewtopic.php?f=21&t=3486) which looks like an easier / better option.

All advice appreciated.

You don't have to apply the hotfix to use it; just download the hotfix package and pull the executable out of there.

Distributing it with a hotfix that it bears no connection with is a thoroughly daft idea, but that's nothing new to our Big Blue friends.

As for running a chore, remember that you can also (effectively) do the same thing by calling a single process which has a series of ExecuteProcess statements in its prolog.

[ReiAsaka]

Re: Running TI Processes from Command Line: TM1RunTI.exe

Postby normanbobo » Fri Jun 10, 2011 9:23 pm
Mike ... I beat you to the suggestion to call support. It was already in the works ... and here is what I learned:

1) The utility was actually first released with 9.5.1 HF14, a "limited distribution" release. This explains why it works with 9.5.1 as well as 9.5.2.
2) The very responsive IBM support person obtained the documentation, attached at the bottom of this link. I asked for and was given permission to distribute the document.
3) Because of the unusual way in which the interface was introduced (only through hotfixes), I specifically asked whether the utility was a "supported" feature. The answer was that it is fully supported.
4) There is a very powerful command line, particularly when combined with the -i "specification" option and the ability to encrypt passwords.
5) Unfortunately, there appears to be a bug with the -i functionality. After multiple attempts with our application as well as the IBM sample applications, I continually received an error using the -i option: (TM1 API Error) "SystemServerNotFound" <newline> Server connection failed. After another support call, this error has been replicated by IBM and is currently being researched.

In the mean time, though, very nice and full implementation of a command line interface which should be extremely useful going forward.

TM1RunTI User Documentation 952HF1.pdf
TM1RunTI User Documentation.
(107.2 KiB) Downloaded 477 times

Hi guys,
does anyone know if the bug mentioned at point 5 has been solved?
I am experiencing the same issue. I have created a config file:

[TM1RunTI]
process="process_name"
connect=Test

[process - "process_name"]
param1="value1"
param2="value2"

[connect - Test]
adminhost=localhost
server=MyTm1Server
user="username"
pwd="password"
AdminSvrSSLCertAuthority=C:\Program Files\Cognos\TM1\bin\ssl\applixca.pem
AdminSvrSSLCertID=True
AdmnSvrSSLCertRevList=

I have called this file tm1tools.config

when i try to launch the tm1runti.exe, using the command line:
tm1runti.exe -i "C:\temp\tm1tools.config" a receive the error:
(TM1 API Error) "SystemServerNotFound" <newline> Server connection failed.

i can't understand what's wrong with what i've done.
Plus, if i try using the tm1runti.exe tool from command line, with the same exact parameters, everything works ok.
Is there anybody who can help me?

I am working with tm1 9.5.2 running on a Windows Server 2008 R2 Standard, Service Pack 1

Thanks

[ReiAsaka]

noone can help me?

[asutcliffe]

noone can help me?

I can't really, sorry.

However it seems likely that either a) the bug still exists or b) your config file isn't quite right. Since you seem confident that b) is not the case I'd speak to IBM support about a). Otherwise you might want to post your config file and the exact command that is working.