Skip to main content
N
nirupamaanuragt
January 29, 2026
Question

Getting error on process model node to execute stored procedure

  • January 29, 2026
  • 2 replies
  • 0 views

Hello,

We have recently upgraded to 25.4 version. The deprecated plugin 'Execute Stored procedure' is removed, and Appian inbuilt function is used to execute the stored procedure to load the data in cloud DB. However, the node is failing with error - Query execution was interrupted (max_statement_time exceeded).

Kindly help what is missing and if the 25.4 version has any specific config to set the max statement time.

On some of the node receiving following error - ORA-01013: user requested cancel of current operation https://docs.oracle.com/error-help/db/ora-01013/. The node configuration is same in both the cases.

Regards,

Nirupama

    2 replies

    S
    sabhyap604572
    January 29, 2026

    The max timeout limit for the smart service is 600 seconds. The default is 30 seconds. Can you try executing the stored procedure in db? if it is taking more than 30 seconds then it can be optimised, if possible else try configuring the max timeout limit.

      harshas2775
      harshas2775
      January 29, 2026

      Refer the limitations and workaround suggested for this issue here docs.appian.com/.../Execute_Stored_Procedure_Smart_Service.html

        Terms & ConditionsAccessibility statement