Hello there,
I have a workflow that takes about 2.5 - 3 hrs to run on the Alteryx server. The workflow has in DB Hive connections ( The data is large). As per the request of my client, I had to make some adjustments to a certain static input file and added additional formula, Join and union tools accordingly. when I run the final third of the workflow that has new additions to it, the workflows runs perfectly fine. But when I run the entire workflow with the new changes, the server is throwing me a error on a certain Join tool (Error: Both left and right inputs must have connections).
So, this error that occurs at a certain Join tool is located between the first and last sections of the complete workflow and has nothing to do with the new additions, as the new additions have been added at the final third of the workflow.
I have to run the Entire workflow on a Daily basis. I cannot run it in sub sections.
Several things that I have done: Tried dividing the workflow and it works perfectly fine. Tried running limited data and it works perfectly fine. tried running only the section where the error occurs and the workflow runs perfectly fine. Also, tried replacing the sub sections by running them on a separate tab and replacing them on the original workflow and still the error occurs. I do not have errors on in DB Hive connections and they work perfectly fine.
I believe there were several threads on this issue. None of them were helpful.
I would really appreciate if one of you could help me out.
NOTE: I need to the run this workflow daily on the Company's Alteryx server.
