RunTI.exe Serverconnectionfailed

Post Reply
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

RunTI.exe Serverconnectionfailed

Post by Darkhorse »

Hi all

is anyone able to help me with my RunTI.exe, never used it before but thought i would expand my horizons :D

heres my Batch file

"E:\Program Files\ibm\cognos\tm1_64\bin64\tm1runti.exe" -process "TestTi"-adminhost "localhost" -server "BasicSetup" -user "Admin" -pwd "Apple"
pause

It keeps telling me server connection failed. can some one please point out where i'm going wrong,

thanks
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: RunTI.exe Serverconnectionfailed

Post by gtonkin »

Looks about right - there may be a missing space before the -adminhost. I have also had mixed experience with quote usage try removing where you do not have spaces in the parameters .
e.g. "E:\Program Files\ibm\cognos\tm1_64\bin64\TM1RunTI.exe" -adminhost localhost -server BasicSetup -process TestTI -user admin -password apple
(not sure about the case of your password which may also be an issue)
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: RunTI.exe Serverconnectionfailed

Post by Edward Stuart »

Have you tried putting the server name instead of localhost?
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: RunTI.exe Serverconnectionfailed

Post by Darkhorse »

Thanks for the above guys, I tried all the above still the same thing, Do i need to check my firewall settings?
User avatar
Ajay
Regular Participant
Posts: 183
Joined: Wed May 14, 2008 8:27 am
OLAP Product: TM1
Version: 10.2.0, PA 2.0.9
Excel Version: 2016
Location: London

Re: RunTI.exe Serverconnectionfailed

Post by Ajay »

Hi Darkhorse

You may need to explicity tell the command to use tm1runti, I know I had too.

Also, I think the "localhost" and "Admin", in your post, do not need to be inside quotation marks - I didn't need them in mine. I'm not sure about the password as I am using the encrypted password keys.

Mine looks like this:

"my_path\tm1runti.exe" tm1runti -process "My Process" -adminhost localhost -server "The_TM1_Instance" -user MyAdminUserName -passwordfile "My_Path\TM1RunTI\KeyStore\tm1prod_cipher.dat" -passwordkeyfile "My_Path\TM1RunTI\KeyStore\tm1prod_key.dat"

The username that I am using is not just the standard Cognos administrator, ADMIN. It is another account which also has administrator access on the physical server. I remember getting connection issues when I first set up TM1RunTI as that username wasn't in the administrator group.

Not sure if this helps, but some pointers that I found out when setting it up myself......it did take a few goes !

Ajay
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: RunTI.exe Serverconnectionfailed

Post by Darkhorse »

hi thanks for the assist bud, still no joy.

i read that the location of a tm1 installation can attribute to this issue,

my tm1 installation is n d:, my instance is in a seperate folder on d:

current bat:

"e:\Program Files\ibm\cognos\tm1_64\bin64\tm1runti.exe" tm1runti -process "Save Data All" -adminhost localhost -server "BasicSetup" -user admin -pwd apple
pause
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: RunTI.exe Serverconnectionfailed

Post by gtonkin »

If your installation is on D: why is your batch pointing to E:?
You also seem to have introduced another tm1runti after the first.
Review/update and try again.
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: RunTI.exe Serverconnectionfailed

Post by Darkhorse »

apologies i meant the install was on E:, i added the runti second part due to a previous post
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: RunTI.exe Serverconnectionfailed

Post by Edward Stuart »

Does tm1runti work when using the command line and not the batch file?
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: RunTI.exe Serverconnectionfailed

Post by Darkhorse »

no it still says Sever connection failed
User avatar
gtonkin
MVP
Posts: 1199
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: RunTI.exe Serverconnectionfailed

Post by gtonkin »

Have you tried some of the suggestions elsewhere on this forum regarding certificates i.e. have you confirmed that ALL certificates are in place and updated?
Does Architect work as expected when running on the server directly?
Is your TM1S.CFG configured to allow mixed mode or TM1 native authentication?
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Re: RunTI.exe Serverconnectionfailed

Post by Darkhorse »

My Version of TM1 is fully updated to patch 6 and the interim, SSL is fine and my Server shows perfectly in architect.
Drg
Regular Participant
Posts: 159
Joined: Fri Aug 12, 2016 10:02 am
OLAP Product: tm1
Version: 10.2.0 - 10.3.0
Excel Version: 2010

Re: RunTI.exe Serverconnectionfailed

Post by Drg »

try "apple" in pwd parms and try copy paste use architect to connect to server ans do not use localhost use short(wide) domain name or ip
Post Reply