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
Discussion posts and replies are publicly visible
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.