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
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