We’ve got a FB project with one of the steps executing a SQL script. Inside the script, it’s wrapped in a transaction, so that if any part of the script errors it logs the error(s) and executes an if-failed statement instead of committing the transaction. This works fine when running the script in SQL Management Studio.
However, when we run the script using the Execute SQL action in FinalBuilder, if the script errors inside the transaction, it does not complete running the script. The error immediately fails the action and bombs out. Is there a way to execute the script as intended without the action breaking?