Alteryx Designer Knowledge Base

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

Designer crashes after closing the first workflow with a Connect In-DB tool and Browse In-DB tool and then creating a 2nd workflow with the same tools.

How to format common ODBC DSN-less connection strings

The caller workflow returns an irrelevant error message when the invoked workflow completes with warnings.

Running a cell in Jupyter Notebook containing Alteryx.read() returns "Unable to connect to input data" error. This happens if the workflow is saved in a file path containing an ampersand (&).

Excel Binary file appears to be corrupted when multiple worksheets are created.

Resizing the image using the Image Settings Style Editor of the Image tool has no effect.

Image Input tool fails with the "unable to open " error if the length of the path (including filename) exceeds 260 characters in Windows 10 and Server 2019. However, there is no issue in Server 2016. All have long path enabled.

A workflow app (.yxwz) containing a Python tool creates the temp folder for the tool in the workflow location instead of the default/global temp directory.

Alteryx provides many built-in data connectors and there are additional ones available for download from the Gallery.

How to troubleshoot a blank "Product Downloads" section on the Downloads & Licenses page

Data in Excel is corrupted and truncated when exporting data table that is larger than the default layout size set in the Render tool.

Jupyter Notebook fails to load after Flask package is installed.

This article explains how to run workflows referencing excel files that are open by another user. This can be a requirement where multiple users are using the same file to update information

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.

The external Python environment must use Python version 3.8.5. Using another version will not work in the Jupyter Flow tool.

Power BI Output tool fails with "Bad request syntax or unsupported method" error if null values are found in an integer data type field.

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

When opening a workflow, the following error is received: "The Tool ID [id] Is not in the document".

"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

A basic troubleshooting for authentication errors for AWS S3 Upload/Download tools