Alteryx Designer Desktop Knowledge Base

Error: "Marshaling Private Key Failed" when trying to connect to Snowflake

When using special charater "≥" value in a database Input Data tool, the field displays as "=".

When publishing a workflow with a SQL Server OLEDB connection, Designer returns with the error: Can't create Data Source Object

Nothing happens when clicking on the Save button when manually creating a connection string.

Error: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.

User is attempting to connect to Hadoop Hive with Kerberos in Alteryx and getting an error: Failed to get username: Routine Error: Unspecified GSS failure. Minor code may provide more information. The test button in the ODBC DSN is successful.

When connecting or testing the HDFS connection, "Invalid Host or Port" is shown even though the host is reachable.

Metadata is not available in Visual Query Builder for MariaDB

The Input Tool does not display any stored procedures.

Error: "Primary Key required for Update option" when using Update option for Output on Hive.

Error opening "SHOW VARIABLES LIKE 'aurora_version'" when connecting to MariaDB via ODBC.

Error: "Error encountered when executing file transfer: Failed to upload file" when using the Snowflake bulk option in the Output data tool.

The Visual Query Builder is not displaying the table columns for PostgreSQL connection.

"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

Using SQL Server connections, "date" datatype fields are changed to "V_WString"

Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname

Outputting to SQL Server by the Output Tool option "Create New Table" resulted in CREATE TABLE Permission Denied.

Incorrect number of records being read from an Oracle database. Alteryx appears to be adding 100 duplicate rows

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

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

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.