TM1RunTI Won't Work or Return Error

Post Reply
User avatar
ptownbro
Posts: 31
Joined: Wed Apr 05, 2017 3:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013
Location: Los Angeles, CA

TM1RunTI Won't Work or Return Error

Post by ptownbro » Sat Mar 10, 2018 6:11 am

Just getting started on trying TM1RunTI. I've read the documentation and reviewed a few forum posts, but cannot get it to work. When I run it from a command prompt, I don't get an error or success message. Instead it just returns what appears to be help information.

Here's what I entered at the command prompt:

Code: Select all

c:\program files\ibm\cognos\tm1_64\bin64>tm1runti -i "c:\username\documents\MyTM1RunTI.ini"
Here's what is contained in the "MyTM1RunTI.ini" configuration file

Code: Select all

[TM1RunTI]
process="Build Dimension"
connect=Development

[Process - Build Dimension]
pDimName="MyDimension"

[Connect – Development]
adminhost="servername.sub.mydomain.com"
server="MyTM1ServerInstance"
user="admin"
pwd="apple"
Here's what it returned:

Code: Select all

tm1runti -?
  or tm1runti -help
  or tm1runt1 [<cmd_parm>...] [<ti_parm>...]

     where <cmd_parm> is one of:
          -i <filespec>
          -process <string>
          -chore <string>
          -connect <string>
          <connect_parm>...

     where <ti_parm> is:
          <parm_name> '=' <parm_value>

     where <connect_parm> is one of:
          -adminhost <string>
          -server <string>
          -user <string>
          -securitymode
          -retryattempts
          -retryinterval
          <password_parm>
          -AdminSvrSSLCertAuthority <filespec>
          -AdminSvrSSLCertID <id>
          -AdminSvrSSLCertRevList <filespec>
          -AdminSvrSSLExportKeyId <id>
          -ExportAdminSvrSSLCert <T|F>
          -CAMNamespace <string>

     where <password_parm> is one of:
          -pwd <string>
          -passwordfile <filespec> -passwordkeyfile <filespec>PA

Wim Gielis
MVP
Posts: 1691
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: TM1RunTI Won't Work or Return Error

Post by Wim Gielis » Sat Mar 10, 2018 4:41 pm

Hello

Could it be the > in front of tm1runti ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

User avatar
gtonkin
MVP
Posts: 593
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: TM1RunTI Won't Work or Return Error

Post by gtonkin » Sat Mar 10, 2018 5:47 pm

May be that your ini file is located in your user folder, to which the server has no access-try move it to a folder that the user who started the TM1 service has access to.

User avatar
ptownbro
Posts: 31
Joined: Wed Apr 05, 2017 3:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013
Location: Los Angeles, CA

Re: TM1RunTI Won't Work or Return Error

Post by ptownbro » Sun Mar 11, 2018 12:21 am

The ">" in front of "tm1runti" is part of the command prompt and was not added by me.

I will try placing the file in another location and report back.

User avatar
ptownbro
Posts: 31
Joined: Wed Apr 05, 2017 3:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013
Location: Los Angeles, CA

Re: TM1RunTI Won't Work or Return Error

Post by ptownbro » Sun Mar 11, 2018 1:35 am

Placing my configuration file in a location where the service has rights to didn't work. At least I don't think it did.

I placed the file in two places under the folder where my TM1 server instance resides. That folder looks like this

D:\TM1\MyTM1ServerInstance
D:\TM1\MyTM1ServerInstance\apps
D:\TM1\MyTM1ServerInstance\data
D:\TM1\MyTM1ServerInstance\logs
D:\TM1\MyTM1ServerInstance\tools

The service that is running that points to that instance has the following "Name" and "Log On As" values:

Name: IBM Cognos TM1 Server - MyTM1ServerInstance
Log On As: Local System

I placed the file under both the "tools" and "data" folder and got the same results.

I assume "Local System" has access to at least the data folder when running the service since that is where all the TM1 data resides.

User avatar
ptownbro
Posts: 31
Joined: Wed Apr 05, 2017 3:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013
Location: Los Angeles, CA

Re: TM1RunTI Won't Work or Return Error

Post by ptownbro » Sun Mar 11, 2018 3:45 am

Geesh.

I figured it out. I was using an unassuming invalid character in my configuration file

In my configuration file below, the "-" was technically the wrong ASNI character in my text. I original copied an example from the user guide and edited it in my file. When I did that it must have used the wrong character for "-".

Code: Select all

[TM1RunTI]
process="Build Dimension"
connect=Development

[Process - Build Dimension]
pDimName="MyDimension"

[Connect – Development]
adminhost="servername.sub.mydomain.com"
server="MyTM1ServerInstance"
user="admin"
pwd="apple"
Last edited by ptownbro on Sun Mar 11, 2018 5:54 pm, edited 1 time in total.

Wim Gielis
MVP
Posts: 1691
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: TM1RunTI Won't Work or Return Error

Post by Wim Gielis » Sun Mar 11, 2018 7:15 am

Thanks for the update.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Post Reply