Execute Store Procedure: Not able to update the data

Certified Associate Developer

Hi All,

I have created a store procedure in MySQL (that is within Appian) that updates and delete some data. It is working as expected all the time while calling from Procedure from PHP Client and Appian rules using execute store procedure function. But sometimes it is not working as expected while executing from Execute Store Procedure Smart Service. All the process nodes are chained. My Observation are as below:-

1. When user submits the form for the first time it is not working. Now I manually start the node then it is working fine.

2. When user navigates to next page and go back then again if they submit then it is working fine.

3. When user submits the form for the third time it is not working fine.

But from the rules it is working fine every time. In the smart services I just created acp of the same name and type with that of procedure Input.

1. Is that for chained nodes?

2. Is there any thing about autocommit

DELIMITER $$

CREATE PROCEDURE <myProcedurename>(

IN var1 INT

)

BEGIN

DECLARE variables and ERROR HNDLR

SET AUTOCOMIT = 0;

START TRANSACTION;

//Some codes

COMMIT;

SET AUTOCOMMIT = 1;

END ;

DELIMITER ;

Thanks in advanced!

  Discussion posts and replies are publicly visible