Hello All
I want call Procedure that take more than 300 seconds.
when call it using expression rule the result is (ORA-01013: user requested cancel of current operation) and maximum timeout is 300 second
how can I call this procedure?? Is there a plug-in that increases the maximum timeout?
Discussion posts and replies are publicly visible
You should be able to increase the timeout by simply providing a value to the function or Smart Service though the maximum timeout seems to be limited to 600 seconds for the Smart Service.
https://docs.appian.com/suite/help/24.4/Execute_Stored_Procedure_Smart_Service.html
Try to optimize the stored procedure by removing unwanted joins and remove unwanted fields from selection, even if that is not working then you can try to increase the time out of store procedure.
You can refer the link for more details.
Thanks
hi Mohammed Dyab May I know what is your stored procedure doing? Are you fetching data? If yes, what is the amount of data you are trying to pull?