“Start: ConnectNamedPipe” Errors that occur when attempting to run the flow...at very beginning are in my experience due to security software like McAfee ATP (active threat protection). Bear in mind Alteryx is a "Load & Go" type of high level programming language that when you press "play" it runs a series of programs and snippets to transform your GUI workflow into a machine language executable form. These newer types of protection software, even when in "Observe" mode, will intercept and analyze all that activity to score it as a risk or not. This can at times cause delays in the interconnected events, thus ConnectNamedPipe error, basically a thread between 2 or more activities time out.
Another error we saw frequently before sorting this out is "Root Element Missing". this usually occurs when you open a flow and click on an input or dynamic input that has SQL. The issue here is the delay we are experiencing cause the initial DB query to get Table info failed, probably for timeout, and so you get a Root Element Missing error.
Be aware that errors “DataWrap2_ConnectNamedPipe after 11000 milliseconds” are a different issue, this seems to be a connectivity timeout, to NAS storage or some other data appliance.
The idea of a white list is to identify programs, files and or folders to exclude from the security program's process.
The attached pics are what we implemented with success for both Admin and non-Admin installs
