Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
"Error (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) " when using HIVE ODBC Connection
View full article
Using SQL Server connections, "date" datatype fields are changed to "V_WString"
View full article
Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname
View full article
Outputting to SQL Server by the Output Tool option "Create New Table" resulted in CREATE TABLE Permission Denied.
View full article
Error: "Error encountered when executing file transfer: Failed to upload file" when using Snowflake bulk
View full article
Error: "An item with the same key has already been added" when selecting Oracle Quick Connect
View full article
Incorrect number of records being read from an Oracle database. Alteryx appears to be adding 100 duplicate rows
View full article
Error: "Test Query Error near 'as': syntax error" when executing a 'WITH' clause against a SQLITE table
View full article
Uploading duplicate data using Postgres Bulk Update reports as successful, when the update has actually failed with a unique constraint violation error.
View full article
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.
View full article
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
View full article
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
View full article
Troubleshooting Database Connections
View full article
This article provides answers the most frequently asked questions related to In-Database Tools.
View full article
Error: "SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE')" when connecting to DB2 using the Input Data tool.
View full article
Error: "ORA-12557: TNS: protocol adapter not loadable" when trying to connect to an Oracle database
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article
How To: Gather ODBC Logs for troubleshooting
View full article