Worrying inconsistencies in workflow action execution

Need help
1

Dear Forum

I’m in the last steps of finishing my application.
Therefore I’m testing the main logic of my application thoroughly and I’ve run in to two unexpected behaviors of backend workflow action performance:

  1. Values aren’t saved to Thing although logs confirm, that e.g. Value ‘X’ was written to Thing’s Field ‘Y’, i.e. confirming that the data was written to Thing.
  2. 'List a' merged with 'List b' merged with 'List c' only returns ‘List c’, although List a, b, and c are all Lists of all unique elements. This is not the behavior I expect based on what the documentation of bubble says.

For both of these cases I cannot find any workflow errors in my logs, and these cases are not a one time thing but happen again and again reliably at the same action. I’ve gone over the logic of the Expressions over and over again and am 100% certain that the implemented logic is correct (can provide screenshots If someone isn’t taking what I say at face value)

Perhaps there are further Issues I haven’t found yet.

There seems to be a bigger reliability problem in exactly performing the actions the application / bubble platform is instructed to do – maybe connected to ‘addressing problematic queries’ that Josh points out in his recent announcements?

Any one else having similar problems at the moment? It’s really frustrating to have a program not execute exactly what you tell it to do as this would be the thing you expect from a machine.

I submitted bug reports for all these but haven’t heard any constructive feedback from Bubble yet.

Would be great to hear from your experiences

2

best way to debug this is to forget the log reports

just break down the workflow into steps and write each steps output into a data so you can see it

this way you can annotate each output so you know what is working and what isn’t working and the result from each input query

3

Have you checked your privacy rules? Updates to DB that are blocked by privacy rules will not produce any error logs.

4

Well, there goes my 100% certainty :-/

ISSUE 1 SOLVED
It was privacy all along (in combination with race conditions). I created the Thing where entries should be written to and added the executing user to a field (at creation) which lets the user see the relevant fields for the writing operation, and then passed the Thing into a downward workflow. However, when performing the writing operation, it seems that the user in the field that allows them to see the relevant writing fields wasn’t updated yet.

Thank you guys for pointing that out.

ISSUE 2 SOLVED
The issue no 2 was due to a malformed expression which I have to admit was stupid that I didn’t catch it earlier. I had an expression as follows:

DATASTRUCTURE
Workrequest, has field:

  • Phases Works (list of type Phase)
  • Phases Procurement (list of type Phase)

Phase, has field:

  • children (list) of Phase’s

FAULTY EXPRESSION

Workrequest's Phases Works merged with Workrequest's Phases Procurement merged with Workrequest's Phases Procurement:each item's children

→ The problem with this expression arises from the logical sequence of (List A + List B + List C): each item’s children, where I thought intuitively that the expression should resolve as follows: (List A + List B) + (List C’s:each items Children)

1 Like