I need to call a stored procedure that takes a lot to complete (around 6min) and it does not return anything. It could be called in a async way that it would not matter.
Having said that, can I just use the timeout field to give it a short value (one second) being sure that in the DB, the SP will complete even if my Process model completes?Cheers
Discussion posts and replies are publicly visible
Hi Joaor,
I suggest you the following:
1) If the SP needs less than 1 hour, call the SP in a subprocess in async way (please set timeout parameter and ask to increment it to the support team if it is needed)
Start Process Smart Service - Appian 25.4
Execute Stored Procedure Smart Service - Appian 25.4
2) If the SP takes more than 1 hour use DB event (no trigger) to trigger it in async way. Events Overview | Server | MariaDB Documentation