Alteryx Designer Desktop Knowledge Base

When attempting to output to SQL table with only one column, the "No value column to update" error is thrown.

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.

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

Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.

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.

"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

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.

"Error: Microsoft Visual C++ 14.0 or greater is required" when installing Python library 'pandas-dedupe' in the Jupyter Notebook interface

When running a workflow with Publish to Tableau tool using TDE / Hyper the workflow returned an error "Error: The file was not uploaded successfully"

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.

For a SQL Server connection, the Test Query in the SQL Editor is returning with message "Error opening : No Columns Returned."

How to fix the error "This product requires at least Internet Explorer 6.0" error when installing Alteryx Designer.

XML Parse tool does not detect specific child

How to fix an error during installation that says "The feature you are trying to use is on a network resource that is unavailable".

Error "An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB'" when converting an ODBC DSN-less connection to OLEDB

Adding or overwriting a worksheet in a workbook that contains a pivot table, corrupts the file and an attempt to repair the excel sheet removes the pivot.

Python tool is not able to create misc files (JSON, YXDB) in the temporary location if the workflow is stored in a file path that is too long. This fails when running the workflow via the command line as the temporary location is created in the workflow location.

Configuring the SharePoint Files Tools

Tableau data source names resulting in an error via the Publish to Tableau Server Tool

When using a python tool with pandas package, xlrd is unable to read .xlsx files, only .xls.

When user tries to input CSV file that has delimiter character encapsulated in quotes (so that it should not be considered a delimiter), connector will not consider the file valid.