Alteryx Designer Desktop Knowledge Base

With the release of 2018.3 comes a very exciting new functionality – workflow caching! Caching can save a lot of time during workflow development by saving data at “checkpoints” in the workflow, so that each time you add a new step to your workflow, it does not need to rerun the workflow in its entirety, rather it can pick up from your last Cache point. There are a couple conditions where tools cannot be selected as cache points, including tools with multiple output anchors, and tools in "circles".

Status 500: Server Error UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 1049741870-255018 (1453348545)

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.

Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.

Installing a package from the Python tool is an important task. In this article, we will review all the possible functionality included with the Python method Alteryx.installPackages().

The ODBC connection error "Netsuite ODBC Connection Error "[NetSuite][ODBC 64bit driver][OpenAcess SDK SQL Engine]You have entered an invalid e-mail address, password or context (AccountID, RoleID) information" occurs when connecting to NetSuite via a Input Data tool.

When trying to add a license key to Alteryx License Server an error - The System cannot find the file specified - may be seen if the password contains a pipe character |

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

With the release of 2018.3 comes the long-awaited and highly anticipated Python Tool! This article is a general introduction to using the tool.

The error message appears when using System Settings in Alteryx Designer.

An Unhandled Exception occurred when opening a workflow

You know that a huge part of conveying information to your audience is your visual presentation. Here's a way to increase the amount of information that can be shared with just a glance: Segment the data in a chart with color.

When starting Alteryx Designer the below error is received: There was an error while loading: Object reference not set to an instance of an object.

Release version and corresponding support dates

While trying to connect to Snowflake from Alteryx Designer, using Input Data tool, the following error is thrown after running the workflow: Error: Input Data (1): Error SQLExecute: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.

Issue   When using the Salesforce Input tool, the following error is seen at run-time:   400: Bad Request     This may only occur on some tables It fails almost immediately after the workflow starts running. It may also been seen on the Salesforce Credentials screen along with the error: invalid_grant: authentication failure     Environment   Alteryx Designer Version 2018.3+ Salesforce Input tool Version 4.0 or 4.1   Diagnosis   Confirm where you are seeing the error. If it is on the Salesforce Credentials configuration page when you click Connect, and you see "invalid_grant", please see Solution B.   Otherwise, validate the query to get a more verbose error log.   1. Use the Query Builder option (this is the default option) and select the Table and Output Fields you want to read in. 2. Change to the Custom Query option and click the Validate button:   3. If you receive the error: "OPERATION_TOO_LARGE: exceeded 100000 distinct ids", see Solution A.     Solution A   The data you are attempting to pull is too large to be returned in one call based on the Salesforce API limits used by the Salesforce Input Tool. Limit the number of results returned by modifying the WHERE Clause (SOQL) in the tool's configuration:     Please see the Additional Resources section below for a guide on SOQL (Salesforce Object Query Language). Here are some suggestions:   Try limiting date fields by relative dates : CreatedDate = THIS_YEAR Try limiting a string field to a certain value: Name='SFDC Computing' You can also combine conditions with logical operators like AND & OR: Name='SFDC Computing' AND NumberOfEmployees>25 For more advanced comparisons, you can perform fuzzy matches by using the LIKE operator. For example, you can retrieve all accounts whose names start with SFDC by using this condition:  WHERE Name LIKE 'SFDC%' - The % wildcard character matches any or no character. The _ character in contrast can be used to match just one character.     Solution B   The credentials are incorrect. Please confirm your Username, Password, and Token are correct.     Additional Resources   Salesforce Knowledge Base - Write SOQL Queries Salesforce Knowledge Base - Reset Your Security Token