Skip to main content
nirupamaanuragt
Known Participant
Jan 29, 2026 5:43 AM UTC
Question

Getting error on process model node to execute stored procedure

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

    sabhyap604572
    New Participant
    Jan 29, 2026 8:43 AM UTC

    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
      Brainy
      Jan 29, 2026 10:52 AM UTC

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

      Happy to help. Even happier to optimize.
        Terms & ConditionsAccessibility statement