The correct parameter of Tm1runTI

[wang_chris]

I wish to run tm1RunTi in command line. The system always indicates that parameters input are wrong, but I have written them as doc specification, could someone check for me what's wrong for the parameters, thank you.

tm1runti -process DataTransfer_to_StaffCost –server servername –user username -pwd password pYear=FY16 pVersion=Lock2-V1 pSubBU=120 pOffice=SHA pSalaryGrade=All_Grade


DataTransfer_to_StaffCost: name of process to be run.

tm1servername, username, password : all string, no space in them.

FY16, Lock2-V1 120 SHA All_Grade : are parameters to be input to process DataTransfer_to_StaffCost in same sequence of input parameters, all are string type, no space in them.

Regards,
Chris

[declanr]

I wish to run tm1RunTi in command line. The system always indicates that parameters input are wrong, but I have written them as doc specification, could someone check for me what's wrong for the parameters, thank you.

tm1runti -process DataTransfer_to_StaffCost –server servername –user username -pwd password pYear=FY16 pVersion=Lock2-V1 pSubBU=120 pOffice=SHA pSalaryGrade=All_Grade


DataTransfer_to_StaffCost: name of process to be run.

tm1servername, username, password : all string, no space in them.

FY16, Lock2-V1 120 SHA All_Grade : are parameters to be input to process DataTransfer_to_StaffCost in same sequence of input parameters, all are string type, no space in them.

Regards,
Chris

Admin Host?

[wang_chris]

not the problem of adminhost.

even I changed the command to below, same error it reports.
change the localhost to real IP, same error.

The command is run at same server as TM1 server.

tm1runti -process DataTransfer_to_StaffCost -adminhost localhost –server servername –user uername -pwd password pYear=FY16 pVersion=Lock2-V1 pSubBU=120 pOffice=SHA pSalaryGrade=All_Grade

[declanr]

I think the order is very important with runti from memory; based on what you have put in I assume you are using standard TM1 security; in which case I have always put parameters in the order:
1/Process
2/ Process Parameters
3/ Adminhost
4/ Server
5/ UserName
6/ Password

[wang_chris]

same error if I change the command order as below.

tm1runti -process DataTransfer_to_StaffCost pYear=FY16 pVersion=Lock2-V1 pSubBU=120 pOffice=SHA pSalaryGrade=All_Grade –server tm1servername –user username -pwd password

[declanr]

same error if I change the command order as below.

tm1runti -process DataTransfer_to_StaffCost pYear=FY16 pVersion=Lock2-V1 pSubBU=120 pOffice=SHA pSalaryGrade=All_Grade –server tm1servername –user username -pwd password

Ok; what is the exact error message you get?
What exact version are you on?
What security mode are you using?

I have set up a TI called "DataTransfer_to_StaffCost" with the parameters:
pYear, pVersion, pSubBU, pOffice and pSalaryGrade.

On a security mode 1 server and passing the above line has worked without issue in a fixpacked up 10.2.2.

[wang_chris]

mine security is 1 as well. and it's a windows 2008 server.

ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
UseSSL=T

[declanr]

mine security is 1 as well. and it's a windows 2008 server.

ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
UseSSL=T

what is the exact error message you get?
What exact version are you on?

[wang_chris]

No more message.


When I run the command in dos command line, there is no message, but a list of help of tm1runti.

When I call the command in another process, it reports "Error: Prolog procedure line (37): The parameter is incorrect."



Version is TM1 10.2.2 FP2 for windows.

[failurehappening]

Whenever I use tm1runti.exe I always surround all my strings in double quotes including the username and password, the parameter names and values

Code: Select all

sQuote = Char(34);

sProcess = sQuote | ProcessName | sQuote ;
sParameters  = sQuote |ParmaterName1 | sQuote  | '=' | sQuote | ParameterValue1 |sQuote ;

Additionally the order of command I use is like this:

Code: Select all

sCommand = sRunTIPath |  ' -Process ' |   sProcess | ' -Adminhost ' | sAdminHost | ' -Server ' | sInstance | ' -CAMNamespace ' | sNameSpace |
   ' -User ' | sUser | ' -passwordfile ' | sPasswordFile | ' -passwordkeyfile ' | sPasswordKeyFile | ' ' | sParameters ;
ExecuteCommand(sCommand , 0 );

Updated after feedback saying I wasn't actually showing that I was wrapping my values in quotes... Thanks grumpy cat...