LinkedIn
Twitter
I am posting here and mentioning specific people about the following phenomena I experienced before I went on Annual Leave at my workplace.
I have a complex automation sequence that works 90 percent of the time. I am aiming to get to 100 percent of the time, but there is a strange bug (happens randomly maybe 2 in 5 times) that causes missing data and stops the automation from completing.
I believe something similar to this behaviour has been looked into before with regard to passing the correct locale and timezone information through various steps in a bot...here we go.
This bot get's triggered as usual. In STEP 1, a process is called. Basically, the process returns 4 pieces of information...it's like a LOOKUP, but returns multiple values in one go. This process executes flawlessly on every time it is called so no problems there. However, we will return to the bug in a little while.
In STEP 2, an Appscript Task is called. The task is passed some of the returned values from the previous process as inputs.
Once again, STEP 2 executes every time without problem and returns an object with a number of keys and values.
In STEP 3, values that were returned from the Appscript Task and a value that was returned from the ReadVolume process in STEP 1 are written to the record. It is in this step that the called process's value has been replaced with an empty string "" or possibly null as this is written to the column.
I have examined the monitor for the bot run and stepped through the list of Inputs and outputs and can verify that the value that should be inserted into the column CFDocID is passed correctly from the process in STEP 1.
Somewhere between STEP 2 and STEP 3, the value is being lost from memory or perhaps being overwritten/dropped in the backend of Appsheet.
Again, this happens randomly...but it is verifiable that the value is passed correctly in STEP 1.
@nico is Appscript Task causing values to be lost in this bot? Possibly?
@AleksiAlkio Any hidden issues you may be aware of that can cause data to be lost during the execution of a bot?
@lizlynch could you do your magic and make sure the correct people see this?
