executeprocess error

Post Reply
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

executeprocess error

Post by dharav »

Hello All

Here is my TI process to execute 4 different process through execute process function. I have mention my Process for your consideration. I am getting following error while i am trying to save this process

"Syntax error on or before:
[pversion,vVersion
Invalid String Expression"


Could you please let me know the reason behind the error or How would i rectify my error?

Code: Select all

vVersion='Actual';
vCube='Input';
vYrEndVersion='Prior Actual';



pProsave = TRIM('SaveDataAll');
pPro1 = TRIM('YearEnd Version Source View Create - 1');
pPro2 = TRIM('YearEnd Source to Destination Version RollOver -2');
pPro3 = TRIM('YearEnd Version Source View Delete  - 3');
pPro4 = TRIM('Year End Version ZeroOut - 4');

ExecuteProcess(pPro1, [pVersion, vVersion, pCube, vCube]); ## this is the error line [pVersion,vVersion invalid string expression

rValue=ExecuteProcess(pPro1, [pVersion, vVersion, pCube, vCube]);

	IF(rValue=processexitnormal()); 
		Executeprocess(pPro2);
	Else;
		ProcessQuit;
	Endif;

rValue2=ExecuteProcess(pPro2, [pYrEndVersion, vYrEndVersion, pCube, vCube]);

	IF((rValue=processexitnormal()) & (rValue2=processexitnormal())); 
		Executeprocess(pProsave);

	Else;
		Processquit;
	Endif;

rValue3=ExecuteProcess(pPro3, [ pCube, vCube]);

	IF((rValue=processexitnormal()) & (rValue2=processexitnormal()) & (rValue3=processexitnormal())); 
		Executeprocess(pProsave);

	Else;
		Processquit;
	Endif;

rValue4=ExecuteProcess(pPro4, [pCube, vCube,pVersion,vVersion]);

	IF((rValue=processexitnormal()) & (rValue2=processexitnormal()) & (rValue3=processexitnormal() & (rValue4=processexitnormal())); 
		Executeprocess(pProsave);

	Else;
		Processquit;
	Endif;

Thanks

Dharav
User avatar
Steve Rowe
Site Admin
Posts: 2464
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: executeprocess error

Post by Steve Rowe »

Your syntax is wrong..
the call is TIName, 'ParameterName', VariableContainingParameterValue, etc
Technical Director
www.infocat.co.uk
dharav
Regular Participant
Posts: 193
Joined: Wed Apr 02, 2014 6:43 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: executeprocess error

Post by dharav »

Steve

Thanks. Got it.
Post Reply