Alteryx Designer Knowledge Base

Error: "Test Query Error near 'as': syntax error" when executing a 'WITH' clause against a SQLITE table

How to fix an issue where the Python Tool Configuration Panel is blank

Uploading duplicate data using Postgres Bulk Update reports as successful, when the update has actually failed with a unique constraint violation error.

This article discusses how to fix the Onload failed in loadNamespace error experienced when users have issues associated with predictive tools that make use of the pdftools package

When troubleshooting Python Issues in Alteryx, this Health Check can be used to determine whether your Jupyter Environment installation is complete and functional.

When outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.

When publishing a workflow to Gallery or Scheduler (Designer + Desktop Automation) or when packaging a workflow for export, checking the boxes for what to include and what to exclude seems to work inconsistently as of Designer 2020.2. The workaround will tide you over until you can upgrade to 2021.2.

Creating a new date field based on a formula

Error when trying to write to Redshift

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 "Timestamp is not close enough to the current server time" when running a workflow that contains an Oauth Macro in Alteryx Designer.

This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.

AlteryxRPluginEngine.dll could not be loaded: The specified procedure could not be found

Snowflake Connection Failure - Error SQLDriverConnect:[Snowflake][Snowflake] (4) REST request for URL xxxxxx failed: CURLerror (curl_easy_perform() failed) – code=6 msg=’Couldn’t resolve host name

AlteryxSpatialPluginsEngine.dll could not be loaded: The specified module could not be found

When the client has multiple browser sessions open with anything connecting to the gallery, it might cause an invalid session error when uploading a workflow to the Gallery.

The Run Button, Schedule Button, and the active document buttons disappear from Designer when you make the configuration pane or Result pane a tabbed document

Error: "Cannot find data type 'ntext'" when writing data to Azure SQL database.

Troubleshooting Database Connections

How to Sort with IN-Database tools

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