Alteryx Designer Knowledge Base

Connector tools that use "Sign in via Internet Browser" do not work correctly with Designer or Server 2021.3.2. To use those tools, you should upgrade to version 2021.3.3 or later and then download and install the tool version that says " Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.." Alternatively in the short term, you can use version 2021.3.1 of Designer or Server.

Nothing happens when clicking on the Save button when manually creating a connection string.

Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.

Error "Failed to decrypt data: Key not valid for use in specified state." when trying to connect to Amazon Athena

placeholder

Error: "Primary Key required for Update option" when using Update option for Output on Hive.

Error: "Error encountered when executing file transfer: Failed to upload file" when using the Snowflake bulk option in the Output data tool.

Outputting to SQL Server by the Output Tool option "Create New Table" resulted in CREATE TABLE Permission Denied.

Uploading duplicate data using Postgres Bulk Update reports as successful, when the update has actually failed with a unique constraint violation error.

Error when trying to write to Redshift

This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.

Error: "Cannot find data type 'ntext'" when writing data to Azure SQL database.

How to collect Wireshark traces to troubleshoot network-related issues.

Message: "No Lua script" was found explanation.

Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.

Multiple Excel Files to One Excel File

During run time of workflow, the following error is received:

Additional characters such as ! are appearing in emails sent from Designer.

Troubleshooting error with Publish to Tableau Server tool: TypeError: Cannot read property ‘token’ of undefined

Ever have to output tables of differeing schemas to the same Excel workbook? Ever need to output to different tabs? This article covers your bases with the cunning use of Reporting tools! Also included are links to other helpful "outputting to Excel" Knowledgebase Articles.

Have you ever tried writing to multiple tabs within the same workflow and have received an error? This article is for you!