Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
How to set up Data Connection Manager (DCM) for Designer and Server?
View full article
Error SQLExecute: Internal Query Processor Error: The query processor could not produce a query plan. For more information contact Customer Support Services.
View full article
With the changes to with the newer python connectors, adding the certificate to the connector is a slightly difference process. Normally this should not be necessary but for testing it might need to be done.
View full article
The Dynamic Input tool with a DCM connection using the "Modify SQL Query", the "Replace a specific string" seems to be targeting the "Connection ID" attribute instead of the "Query" and the "Update a Where Clause" seems to be impacted as it does not show any WHERE clauses to update.
View full article
Upon configuring a Render Tool to output to a PowerPoint Presentation, the resulting file is corrupt.
View full article
Add workflow error: An error occurred adding the workflow. Service error message: Server Error: 500 Server Error Get ExpectedValue: Expected “Command” but got “Tld” Incorrect type requested 4 actual 1
View full article
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".
View full article
Directions for setting up Google Big Query with Bulk Write in Designer 22.3
View full article
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.
View full article
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.
View full article
Using Selenium 4.6.0 in interactive mode with "from ayx import Alteryx" statement causes an error in the Chrome Web driver.
View full article
Create Points tool fails with “You have found a bug” error when creating 500k points in AMP engine.
View full article
Status 500: Server Error UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 1049741870-255018 (1453348545)
View full article
When upgrading Designer from 2021.3 to 2021.4 or 2022.1, you may encounter an error about SRCComposer_x64.dll module not found
View full article
Publishing workflow to Alteryx Server fails with "Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.\42000=18452
View full article
Error "Unable to find the dll: "AlteryxBasePluginsEngine.dll"" in workflows containing a Python-based Connector and a Table Tool
View full article