Can't call an exe File over TI Process

Post Reply
Christian Koenig
Posts: 6
Joined: Fri Mar 09, 2012 10:15 am
OLAP Product: TM1
Version: all
Excel Version: all

Can't call an exe File over TI Process

Post by Christian Koenig »

Dear all,
I hope that someone her can help me. Follwoing PRoblem i have. I want to start an .exe File over TurboINtegrator Process. I use following Syntax for it.
ExecuteCommand('C:\Programme\MDRApps\SMTPSEND\smtpsend.exe', 0);
If I run this Process i get the answer "Proccess completed successfully" but nothing happens.?

The next thing is, if i find a way to start the smtpsend.ece file i want to attach the right error . Here i complete sample i found in internet based on another .exe File

ExecuteCommand('"C:\Program Files (x86)\Serwise AG\Notification Message_v2.1.4\SendNotificationMessage.exe" -lld "D:\TM1 Log\Development 1" -c "Error in server development 2 process ' | prc | '" -m "Error in process ' | name | ' !" -p1 ' | NumberToString(ret), 1);

In final in

My Process is now as follow:
################################################# (modified by KOC, activated by KOC)
#*** Load_DIM_All_3_0_C_FAP_Attributes
#*** Jump to Process DIM_All_3_0_C_FAP_Attributes

prc = 'Load_DIM_All_3_0_C_FAP_Attributes';
name = 'Load_DIM_All_3_0_C_FAP_Attributes';
ret = ExecuteProcess(prc, 'pCube', vBasisCube);

# if(ret <> ProcessExitNormal());
# ExecuteCommand('"C:\Program Files (x86)\Serwise AG\Notification Message_v2.1.4\SendNotificationMessage.exe" -lld "D:\TM1 Log\Development 1" -c "Error in server development 2 process ' | prc | '" -m "Error in process ' | name | ' !" -p1 ' | NumberToString(ret), 1);
# endif;


Hope for help and many thanks in advanced

Chris
John Hammond
Community Contributor
Posts: 300
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: Can't call an exe File over TI Process

Post by John Hammond »

think you have to use cmd and then the string you want processed

An alternative is to write the commands to a .bat file and run that with executecommand
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Can't call an exe File over TI Process

Post by qml »

Christian Koenig wrote:If I run this Process i get the answer "Proccess completed successfully" but nothing happens.?
And what exactly is it that you would expect to happen? Is this program not expecting any parameters? Is it meant to produce some result? In any way you will not see any window popping up, because this program runs using the service account under which the TM1 server is running, not your account.

My guess the program is found and executed ok, then it either hangs there waiting for input or terminates due to lack thereof.
Kamil Arendt
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Can't call an exe File over TI Process

Post by Steve Vincent »

your syntax for running a program in the TI is fine, but what qml has said is where you need to concentrate. am i correct that program sends email? if so it most certainly will need parameters of some sort. you have to imagine you are running it as the server account, easiest way to do that (if you can) is log in to the server as that account and use the cmd box to understand what code you need to get it doing what you want. once you are sure that is correct it should be easy to transfer that to the TI.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
Christian Koenig
Posts: 6
Joined: Fri Mar 09, 2012 10:15 am
OLAP Product: TM1
Version: all
Excel Version: all

Re: Can't call an exe File over TI Process

Post by Christian Koenig »

thanks and i will chekc the posts from you soon
Chris
Post Reply