Skip to main content
Solved

Process flow present in database but not on UI

  • October 24, 2024
  • 2 replies
  • 31 views

Ionut
Warrior
Forum|alt.badge.img+2

Hello!

Recently we started to replace some Http Connectors to Web Connection, for that we checked in database to see which process flows have it.

We discovered that for a process flow which is present in database, it does not display on the Software Factory UI, we are not sure how that happened, but it happened somehow.

If we try to add one with that name, we get obviously an error that the name is already taken.

Do you have any idea how to bring it back to the UI or how it happened? We might need to take a closer look into it to see it's importance, but until then will be nice to know what is going on.

Thanks!

Best answer by Mark Jongeling

Hi @Ionut,

That is a bit strange. Can you run the Select query as presented in the Debug panel of the Windows GUI? There could be some discrepency between a regular select * from table and what the GUI actually executes.

Also make sure you run thye query on the Software Factory database. The IAM database also has the process_action table and can contain a record for this whilst the row in the SF does no longer exist.

Alternatively, (re)create the process flow and inspect the History via the Show history task (Ctrl + H). That should tell the tale about its existence.

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3959 replies
  • Answer
  • October 24, 2024

Hi @Ionut,

That is a bit strange. Can you run the Select query as presented in the Debug panel of the Windows GUI? There could be some discrepency between a regular select * from table and what the GUI actually executes.

Also make sure you run thye query on the Software Factory database. The IAM database also has the process_action table and can contain a record for this whilst the row in the SF does no longer exist.

Alternatively, (re)create the process flow and inspect the History via the Show history task (Ctrl + H). That should tell the tale about its existence.


Ionut
Warrior
Forum|alt.badge.img+2
  • Author
  • Warrior
  • 28 replies
  • October 24, 2024

Hi @Mark Jongeling,

​Indeed your suggestion with the debug panel helped me to identify what is going on.
Basically, that is an existing Process Flow, but not a normal one, it is a Sub Flow which appears of course in the database.
The select for process flows is like this:

While the one for Sub Flows is opposite.

Thanks for help, now is clear how that works.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings