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