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