Alteryx Designer Knowledge Base

How to download and install SQL Server ODBC drivers.

Where do you start when you see "An Unhandled Exception occurred"?

The SharePoint List Output tool cannot write to metadata columns. This capability will be added in a future release.

Designer requires .NET version 4.7 or newer to use the TLS 1.1 or 1.2 protocols. For workstations with Windows 7, other configurations are also needed.

Data Cleansing tool doesn't work in 2020.4 when the Field name contains line breaks unix style line endings.

When installing alteryx, the installer gets stuck on the python dependency window

XML Parse tool does not detect specific child

SMTP fails in Email tool. The error "Record#1: Unable to create a socket after looping through all network addresses for YOUR-MAIL-HOST-NAME" is returned.

Some of the tools Alteryx Designer uses require proxy to be enabled and setup. This document will advise how to check if a proxy exists on a system.

When running a workflow that uses a RegEx tool ahead of a Select Record tool, you receive different results with or without uding the Use AMP Engine.

This error is displayed on current workflows with R and then if you put a new R tool on a blank canvas

Display issues when reading data with unicode characters from Oracle

When publishing a workflow to Gallery or Scheduler (Designer + Desktop Automation) or when packaging a workflow for export, checking the boxes for what to include and what to exclude seems to work inconsistently as of Designer 2020.2. Here is a workaround to cover you until the issue is resolved in a future release.

User is getting the error "Detour tools in macros must terminate within that macro" when trying to use a macro in a workflow

A workflow that includes a Python tool may throw an error of the form "Error: unable to read data (C:\AppData\Alteryx\Engine\Engine_23200_be6a9480b4fc4e038a8668b82debdf74_\aa37b5ac-6323-472b-8f0f-5cb0b95b822e\4460abb7be83bae8f01b9bf1238a923c.yxdb)"

This error may occur with Desktop Automation schedules. It can be corrected by changing the Alteryx Service log on account.

This error occurs when a transaction limit is exceeded. It can be resolved by configuring bulk uploads on the server or using an iterative macro.

Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"

In some cases the Python tool will not start. This article discusses the common root cause that during installation there was not enough disk space for all the Python environment files to be created.

When trying to read data from Hive, the error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" is thrown in the server while executing a query.