Automation Bug

We are testing BOT with sandbox app, and encoutering bug like this.

BOT is triggered on edit a row. The process which is working is constructed like this.

Process (working)

Task : Add multiple new rows from Table 1 to Table 2 table
Task : Delete rows in Table 1
Task : Email to user to notify the process is completed.

This combination is working fine, doing the job as expected.

But once we add one more step on the top like this

Task : Email to user to notify the process is started.
Task : Add multiple new rows from Table 1 to Table 2 table
Task : Delete rows in Table 1
Task : Email to user to notify the process is completed.

Task Delete rows in table 1 is omitted. The rest of tasks are executed.

It looks a bug to me.

@Takuya_Miyai

1 Like

Thanks for bringing this up I will try to reproduce.

How are you adding multiple rows ? Do you have an action to “Execute an action on a series of rows” that then points to an action that adds a row to a table ?

Do you see any errors in the logs ?

1 Like

Hi @Dan_Bahir

On this testing app, we have temp table from where we are trying to copy all the rows onto another table, then try to delete all the rows after copy operation, using actions on set of rows for both.
Actually, not throwing any errror when they fail to delete rows after copies.

This is not a direct topic to this subject, but we are failing on the case where we are trying to copy and delete bunch of rows, such as 50K rows due to timeout related errors at the end. Wondering what is the capability of BOT (or Appsheet API?) in terms of actions against bulk number of the rows.
Any technical indication what the limiation in this case?

2 Likes

There is a timeout limit of 2 minutes on Bot executions similar to that limitation that the workflows had.

Doping bulk copy operations stretches the scope of what the system was designed to do.

If you have a business use case that you are trying to solve, please share, maybe we could think of a different way to implement or see how we can expand the product functionality.

2 Likes

The root cause for the behavior you reported was that the reference action that called delete on a sequence of nodes was trying to get the after image for them after they were deleted. The bug is in the action implementation and reproduces with the old workflows and bots.

I put a fix in and will let you know when it is deployed.

2 Likes

Thank you for investigations and wait for a fix to be released.

Please refer to other post I placed on the same day here.

Firstly we tried to import a CSV file to the target table and eventually we failed, presumably just because the number of rows and column we attempted to import.

Then we throught alternative way, which was a this BOT.

We made one table with exactly same schema as the target table. Then we copy from CSV and paste to this table manually and directly on the spreadsheet.
Then we come to AppSheet App, run a bot, which will give a user notification that bulk record import process is started.
Then move to next step, actually add rows from this table to target table using action in terms of set or rows category. Once this step is finished, we trancate the source table, and in turns it finishes, we tried to let the user know the whole process is finished.

If CSV import file action runs fine, then we dont need to buiild this type of bot, but as you see in other post, import CSV file action keeps failing. When the csv file size is relatively large, we sometime managed to import rows, but UX is not user friendly, as App after pick csv file, become responseless, no indication import csv process is done. (No dialogue comes up if or not we failed or succeeded in bulk import)
Again, we gave up import CSV action in this use case, but once again, we failed BOT which does the same job, presumably the timeout issue of the BOT.
I looked into Automation Limit,

But nothing was mentioned here, so it was new to know, that BOT process has timeout max 2 mins.

I appreciate for your guide how to make the use case to get through. I can share my sample and sandbox app with you to check it out how we can improve the BOT construction, so please let me know.

I also wait for @phil to give me a guide for CSV import file actions as well.

Thank you.

@Takuya_Miyai

2 Likes

The fix for the initial issue has been deployed, please let me know if it works for you.

1 Like

Hi @Dan_Bahir

thank you for attending to the case. Later today, we will re-test our sandbox app and report the result back to you.

In the meantime, we understand there was timeout limit of 2 mins on the BOT through this experiences. Then question is how 2 mins is going to be calculated?
Is it in total required time PER whole BOT operation ? or is it calculated by “single step” basis?
The expensive step within the bot could be either “Change Data” or “Run Task” steps.

If timeout restriction is imposed on “per step” basis, I thought we might split the data change action into separate chung and chain them as continuous steps under single bot. Just like we create our own batched to carry out the action agaist large data set.

@Takuya_Miyai

1 Like