Skip to main content
August 4, 2022
Question

Error Handling Write to Data Store Entity Smart Service

  • August 4, 2022
  • 7 replies
  • 0 views

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?

7 replies

stefanhelzle0001
Brainy
August 4, 2022

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.

August 4, 2022

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. 

stefanhelzle0001
Brainy
August 4, 2022

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.