We've had an upgrade that upgraded or Alteryx to 2022.1. after this upgrade I get weird error's with union tools.
the error I can't fix is the The input "#1" was not initialized.error.
what I've done:
deleted all union tools in the workflow and replace them.
note: there is a python tool and crew runner tools in the workflow that connect to the same union tool all write output that I want to union together.
AMP is disabled!
previously (before upgrade) everything worked fine.
The 2023.1 Release is not out yet, this fix will be in that when it goes out. We are also backporting the fix to upcoming patches for 2022.3 and 2022.1 Release versions.
2022.1.1 Patch 6 has been released and can be found at: https://us1.alteryxcloud.com/license-portal/
I’m happy to announce that the fix has been released in the 2023.1 GA Release version May 17, 2023, which is available for download from our licensing portal.
This is still an issue. Noticing it on the Trend AB tool.
Did you ever figure out a fix for the issue? I'm running into it now in a union tool and when I delete and re-add my tool, the workflow runs fine. Once I change one of my app selections that is a check box, I get the error again.
so what is the solution?
Version: 2023.1.1.281 Patch: 3
still not working Error: Union (1249): The input "#1" was not initialized.
This is a workflow behavioral issue. Union tool already has information of all columns and unlike append, it doesn't wait therefore, Union tool executes and then realize that other stream has not come. This generally happens when #1 stream has large data and #2 stream has less data (you might have tick mark Specific order).
Solution: change the order: Less data stream is on top and Large data stream on below. Example if #1 has 1000 rows and #2 has 10 rows then order will be #2 then #1.
