Query was not found in data flow. Correct the data flow or notify Customer Support.

[nagarju]

Hi All,

(14.3) 09-29-23 16:01:40 (E) (3152:11464) RES-020102: |SESSION 117TRNRET|WORKFLOW WF_EDI_CLIENT_117TRNRET_EXTRACT|DATAFLOW DF_EDI_CLIENT_117TRNRET_EXTRACT|STATEMENT <GUID::'a972e095-ff2a-449f-8009-91febf462df4' QUERY QRY_RELATED>
Query <Query_117joints> was not found in data flow. Correct the data flow or notify Customer Support.

Please find the screenshot. I am using same table as target in 1 map and source in another map but both maps are in 1 dataflow. It fine run the job with this scenario.

Also we are extracting data from excel file and deviated it as 2 queries and joined in another query.

Can you please explore how to solve this issue.screenshot-of-error.png

Thanks and Regards,

Nagarjuna.

[RichS · Accepted solution]

It is not valid and does not make sense to both populate a template table and read from it in two streams that run concurrently/asynchronously. You should separate the top and bottom parts of your existing dataflow into two (connected) dataflows. Alternatively, if you don't need the CL_117TRNRET_EXT template table afterwards, you could eliminate it altogether and just connect the query called QRY_3 to the query called Summarize.