This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Error: "Input Data (x) : Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

Error while connecting to MySQL, from the Input Data Tool - Error: Input Data (13): Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
View full article
0 Replies 55 Views 0 likes

Error: "The account is locked" when running a workflow after a database password has changed

Error: "The account is locked" when running a workflow after a database password has changed.
View full article
0 Replies 49 Views 0 likes

Snowflake External Tables are not showing in the Alteryx Visual Query Builder tab

Snowflake External Tables are not showing in the Alteryx Visual Query Builder tab.
View full article
0 Replies 70 Views 0 likes

Alteryx doesn't read some unicode characters correctly

Alteryx doesn't read some unicode characters correctly
View full article
0 Replies 110 Views 0 likes

Error: "ORA-00900: invalid SQL Statement" when executing a procedure in the Pre/Post SQL Statement section

Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.
View full article
1 Replies 643 Views 2 likes

Error: "Input Data (1): Error SQLExecute: No active warehouse selected in the current session." while trying to connect to Snowflake from Input Data Tool

While trying to connect to Snowflake from Alteryx Designer, using Input Data tool, the following error is thrown after running the workflow: Error: Input Data (1): Error SQLExecute: No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.
View full article
0 Replies 134 Views 0 likes

Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake with Okta SSO and MFA

Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.
View full article
0 Replies 171 Views 0 likes

Numeric values show "[Null]" instead of a blank cell using the Input Data tool

Numeric values show "[Null]" instead of a blank cell using the Input Data tool.
View full article
0 Replies 131 Views 1 likes

Error: "SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE')" when connecting to DB2 using the Input Data tool

Error: "SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE')" when connecting to DB2 using the Input Data tool.
View full article
0 Replies 233 Views 0 likes

How To: Create an In-Database Connection

How To: Create an In-Database Connection
View full article
8 Replies 16011 Views 3 likes

Thai characters are not showing up correctly

Importing Thai data from Oracle Database using Oracle ODBC driver is displaying the Thai characters as garbled characters in Alteryx. This can be addressed by setting a parameter in the driver to unconditionally change the data type to support Unicode.
View full article
0 Replies 173 Views 1 likes

Data types W_String or VW_String are not available for Flat File ASCII files

Data types W_String or VW_String are not available for Flat File ASCII files.
View full article
0 Replies 202 Views 0 likes

Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool

Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool.
View full article
0 Replies 245 Views 0 likes

Error: Failed to get username: Unspecified GSS failure: Minor code may provide more information

User is attempting to connect to Hadoop Hive with Active Directory Kerberos (Kerberos SSPI) 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.
View full article
0 Replies 275 Views 1 likes

How To: Connect to Sharepoint with Alteryx

This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.
View full article
1 Replies 1248 Views 5 likes

How to check for encoding or formatting issues with Excel worksheets

When using Excel spreadsheets in Alteryx, sometimes there may be difficulty in reading the data. Viewing the spreadsheets in XML format is an excellent way to check for encoding or formatting issues.
View full article
1 Replies 4716 Views 2 likes

Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake

Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake.
View full article
0 Replies 276 Views 1 likes

Error Conversion from data type VARCHAR1 to ASCII failed

When importing data from an SAP HANA database, a conversion error from VARCHAR1 to ASCII may occur. 
View full article
0 Replies 248 Views 0 likes

Connecting to an Oracle database causes Designer to get stuck in "Not Responding"

Connecting to an Oracle APPS schema causes Designer to get stuck in "Not Responding".
View full article
0 Replies 297 Views 0 likes

Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake

Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake.
View full article
1 Replies 436 Views 0 likes