Help w/ Error: "AlteryxProcessManager::Start: Timed out in DataWrap2_ConnectNamedPipe..."

Can anyone provide any color on what the error message means?

I have read other posts implying that simply disabling the firewall, or something similar, would do the trick. After testing the workflow with the antivirus software enabled and disabled, I'm confident that's not the issue.

For some context; my workflow has a macro that utilizes a dynamic input tool. This is the tool identified in the error. Unfortunately I can't provide a workflow or data as both are confidential.

Any information would be appreciated and I'm more than willing to field questions to help clarify anything.

Thank you!

Error Message

Accepted answers

All comments

BrandonB

Do you have multiple different file types or different schemas for the files? Can you copy and paste the tools in question into a new workflow and see if you can run it on its own?

patrick_digan

@ktipping I just thought I would share our experience with 2020.4 and this error. We've run into an issue where some .xls files which have worked fine for years are not able to be read into alteryx designer 2020.4. It takes 30 seconds and then provides that timeout message that you're seeing. We're trying to figure out how big of an issue it is. For now, we just saved our xls file as xlsx and everything worked fine.

EDIT: Here is the message we get when drag the offending xls file onto the canvas

ktipping

I received the same error message when I copy and pasted the tools into a new workflow and ran it. The file types are xls, I'm not sure on whether they have different schema.

ktipping

@patrick_digan I'll look into changing the file type.

BrandonB

Thanks for sharing @patrick_digan. Is the support team already engaged on this?

taxtechfl

I upgraded to 2020.4.5.12471 and since then have been receiving the error as well when attempting to ingest an XLS file. I will convert the XLS files to XLSX as a workaround, but I am very much interested in your conclusions from your testing. Thanks!

BrandonB

Hi @adan98

Can you send an email to support@alteryx.com? They can take a closer look and identify where things are breaking down for you. Normally if I see a workflow that is particularly slow it is due to a crosstab resulting in a massive number of columns. The metadata from all of these columns is stored in the workflow file itself so the actual file size of the workflow may appear to be larger than normal as well. Hopefully this helps!

alexcordero

Any resolution or did it resolve when upgrading? Just encountered error running 2021.2 version.

ktipping

@alexcordero Unfortunately I can't recall what the fix was to this issue, sorry about that.

alexcordero

Our error was in being thrown in a Dynamic Input tool. We fixed by having the user substitute an IN clause vs. "=" and then click on the Group Replacement Value for SQL IN Clause in the Modify SQL: Update WHERE Clause selection. Doesn't sound like this is what you were dealing with but generated the same error.

flying008

Hi,@alexcordero

What detail version number of you used 2021.2.*.***** ? if same, maybe i can rept the error , then have a idea.

alexcordero

yes, 2021.2

Fiserv_TGabel

I had the same issue on a Dynamic Input Tool after I started adding tools after it. I ended on a Select Tool and ran the workflow. It then failed with a similar error as mentioned in the post. I then added a Browse tool after the Select tool and the error went away and the data read in correctly. I know this is an old article but maybe this will help someone. I am using version 2022.3.1.395

I have noticed this on other tools as well - if you don't connect the output to something then the workflow will fail....

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235