Scheduled bot ran twice

[Eduardo_Jr_Vill]

Hi, I have a scheduled bot that runs for each record in the table.

And when looking in the bot monitor logs, I see two runs for the same record

Could it be due to execution time limit? I see the automation limit for a scheduled automation process is 5 minutes max. But I’m not sure if the documentation applies the limit applies to “Each record” run for a bot. or the bulk run of all records in one bot.

I did one sample on one record

• The first ran for 200+ seconds
• The duplicate ran for 400 seconds

Is it possible that the bot running twice was due to timeout? and re-run on it’s own? regardless both runs gave “Success”…

[kennysz]

This has been happening to some of us here, but the issue hasn’t gained much traction on AppSheet support’s end to further investigate: Scripts triggered twice per run

I’ve had to duplicate the scheduled bot to prevent it from running twice. The duplicated bot runs as expected, so I disable the bot that runs twice.

I recommend reaching out to support to further investigate this issue.

[Jose_Arteaga]

Hello all,

Thanks for reporting this. The support team has identified the root cause and they are implementing a fix next week.

[Eduardo_Jr_Vill]

Thanks. Can you tell us what caused this?

[Steve]

@Jose_Arteaga, has the fix been implemented? Can you share the root cause?

[mateo]

It is 1st of July and I am facing the same issues in multiple apps that I maintain. This issue was raised many times since I started using AppSheet. I cannot understand why it is happening. See attached image. The same process was triggered twice in the period of ~5-6 minutes. I have no idea why this is happening. Platform automations start being unreliable. Because of that we are having huge amount of additional work to clean this up.

To anticipate questions:

• Webhooks are configured the way that there is no retry if error appears to avoid duplicates, etc (Max number of retries on failure = 0)
• When using filters/select, etc I am always checking the results and it is not like it runs on too many rows or something like that - it runs on exact same rows the 2nd time, like it would be cached somewhere on AppSheet end

Below screenshot is showing just one app where it happened. So far I found this in 4 different apps. Issue is ONLY with scheduled bots. In some I use webhook, in some data actions. In the automation monitor there are no errors, warnings or anything like that. It just runs once, and then runs once again.

Please help me understand what I am doing wrong, if anything.
Thanks in advance!