Frustrating In-DB error

[byung0917]

Dear all. As usual... I'm seeking for help to solve a problem. 

This In-DB flow works with no error but when I click the "select" tool... nothing shows up. "No Data Available"....

Which means I cannot configure anything on the cleansing and multi-field formula tool. 

Funny thing is.. if I copy and paste into a new canvas... the flow works totally fine and I can see everything on the outgoing node of the select tool... 

What's going on? This error happens randomly and cannot figure out how to avoid this situation. 

Can someone please help??

[BrandonB]

After configuring the In-DB tools, data stream out, and followed with a select tool I like to right click on the select tool and "cache and run workflow". This will pull the data through and cache it so that it doesn't need to execute the query on subsequent runs. It should also help with the issue that you are occasionally experiencing.