on 01-28-2009 2:28 PM
Hi,
I am looking to incorporate an error handling strategy using the try/catch blocks. Within my catch block i have a defined a workflow which calls another data flow. This data flow will write data to an error table, including the exception that was encountered.
Would you happen to know how is the exception being captured and how can I write it to the dataflow input?
I appreciate your help.
Thanks
Azeem
The dataflow is quite simple, a Row_Gen -> Query_with_mapping -> ErrorTable
So you generate one row as you want to insert one row into the target and in the mapping you specify the column values, e.g. sysdate(), your variable holding the error message etc.
However, you are replicating things that are done automatically already. Check the AL_HISTORY repo table, ALVW_FLOW_STAT and other views. Hopefully you are happy with the runtime information found there.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.