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
Can't call an exe File over TI Process
-
- Posts: 6
- Joined: Fri Mar 09, 2012 10:15 am
- OLAP Product: TM1
- Version: all
- Excel Version: all
-
- 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
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
An alternative is to write the commands to a .bat file and run that with executecommand
- 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
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.Christian Koenig wrote:If I run this Process i get the answer "Proccess completed successfully" but nothing happens.?
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
- 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
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
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
-
- 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
thanks and i will chekc the posts from you soon
Chris
Chris