Page 1 of 1

Error handling.

Posted: Mon Sep 12, 2011 12:25 am
by ryan
Is there any way or functions available for error handling in TM1's TI process?

If errcode = 3604 then
...
else
.....
endif;

Thanks in advance.

Re: Error handling.

Posted: Mon Sep 12, 2011 1:05 am
by Alan Kirk
ryan wrote:Is there any way or functions available for error handling in TM1's TI process?

If errcode = 3604 then
...
else
.....
endif;

Thanks in advance.
You wish. As, indeed, do most of us.

The closest you can get to that is to write some code to ensure that you check your variables for valid input. (Non-empty, beyond a certain length, translates to a non-zero numeric value, or what have you.) If you find something invalid, use a standard If block to handle the exception. (Do an ItemSkip or ItemReject, write to a log file, use a default or whatever.) Otherwise the only "error handling" that you have is what TI will do for you, which is up to and including tossing out the row as a result of (say) a key error.