Waste flow properties changed unwillingly into product flow properties

Question

Dear All,

An outflow with waste properties has been changed to a product flow with an unappropriate connexion and I cannot change back the flow properties into a waste.

Can anyone help on this ?

Thank you;

Jean-Michel Hébert

Answer 1

First, that's a pretty weird thing to happen, and I would have a bigger concern about making sure there weren't other similar changes. I'll provide a solution here that has no guarantee to fix anything other than making the existing flow into a waste flow. I can't guarantee connections will be fixed or anything. Backup your database first!

Find the flow that needs to be changed to the waste flow and get the UUID to reduce the chance of unintended changes to other flows

Open the SQL tool window. Tools -> Developer tools -> SQL

update tbl_flows
set flow_type='WASTE_FLOW'
where ref_id = 'youruuid-here-0000-0000-000000000000'

The result window should let you know that 1 row was updated. You may need to close and re-open the database to see the change.

Comments

Yes, indeed, we do not allow changing the flow type via the user interface for good reason - the flow type influences how a flow can be used in modeling, and if you change the flow type, this of course applies everywhere where the flow is used. Thus, to the question, I wonder why and how this has happened if not by executing some code (SQL or other), or by having created the same flow twice, with different types, and if you have no clue, then I would not execute additional code. It is also not "properties" of the flow but it is its type.

---

Thank you both we indeed fixed the problem using the SQL tool.