Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.
View full article
"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
Troubleshooting the error: A Regular Expression was not specified.
View full article
Troubleshooting the error: An expression must be specified.
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: "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 outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.
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
Error "Timestamp is not close enough to the current server time" when running a workflow that contains an Oauth Macro in Alteryx Designer.
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
Error: "Cannot find data type 'ntext'" when writing data to Azure SQL database.
View full article
Troubleshooting Database Connections
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
Error: "An unexpected error occurred" when performing an Offline License Activation in Designer.
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article