Exception Handling

erick258 over 7 years ago

Hi, I'm making a simple process which contains of a single "User Input Task" node and a "Write to Datastore Entity" node, and when there is an error in the "Write to Datastore Entity" node, it is needed for the process to rollback to the "User Input Task" node with additional information about what the error is. Is there any way for it to be done?
Thanks.

Discussion posts and replies are publicly visible

Parents

0 Sidhant Behura over 7 years ago

@erick258 -

This requirement might not be feasible because whenever the "Write to Datastore Entity" node errors the process instance execution gets paused and there is an alert sent. And there is also no provision to access the SQL Exception at the output variable.
Due to this the exception mechanism in Appian wont work because it depends on 3 things Receive Message, Timer and Rule and we dont have enough information/data to trigger the exception flow.

But there is a way with which you can achieve your requirement but in a slightly different manner.
Put the "Write to Datastore Entity" node in a sub-process and configure a timer of 1 minute on the sub-process. In case the "Write to Datastore Entity" node inside the sub-process fails it will follow the exception flow and then you can configure another User Input Task to show an generic error like "Database Transaction failed." and then take measures to rollback.

Please refer the below link for more information.
/search?q=OriginalPostID-217893

Hope this information was helpful.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sidhant Behura over 7 years ago

@erick258 -

This requirement might not be feasible because whenever the "Write to Datastore Entity" node errors the process instance execution gets paused and there is an alert sent. And there is also no provision to access the SQL Exception at the output variable.
Due to this the exception mechanism in Appian wont work because it depends on 3 things Receive Message, Timer and Rule and we dont have enough information/data to trigger the exception flow.

But there is a way with which you can achieve your requirement but in a slightly different manner.
Put the "Write to Datastore Entity" node in a sub-process and configure a timer of 1 minute on the sub-process. In case the "Write to Datastore Entity" node inside the sub-process fails it will follow the exception flow and then you can configure another User Input Task to show an generic error like "Database Transaction failed." and then take measures to rollback.

Please refer the below link for more information.
/search?q=OriginalPostID-217893

Hope this information was helpful.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data