Hello All,
Can you please let me know the default execution time limit of 'Execute Stored Procedure' node?
I am getting below error after 5minutes of execution. It seems that it gets timed out after 5 minutes, so need to check the time limit and need to increase the same in case required.
"There is a problem with task “<TASK_NAME>” in the process “<PROCESS_NAME>”. java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation ORA-06512: at "APPIANDB2.CSV", line 149 ORA-06512: at "APPIANDB2.CSV", line 30 ORA-06512: at "APPIANDB2.PROCEDURE_NAME", line 52 ORA-06512: at line 1 "
Thanks in advance
Kaushik
Discussion posts and replies are publicly visible
Hi kaushikr276
It usually depends on how it is configured in your server.
But I would suggest to optimise your query to get better results. Also, you can have a look at the best practices
https://community.appian.com/w/the-appian-playbook/197/database-performance-best-practices
5 min is a long time for a step in a workflow to wait.... Instead of changing the timeout, I would see if you can
1. Break your stored proc up into multiple procs and calls
2. Make sure you are not hitting row or table locks in the proc that is causing wait
3. tune any cursors or queries
Hope that helps
One more thing to add here is if you are on 19.1 or above appian implemented memory circuit breaker which essentially terminates any rule which uses lot of memory.
https://docs.appian.com/suite/help/19.2/Memory_Circuit_Breaker.html