We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
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
"Error: Designer x64: The Designer x64 reported: Error running Event #1: The external program "C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe" returned an error code: 2: The system could not find the environment option that was entered. (203)"
View full article
DCM connection fails if the query has lines commented out using – When using a connection set up through DCM you get various syntax errors on queries that has lines commented out using -- . The queries work just fine when using a normal ODBC connection.
View full article
Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement, such as dropping/creating tables
View full article
Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.
View full article
This article describes how to identify if the "Email or Password were incorrect. Please try again." error message when signing into Atleryx Server from Alteryx Designer is due to version incompatibility.
View full article
When using Auto Insights uploader v1.4 for Designer 2021.4, DCM needs to be enabled. And SDK Access Mode must be Allow instead of AllowAll
View full article
"Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$variable name$$. Variable is marked as required but not set in the query" when querying SAP Hana object
View full article
Designer installed in double-byte characters (Japanese) named folder fails to load the tool palette when the Japanese language is used in Designer. Tools palette loads fine in other languages though.
View full article
"Error: Microsoft Visual C++ 14.0 or greater is required" when installing Python library 'pandas-dedupe' in the Jupyter Notebook interface
View full article
When running a workflow with Publish to Tableau tool using TDE / Hyper the workflow returned an error "Error: The file was not uploaded successfully"
View full article
Stored Procedures are powerful and helpful, however, in Designer and Server it is required for them to have a return value. If that is not the case the error "no columns returned" will occur.
View full article
For a SQL Server connection, the Test Query in the SQL Editor is returning with message "Error opening : No Columns Returned."
View full article