Getting TI returnvalue

[jviegas@bi4all.pt]

Hello,

It maybe a strange question but is there any possibility of getting the return value from a TI process without executing it through executeprocess (in another TI process).

I would like to get the returnvalue (regarding the execute status) and get this information as a parameter to another TI process (in the prolog).

At the moment I'm able to get this using another TI process and the executeprocess command.

Thank you for the time and help,

Jorge

[ioscat]

http://www.tm1forum.com/viewtopic.php?f=3&t=8277
http://blog.flowolap.com/post/2012/11/2 ... esses.aspx

[jviegas@bi4all.pt]

http://www.tm1forum.com/viewtopic.php?f=3&t=8277
http://blog.flowolap.com/post/2012/11/2 ... esses.aspx

Iocat,

I can assume that I must have always a "caller process" to obtain the returnvalue of the target TI process.

I was wondering if I could get the returnvalue at the end of the process to pass it to a global variable.

[ioscat]

you can store a value in cube with just 1 cell.

[Harvey]

Jorge, there is always some calling process. Do you mean calling a process via the TM1 API?

[lotsaram]

Jorge, there is always some calling process. Do you mean calling a process via the TM1 API?

I think he means is it possible to query the last return state of a process regardless of when it was last executed and how it was executed. Others have asked this in the past too and the answer is of course NO, you have to declare a variable and set it equal to the process execute function.

[jviegas@bi4all.pt]

Jorge, there is always some calling process. Do you mean calling a process via the TM1 API?

I think he means is it possible to query the last return state of a process regardless of when it was last executed and how it was executed. Others have asked this in the past too and the answer is of course NO, you have to declare a variable and set it equal to the process execute function.

Thank you.

I was thinking to same but wanted to be sure and avoid missing a solution.

Thanks again for the feedbacks and the help on this issue.

[rmackenzie]

I can assume that I must have always a "caller process" to obtain the returnvalue of the target TI process.

As the others have commented, your assumption is correct.

I was wondering if I could get the returnvalue at the end of the process to pass it to a global variable.

This however, is slightly different and somewhat possible. Although the return value is not available until the process has completed, it is possible within the Epilog to count the errors that occurred in the execution of the 3 preceding code tabs i.e. Prolog, Metadata, Data. Although you don't get the full range of information associated with the return code, you do get a basic test of whether the process ran without error versus ran with some minor errors.

TI exposes 3 variables for this purpose - the doco calls them global variables that can be used within a chore presumably to get a running count of total errors throughout the chore. However, you can also use them in a single process:

In the prolog, you declare them:

Code: Select all

NumericGlobalVariable ( 'DataMinorErrorCount' );
NumericGlobalVariable ( 'MetadataMinorErrorCount' );
NumericGlobalVariable ( 'PrologMinorErrorCount' );

And in the Epilog, you can do this:

Code: Select all

nTotalProcessErrors = DataMinorErrorCount + MetadataMinorErrorCount + PrologMinorErrorCount;
IF ( nTotalProcessErrors > 0 );
   # take action here like setting a flag in a cube, sending an e-mail, etc
END IF;