I am trying to Execute a SP from Query database Smart Service in Process model and getting a Timeout Error.I wish to Handle the Process flow and not let the Process stop immediately and continue the Exception path.
Note : i cannot use Execute Store Procedure Smart Service as my SP is taking longer than 10 min.
Discussion posts and replies are publicly visible
Please use proper indices it will optimize the SP, it will enhance the execution time and If you are not willing to optimize the performance of SP then kindly ask the Appian Admin to increase the node execution time.
Last option is to split the SP in multiple sub queries.
1. Set "Pause Node On Error" to false and capture it into PV.
2. The smart service returns error in the Data Output in "Error Occurred" and "Error Text" activity parameters.
3. Have the XOR gateway next to the smart service and define the flow for error case.