Corrupt Flows From Decisions

TJLillo
Kilo Guru

I'm starting to use decision tables more and more, and I've found that decisions like to corrupt flows and I haven't figured out how to recover from it yet. Have others seen a similar issue? I build out a flow and add a decision to it later on and it adds the exclamations without any messages around why it added them. It'll save and publish but the flow will not run.

In the logs when I run the flow it gives me:
Flow Designer: null: no thrown error
and
Invalid query detected, please check logs for details [Unknown field element in table sys_flow_step_definition]
Invalid query detected, please check logs for details [Unknown field sys_scope in table sys_store_app]
Invalid query detected, please check logs for details [Unknown field element in table sys_hub_action_type_base]


find_real_file.png

1 ACCEPTED SOLUTION

TJLillo
Kilo Guru

I ended up solving it by pulling a copy down from our test environment and not using decision tables. The other flow that I had the issue with was resolved by rebuilding the flow with decision tables in there first, then adding the other things. It seems like it's when I'm using globally scoped applications in Flow designer.

View solution in original post

1 REPLY 1

TJLillo
Kilo Guru

I ended up solving it by pulling a copy down from our test environment and not using decision tables. The other flow that I had the issue with was resolved by rebuilding the flow with decision tables in there first, then adding the other things. It seems like it's when I'm using globally scoped applications in Flow designer.