Skip to main content
Known Participant
Dec 2, 2024 12:04 PM UTC
Question

executestoredprocedure

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?

    5 replies

    mathieud0001
    Genius
    Dec 2, 2024 12:31 PM UTC

    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

    mdyab0001Author
    Known Participant
    Dec 2, 2024 1:03 PM UTC

    Thanks

    Participating Frequently
    Dec 2, 2024 12:50 PM UTC

    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.

    mdyab0001Author
    Known Participant
    Dec 2, 2024 1:03 PM UTC

    Thanks

    karumurua531442
    Participating Frequently
    Dec 7, 2024 2:56 AM UTC

    hi [mention:0480a57c95c0407bb65036c11c266b30:e9ed411860ed4f2ba0265705b8793d05] 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?