Alteryx Designer Knowledge Base

How Alteryx Designer and Server use file paths

Connector tools that use "Sign in via Internet Browser" do not work correctly with Designer or Server 2021.3.2. To use those tools, you should upgrade to version 2021.3.3 or later and then download and install the tool version that says " Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.." Alternatively in the short term, you can use version 2021.3.1 of Designer or Server.

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

Error: "An item with the same key has already been added" when selecting Quick Connect

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

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: "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.

Error "Failed to decrypt data: Key not valid for use in specified state." when trying to connect to Amazon Athena

When a folder name starts with a period (.), the Input Data tool throws a "Can't find the file" error.

placeholder

"I have a bajillion files that I need to bring into my workflow... wayyyyyy too many for me to use individual Input Data tools! What's the best way to do this?"                    - every Alteryx user ever

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

If a column name contains brackets, the search function in the results panel would fail.

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: "Test Query Error near 'as': syntax error" when executing a 'WITH' clause against a SQLITE table

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

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