Home > Forum > Actions > Issues - run sql procedure action

Issues - run sql procedure action
0

In a step, I configured an On timeout action that runs a SQL procedure (a very simple query that updates a field in another database) after 1 minute.
However, occasionally—about 1–2 times out of 100—the field is not updated, even though in history shows that the action was executed successfully.

An external process calls the WEBCON API using a specific path. On that path, a SQL procedure action is configured to run - same as above.
The field is not updated in the database, even though in history shows that the action was executed successfully.

DBVersion=2023_1_2

Do you have any suggestions?
Thank you.

Hi,

It would be easier to advise if you could provide anonymized “pseudo” code of your SQL actions. However, here are a few tips from my side:

Ad. 1** Please check whether the operation duration exceeds the path or system-level timeout limit. In such a case, the action might be triggered, but the result could then be rolled back. It may also be caused by further actions configured on the same path.

Ad. 2** Please check whether the execution of your external procedure is committed. It might be that it is being rolled back by the external database while WEBCON assumes everything completed successfully. I would try adding a `COMMIT` at the end of your remote procedure to see if it helps.

Please let me know whether any of these ideas help.

Regards,
Jaroslaw