I am running a RPA that opens a SQL connection and runs a SQL statement (based on two parameters that are already in an excel file), and then it writes the results on a specific excel column. My problem is that Im not going to be the person that fills the two parameters in the excel file, and I was trying to see what errors the RPA would return if one of these parameters were wrong. I was trying to use the "On Error" action, to go to the next action that is a "Increase a variable" if an error happens.
I changed the two parameters to something the SQL statement would never find in the database, and modify the action to "write to excel" to "On Error" to to next action, but the RPA still stops the flow because of this error:
This is my flow:
Write to Excel:
On error:
Query Result (After the SQL statement):
I want that if there is this error to go to the next action and continue with the flow.

Report
All responses (
Answers (