Alteryx Designer Desktop Knowledge Base

When upgrading to 2022.3 the previous way of formatting in the SQL Editor Parser no longer yields a successful query. You have to move the lines up one so that one of the entries (if multiple entries are listed) are next to the Select field and also the same for the From field.

When a workflow writes a large data set to Tableau Server, it may throw an error halfway through because the Tableau Server credentials token expired.

Creating an OleDB In-DB connection using the Microsoft SQL Server data source with a SQL Server Native Client 11.0 connection string in Manage In-DB Connections generates an Unhandled Exception error. This error also occurs anytime you go back to edit the alias/connection after creation.

The PCXML file created by the Allocate Report tool returns "ComposerDoc::GetCSSProperty: Unknown error" when opening it.

Alteryx.write() returns "XmlParse Error: the attribute "type" is missing“ if there is a double-quote in the column name and the double quote is followed by a space and more characters.

This article provides answers the most frequently asked questions related to In-Database Tools.

Using Selenium 4.6.0 in interactive mode with "from ayx import Alteryx" statement causes an error in the Chrome Web driver.

A mismatch of timezone in Windows setting and registry can cause Assisted Modeling tool to fail

An overview of Azure applications and how they are used by Alteryx Designer to securely access your data.

When exporting a large amount of data from Databricks (over 500k rows), a result file download error is received.

After upgrading Designer, clicking on the ellipsis(...) to launch the Query Builder window, results in error "Could not load type 'ActiveDatabaseSoftware.ActiveQueryBuilder.SnowflakeMetadataProvider' from assembly 'ActiveDatabaseSoftware.ODBCMetadataProvider2"

Create Points tool fails with “You have found a bug” error when creating 500k points in AMP engine.

Assisted Modeling tool will cause an exception if a data set is too huge. Anything around 40K is fine.

Need notes

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

Alteryx.getWorkflowConstants() fails to return any User-defined constants in AMP engine

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

How to Connect to Databases Outside of Alteryx.

Error: "Could not load requested Drivetime dataset: Latest:TeleAtlas_US" when running a workflow

In order to output DUNS numbers from Alteryx's DNB Analytical File, your Account Executive at Alteryx would need to assist you further.

This directory was generated by the Alteryx install script, and contains an instance of the Oracle Instant Client. Oracle Instant Client is a collection of installed Oracle Database libraries for connecting Alteryx Designer to local or remote Oracle Databases. There’s no need for tnsnames.ora file.