Ti process error when running batch file

Post Reply
cognosey
Posts: 2
Joined: Wed Mar 30, 2016 8:44 am
OLAP Product: tm1
Version: 10.2.2
Excel Version: 2013

Ti process error when running batch file

Post by cognosey »

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.
TrevorGoss
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

Post by TrevorGoss »

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.
cognosey
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

Post by cognosey »

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.
TrevorGoss
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

Post by TrevorGoss »

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.
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"

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.
Post Reply