Data Movement Between TM1 instances on Workflow Action

Post Reply
pmathur
Posts: 23
Joined: Fri Aug 19, 2011 6:40 am
OLAP Product: TM1
Version: 10.1
Excel Version: 14.0.4760.1000

Data Movement Between TM1 instances on Workflow Action

Post by pmathur »

Hello Everyone, we came across a scenario where on the final submission of the root node in a approval application we need to trigger a data transfer from server A to server B. To accomplish this we have plugged a TI process on Submit action of the approval application on server A for each node. And we monitor that if the current node is root node using pNodeId parameter. If the current node is root node then our process on server A will try to connect to server B using TM1RUNTI utility via "ExecuteCommand" as shown below. Now the problem is, the process on server B is never called using this method. Or in other words it appears that it fails in connecting to server B

We are running TM1 10.2.2 and our admin servers are on RedHat OS. Any suggestion what we are missing syntactically or are there any restriction on using TM1RUNTI on Linux box?

Thanks !!!

Code: Select all

vStr = 'tm1runti -adminhost xyz.myhost.com -server "Server B" -user "abc" -pwd "xyz" -CAMNamespace "MyDomain" -process "Get Transfer Node Status"';
ExecuteCommand(vStr,1);
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Data Movement Between TM1 instances on Workflow Action

Post by tomok »

Skipping all the fancy stuff you have done as far as tying it to a submission process, have you tested to see if you can run TM1RUNTI from your server by just opening a command window and pasting the string you have created in there and hitting enter. I've never tried to run a Windows executable program on Linux so I can't speak to whether it's possible or not. If you can't run it from a command window on the TM1 server then you are surely not going to be able to run it via a TI.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
pmathur
Posts: 23
Joined: Fri Aug 19, 2011 6:40 am
OLAP Product: TM1
Version: 10.1
Excel Version: 14.0.4760.1000

Re: Data Movement Between TM1 instances on Workflow Action

Post by pmathur »

Thanks Tom, for the suggestion.

Somehow we have missed to add the TM1 <install directory>/bin64 path to the LD_LIBRARY_PATH environment variable on our Unix server as suggested by IBM.
http://www-01.ibm.com/support/docview.w ... wg27023958

After updating the path variable it works like a charm. Thanks again.
BrianL
MVP
Posts: 264
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: Data Movement Between TM1 instances on Workflow Action

Post by BrianL »

tomok wrote:I've never tried to run a Windows executable program on Linux so I can't speak to whether it's possible or not.
Just FYI - IBM does in fact include a binary called tm1runti.exe in the installer for all platforms. While it does break convention on *NIX platforms to use file extensions, it doesn't break anything and adds no meaning.
pmathur
Posts: 23
Joined: Fri Aug 19, 2011 6:40 am
OLAP Product: TM1
Version: 10.1
Excel Version: 14.0.4760.1000

Re: Data Movement Between TM1 instances on Workflow Action

Post by pmathur »

Thank Brain, for this information.
Post Reply