TM1 Forum

Posted: **Wed Aug 08, 2012 9:41 am**

Hello all experts,

I have got a problem with TM1RunTI in my current project! We need to copy data from one TM1 Server into another TM1 Server. The user needs to press an action button in Perspectives/TM1 Web and all processes have to be executed.

I defined the following processes:
TM1 Server A: Process1 (writes data into CSV)
TM1 Server B: Process2 (reads the CSV and imports the data).
So far, so good. These processes are working fine!

Now I need to create another Process:
TM1 Server B: Process3 (Start Process1 and Start Process2)

This process looks like this:

Code: Select all

#Prolog
vExec = "tm1runti –i '\\path to config file\config.config' -connect NameofAdminHost -process Process1";
ExecuteCommand(vExec, 1);
ExecuteProcess(‘Process2');

The config File looks like this:

Code: Select all

[TM1RunTI]
process=Process1
connect= NameofAdminHost

[Connect – NameofAdminHost]
adminhost= AdminHostXY
server=TM1 ServerA
user="admin"
pwd ="password"
AdminSvrSSLCertAuthority=.\ssl\applixca.pem

When saving this TI process, I get the following error:
Syntax Error on or before “tm1runti –I ‘\\..... invalid expression.

Can you tell me what is wrong with my TI Process or with the config file?
Are there any other ways than using TM1RunTI to copy data between different TM1 Servers (Replicating the source cube is not an option)?

Thanks in advance

Posted: **Wed Aug 08, 2012 9:46 am**

Code: Select all

#Prolog
vExec = "tm1runti –i '\\path to config file\config.config' -connect NameofAdminHost -process Process1";

Syntax Error on or before “tm1runti –I ‘\\..... invalid expression.

You have to use single quotes, not double quotes, when creating a command string (or indeed any string) in TI.

Posted: **Wed Aug 08, 2012 12:56 pm**

Thanks a lot Alan. That was the error. By the way, in the section where you write the path to the config file, there should be no quotes at all!

Now, the process is executing and it shows no error ("Process executed successfully"). However, the Process1 (the one I call via TM1RunTI) does not write any data into the CSV file (even though there is data). The process works fine, when executed normally! It must be the TM1RunTI command that is not starting the process. Any idea where the problem could be?

Thanks.

Posted: **Wed Aug 08, 2012 1:19 pm**

Stephan1981 wrote:Thanks a lot Alan. That was the error. By the way, in the section where you write the path to the config file, there should be no quotes at all!

Now, the process is executing and it shows no error ("Process executed successfully"). However, the Process1 (the one I call via TM1RunTI) does not write any data into the CSV file (even though there is data). The process works fine, when executed normally! It must be the TM1RunTI command that is not starting the process. Any idea where the problem could be?

Thanks.

First step would be to check the log files to see whether the process is running or not.

I have however had issues both with initiating batch files from TM1 and with initiating TI from batch files when the UAT settings aren't disabled on the server so it could be worth having a look at that?

Posted: **Wed Aug 08, 2012 2:10 pm**

There are only logs in TM1 Server B. They say, that the Process2 wasexecuted normally in 0.01 sec and the Process3 in 1.79 sec. There is no mentioning of Process1. The logs on TM1 Server A are empty.

8008 [169] INFO 2012-08-08 15:44:33.043 TM1.Process Process "Process3" executed by user "XXX"
8008 [169] INFO 2012-08-08 15:44:34.815 TM1.Process Process "Process2" run from process "Process3" by user "XXX"
8008 [169] INFO 2012-08-08 15:44:34.829 TM1.Process Process "Process2": finished executing normally, elapsed time 0.01 seconds
8008 [169] INFO 2012-08-08 15:44:34.830 TM1.Process Process "Process2": finished executing normally, elapsed time 1.79 seconds

Posted: **Wed Aug 08, 2012 3:22 pm**

Try just running TM1RunTI.exe from the Command Prompt using the parameters you have specified and see if it runs there.

Posted: **Wed Aug 08, 2012 3:26 pm**

I did some testing now and i created a .bat file with the following content:

\\path\Cognos_TM1\bin\tm1runti -adminhost HostName –server NameofServer –user XXX –pwd "XXX" -process Process1

When running the batch file from my client computer I get the error message "tm1runti is not a valid win32-application"

After that, I connected to the TM1 Server Host via RDP and opened the Command Line. Here, I changed to the Cognos_TM1\bin folder and entered the following command:

tm1runti -adminhost HostName –server NameofServer –user XXX –pwd "XXX" -process Process1

The error message was:
(TM1 API Error) SystemServerNotFound
ServerConnectionFailed

When entering tmirunti -? the help appears, so I guess that TM1RunTI is working properly.

Posted: **Thu Aug 09, 2012 3:54 pm**

My own testing suggests the config file functionality, as documented, doesn't work. Can anybody share a working (sanitised) config?
Encryption seems fine though.

TM1 Forum

TM1RunTI - Copy data between different TM1 Servers

TM1RunTI - Copy data between different TM1 Servers

Re: TM1RunTI - Copy data between different TM1 Servers

Re: TM1RunTI - Copy data between different TM1 Servers

Re: TM1RunTI - Copy data between different TM1 Servers

Re: TM1RunTI - Copy data between different TM1 Servers

Re: TM1RunTI - Copy data between different TM1 Servers

Re: TM1RunTI - Copy data between different TM1 Servers

Re: TM1RunTI - Copy data between different TM1 Servers