Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
How to format common ODBC DSN-less connection strings
View full article
"Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$variable name$$. Variable is marked as required but not set in the query" when querying SAP Hana object
View full article
When using the Intersect tool to compare the same spatial information between an MRR file and a GRD file, the MMR is showing an offset, when the overlap should be 100%
View full article
Error "Failed to decrypt data: Key not valid for use in specified state." when trying to connect to data source
View full article
Designer 2021.4.1 Excel XLSX Data Input Tool skips initial columns with no data in first row (Row 1)
View full article
For a SQL Server connection, the Test Query in the SQL Editor is returning with message "Error opening : No Columns Returned."
View full article
Visual Query Builder does not populate schemas containing only views for Snowflake
View full article
When using Simba Snowflake 2.23.02.1012 some NULL values are transformed into encoded values
View full article
When user tries to input CSV file that has delimiter character encapsulated in quotes (so that it should not be considered a delimiter), connector will not consider the file valid.
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article
Receive error "ORA-00942 - table or view does not exist" or "ORA-00903 - invalid table name" using output mode to "Append Existing" even though the table exists
View full article
Receive "Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] (-3706) Syntax error: expected something between .. " in input Data Tool
View full article
Error: "The COPY failed with error: End of record reached while expected to parse column" when trying to update Snowflake using Bulk Connection
View full article
Steps to troubleshooting an "Unhandled Exception" error when attempting to open the Manage Data Connections window.
View full article
Error: "Windows Security patch prevents the Jet driver from reading .xls files; install the 2010 32-bit Access driver" when loading an Excel .xls file
View full article
The ODBC connection error "Netsuite ODBC Connection Error "[NetSuite][ODBC 64bit driver][OpenAcess SDK SQL Engine]You have entered an invalid e-mail address, password or context (AccountID, RoleID) information" occurs when connecting to NetSuite via a Input Data tool.
View full article
When accessing the MongoDB that is backing the Alteryx server using the MongoDB Input tool reading in AS_Schedules, AS_Queue, AS_Applications, AS_Results collections for analysis in a workflow, it throws the error "MongoDB Input: cursor id not found: generic server error" for larger collections
View full article
How Alteryx Designer and Server use file paths
View full article
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.
View full article
When using special charater "≥" value in a database Input Data tool, the field displays as "=".
View full article