Hi all,
We have an execute command in the prolog section of a TI process which kicks off a batch file. This has been working fine but today the process is aborting and we are getting the following error: Error: Prolog procedure line (6): %1 is not a valid Win32 application. We have checked to ensure that the account that the service is using has the correct admin rights on the server to run the process. We are able to run other batch files in the same way but the batch file in question kicks off a php script to access data over a SOAP connection. This been working fine for the last 6 months but we are getting this error today.
Any suggestions as to fix this would be much appreciated.
TIA,
C.
Ti process error when running batch file
-
- Community Contributor
- Posts: 217
- Joined: Thu Aug 15, 2013 9:05 am
- OLAP Product: TM1
- Version: 10.2.1.1
- Excel Version: 14.0.6129.5000
Re: Ti process error when running batch file
Hi,
try running the batch or command (or both) separately from the TI, via the command line. Also try running it as the user the TM1 service is using, see what results you get.
Trevor.
try running the batch or command (or both) separately from the TI, via the command line. Also try running it as the user the TM1 service is using, see what results you get.
Trevor.
-
- Posts: 2
- Joined: Wed Mar 30, 2016 8:44 am
- OLAP Product: tm1
- Version: 10.2.2
- Excel Version: 2013
Re: Ti process error when running batch file
Hi,
Thanks for quick reply and the pointers , we tried them all and they worked, it came down to this.
By changing the batch file path to one having no spaces in the folder path, the TI process did then execute correctly
What is strange is that this error occurred only now, considering the path with a space has executed several time previously with no errors.
Must bookmark a quick guide on white spacing in process scripts for TI ?
Best,
C.
Thanks for quick reply and the pointers , we tried them all and they worked, it came down to this.
By changing the batch file path to one having no spaces in the folder path, the TI process did then execute correctly
What is strange is that this error occurred only now, considering the path with a space has executed several time previously with no errors.
Must bookmark a quick guide on white spacing in process scripts for TI ?
Best,
C.
-
- Community Contributor
- Posts: 217
- Joined: Thu Aug 15, 2013 9:05 am
- OLAP Product: TM1
- Version: 10.2.1.1
- Excel Version: 14.0.6129.5000
Re: Ti process error when running batch file
A TI cares not for white space, as long as the statements are terminated by a semi-colon. It is windows that does not like the space character, when you want to move a file via batch for example, you have to put quotation marks around the path of the file, if the path has spaces, example: "c:\Program files\ibm"cognosey wrote:Hi,
Thanks for quick reply and the pointers , we tried them all and they worked, it came down to this.
By changing the batch file path to one having no spaces in the folder path, the TI process did then execute correctly
What is strange is that this error occurred only now, considering the path with a space has executed several time previously with no errors.
Must bookmark a quick guide on white spacing in process scripts for TI ?
Best,
C.
The above code line needs quote mark due to the space in the program files part of the path.
It is strange that it only started to fail you now, but maybe there was a change unbeknownst to you.
Trevor.