ExecuteProcess in prolog does not work

Post Reply
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

ExecuteProcess in prolog does not work

Post by ioscat »

Hello, Community.
Got strange behaviour. We have got process with no entry parameters that works fine (with minor errors at the end). But when we start it from another process - we got no result, no data modified.

Code: Select all

ruleloadfromfile('Budget','D:\Cognos import text files\Dummy.txt');
#****Begin: Generated Statements***
#****End: Generated Statements****

#ViewZeroOut('Budget','ZeroOut_K_version');
a=executeprocess('Cube.Data.Copy_D_to_K');
asciioutput('C:\bat\test.txt', numbertostring(a));

asciioutput('C:\bat\test.txt', 
 numbertostring(
ProcessExitByChoreQuit()),
numbertostring(
ProcessExitNormal()),
numbertostring(
ProcessExitMinorError()),
numbertostring(
ProcessExitByQuit()),
numbertostring(
ProcessExitWithMessage()),
numbertostring(
ProcessExitSeriousError()),
numbertostring(
ProcessExitOnInit()),
numbertostring(	
ProcessExitByBreak()));

Code: Select all

NVALUE = (-1)*NVALUE;

#****Begin: Generated Statements***
Version='К';
if (VALUE_IS_STRING=1, CellPutS(SVALUE,'Budget',Version,Time,ВД,ЧН,Заказчики,Тарифы,ТС,Годы,Показатели), CellPutN(NVALUE, 'Budget',Version,Time,ВД,ЧН,Заказчики,Тарифы,ТС,Годы,Показатели));
#****End: Generated Statements****
Output file:
"0"
"16","0","6","8","5","10","11","7"
User avatar
ioscat
Regular Participant
Posts: 209
Joined: Tue Jul 10, 2012 8:26 am
OLAP Product: Contributor
Version: 9.5.2 10.1.1 10.2
Excel Version: 07+10+13
Contact:

Re: ExecuteProcess in prolog does not work

Post by ioscat »

Found my error. The calling process copies data from version D to K. Before executing the process we set rule file to empty. D version is fully calculated. So there were no values.

Question closed. Thanx all!
Post Reply