Is it possible to direct flow from Write to DSE Smart Service on error?
Ideal scenario would have the DSE node fail, and based on error, flow would continue to different node.
Right now process pauses when DSE fails and email goes out. Is it possible to continue process flow on DSE fail?
Discussion posts and replies are publicly visible
No. The DSE node does not support this. With 22.3 the new Write Records node allows you do disable the default error behaviour and allows you to design a different path in case of errors.
May I ask what you would want to do in case of an error? I almost never wanted to deviate from the default in the past.
In case of error (specifically a duplicate entry error), we would like to end the process. We can not check before the DSE node for duplicates because the node itself is the race condition. It is possible multiple processes would be started with duplicate data, in which case, first process to reach DSE would pass, all others would fail with duplicate errors.
Got it. If this is a new application I suggest to go with the records approach. Else a stored procedure to insert the data might be an option. It could catch the error and return an error state for you to know whether it could insert the data or not.
In write to data store entity smart service (in process model), only output is "stored values", I want to retry 3 times if the write to data store entity fails, how can I determine failure in this case?
The basic idea is that if a write fails, only a sys admin can analyze and resolve the root cause, and then trigger the node a second time.
This has changed a bit with write records, as it allows you to handle a failed write.