Runtime Error/Exception handling while executing workflow

mutchakala

Hi,

I have a requirement to handle run time errors. My workflow is doing data blend and prep using a scheduled job. For each input record, data processing is done and final output is pushed to data mart. My question is while processing or populating data to fact table, if exception occurs, I'd require to update control table with failure of the failed record and continue workflow for rest of the records that means status can be either "SUCCESS" or "FAILURE".

Any ideas will be appreciated. Really I have tough time with Alteryx designer to handle this kind of error handling scenarios.

If I use "Cancel Running workflow on error" , the workflow execution gets terminated, which I means I can't do further execution to change the status to "FAILURE"

Thanks,

Hari

DanM

@aahuja1 and @mutchakala,

If a record fails in Alteryx, the Alteryx engine automatically stops and will not continue the run. This is there for data quality and assurance.

You may need to set your workflows up in a different way to create tests with the tools instead of attempting to use the Alteryx engine to do the test for you.

We also suggest creating workflows that can handle many situations and can be dynamic enough that engine fails do not happen. If you are attempting to do a pass fail and split the data, you will want to create that test in Alteryx using something like a filter tool or maybe even a join tool. Even the Detour tools can be use to push data in different directions instead of having the workflow fail. You can then use the data to identify pass or fail and do what you will with each. 

DanM