Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
When attempting to Write to MySQL with the output option "Update: Insert if New" you get an error if the table has a composite primary key of multiple fields and none of the data have changed in the row
View full article
Error: "Could not load requested Drivetime dataset: Latest:TeleAtlas_US" when running a workflow
View full article
When a folder name starts with a period (.), the Input Data tool throws a "Can't find the file" error.
View full article
When trying to create a temporary table for use in the Data Input Tool (connecting to Google BigQuery) the workflow errors out with "Executing PreSQL: CREATE OR REPLACE TEMPORARY TABLE... Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session"
View full article
Publishing workflow to Alteryx Server fails with "Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.\42000=18452
View full article
Error “The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended” when both Use AMP Engine and Enable Performance Profiling is enabled in the Workflow Configuration Runtime tab
View full article
Error "Unable to find the dll: "AlteryxBasePluginsEngine.dll"" in workflows containing a Python-based Connector and a Table Tool
View full article
Whenever attempting to connect HDFS to a Dynamic Input Tool, users may encounter the error: "Server root URL must be in the form "http://server:port""
View full article
When querying data with ROWID using Oracle OCI driver with the Input Data and Connecting IN-DB tools will result in the following errors: "You have found a bug".
View full article
Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.
View full article
When using a Python-based connector (e.g. Salesforce Input, Azure Data Lake File Input), an error message referring to CERTIFICATE_VERIFY_FAILED appears. With the new releases of the connectors tools there are three additional errors that can happen and can be resolved with these steps.
View full article
This document explains the steps to export HAR files by using Chrome Developer Tools built into Designer to investigate the interface of HTML GUI SDK tools.
View full article
Error: "Input Data (1117): Internal Error: Invalid parameter detected in function (null). File: (null) Line: 0 Expression: (null)." when pulling data from PostgreSQL
View full article
Error being returned via the Select Tool functionality for field names with updated case type.
View full article
Error when choosing Options > Advanced Options > System Settings: Method not found: 'Void AlteryxGuiToolkit.Dialogs.Licensing.ManageLicenses.ShowLicensingDialog(System.Windows.Forms.Control, Boolean, Boolean)'
View full article
Error: "An unexpected error occurred" when performing an Offline License Activation in Designer.
View full article
When trying to connect to a snowflake database, I am getting the error CURLerror (curl_easy_perform() failed) - code = 6 msg = 'Couldn't resolve host name'.
View full article
After upgrading the Alteryx License Server to 2021.4, any commands entered using the flexnetlsadmin.bat batch script fail with the License Server asking for a valid Server Base URL.
View full article
A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.
View full article
When attempting to output to SQL table with only one column, the "No value column to update" error is thrown.
View full article