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.
This directory was generated by the Alteryx install script, and contains an instance of the Oracle Instant Client. Oracle Instant Client is a collection of installed Oracle Database libraries for connecting Alteryx Designer to local or remote Oracle Databases. There’s no need for tnsnames.ora file.
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 your Python libraries don't work the way they should in Python tool, restoring the tool to it's original state could be the solution. This article walks through how to restore Python libraries and the virtual environment associated with the Python tool.
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
When upgrading Designer from 2021.3 to 2021.4 or 2022.1, you may encounter an error about SRCComposer_x64.dll module not found
View full article
What's the difference between Admin and Non-Admin installs of Alteryx? Stuff and things.
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
The article provides steps to address the "WARNING: url:'c:\Program FIles\Alteryx\bin\Miniconda3\Common_Config\Wheels' is ignored. It is either a non-existing path or lacks a specific scheme." and the "no matching distribution found for" error when installing YXI.
View full article
If there is a space in the temporary directory, Predictive tools in Data Investigation, Predictive and Time Series and even R tool fail with errors like the following: Error in parse(text - 5): :1:17:unexpected INCOMPLETE_STRING
View full article
Connectors troubleshooting landing page
View full article
Google Big Query v3.0 Input tool with ‘Service-to-Service’ authentication errors with "AttributeError: 'NoneType' object has no attribute 'message_types_by_name'"
View full article
There may be a time when there is a need to gather more information on why the Alteryx installation/uninstallation fails. This article will show you how you can enable the installer log.
View full article
The SharePoint connector allows you to use Service Principal for downloading and uploading files, but it requires the Sites.All permission, which gives the user access to all the Sites in the tenant. This article describes how to set it up.
View full article
Saving a workflow to Gallery fails with an error if there is a configuration issue with "On Success - Show Results to User" option in the Interface Designer window.
View full article
The article provides troubleshooting steps when "404 not found" error is encountered in Python tool.
View full article
When you try to insert a record to an Amazon Redshift table which has a column with attribute IDENTITY(seed, step), the record is inserted fine, but the value of the first column to be inserted is null instead of the value being passed into the Output Data tool.
View full article