Skip to main content
rahuln3859
rahuln3859
February 27, 2023
Question

Error Handling when Query Database Smart Service encounters Error

  • February 27, 2023
  • 2 replies
  • 0 views

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.

2 replies

adityag9712
adityag9712
February 27, 2023

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. 

abhayd3663
abhayd3663
February 28, 2023

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.

    Terms & ConditionsAccessibility statement