Alteryx Designer Knowledge Base

Error even though the table has a Primary Key

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.

This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.

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

Received the error "Error in PDF Rendering. Error Number: 4119: FILE OPEN ERROR" whenever using Table Tool or Render Tool.

Error: Can’t find the file: “[path\FileName]”. Make sure the file path is correct. Error text being revised from Error: File not found "[path\FileName]"

Unhandled Exception when clicking on the Browse Tool when using an R and Cross Tab in the workflow

Error while installing additional R packages in Alteryx Designer - "GenericTool (1): Can't find plugin "AlteryxRPluginEngine.dll""

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.