Skip to main content
M
mdyab0001
December 2, 2024
Question

executestoredprocedure

  • December 2, 2024
  • 5 replies
  • 0 views

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
    mathieud0001
    December 2, 2024

    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

    M
    mdyab0001Author
    December 2, 2024

    Thanks

    S
    shivanireddys0001
    December 2, 2024

    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.

    M
    mdyab0001Author
    December 2, 2024

    Thanks

    karumurua531442
    karumurua531442
    December 7, 2024

    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?

    Terms & ConditionsAccessibility statement