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
ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
community Data Science Portal Alteryx.com
alteryx Community
Search
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: 
Close

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" thrown in server while executing query: Invalid column reference

When trying to read data from Hive, the error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" is thrown in the server while executing a query.
View full article
9 Replies 1193 Views 3 likes

Alteryx Designer: Unable to select or change the database on an existing Gallery data connection

Not able to select a different database for existing Gallery connections for SQL Server within Designer.
View full article
0 Replies 681 Views 0 likes

Designer Returns Null Value for a Column of Date Datatype in a DB2 Database

When connecting to a DB2 Database via ODBC in Designer, some Date datatype from a column are coming up Null
View full article
0 Replies 239 Views 0 likes

Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse

Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse.
View full article
0 Replies 890 Views 2 likes

Error: Can’t find the file: “[path\FileName]”. Make sure the file path is correct.

Error: Can’t find the file: “[path\FileName]”. Make sure the file path is correct. Error text being revised from Error: File not found "[path\FileName]"
View full article
1 Replies 732 Views 2 likes

How to download and install SQL Server ODBC drivers

How to download and install SQL Server ODBC drivers.
View full article
0 Replies 208 Views 1 likes

Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow

Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow.
View full article
0 Replies 170 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 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.
View full article
0 Replies 942 Views 2 likes

How to format common ODBC DSN-less connection strings

How to format common ODBC DSN-less connection strings
View full article
7 Replies 6358 Views 9 likes

Error: "Incompatible with the Client software" when connecting to Teradata in Designer

Error: "Incompatible with the Client software" when connecting to Teradata in Designer
View full article
0 Replies 143 Views 0 likes

Display issues when reading data with unicode characters from Oracle

Display issues when reading data with unicode characters from Oracle
View full article
0 Replies 351 Views 0 likes

Error: "Must declare the scalar variable '@var_name'" when running PL/SQL in Pre or Post SQL Statement Section

Error: "Must declare the scalar variable '@var_name'" when running PL/SQL in Pre or Post SQL Statement Section.
View full article
1 Replies 607 Views 0 likes

Display issues when reading data with Cyrillic characters from DB2

This KB outlines the workaround for DE18888 where Cyrillic characters from DB2 are not displaying in Designer
View full article
0 Replies 175 Views 2 likes

End of Support for 32-BIT Database Connections

Learn about upcoming changes to Alteryx support of 32-bit database connections and start planning today
View full article
0 Replies 529 Views 4 likes

Error: "Login failed for user '<token-identified principal>'" when connecting to SQL Server with Azure Active Directory

Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.
View full article
0 Replies 743 Views 0 likes

Tool Mastery | Text Input

Here we’ll delve into uses of the Text Input Tool on our way to mastering the Alteryx Designer:
View full article
12 Replies 38210 Views 48 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 973 Views 2 likes

How to query a DateTime from Alteryx Server MongoDB using the MongoDB Input tool

Querying a date from the Alteryx Server Persistence MongoDB using the MongoDB Input tool can be tricky since Alteryx Server dates are stored as string values. Here is how to use regex in the criteria section of the MongoDB Input tool.
View full article
0 Replies 663 Views 0 likes

Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener

Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener.
View full article
0 Replies 300 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 1233 Views 0 likes

Error: Win32 Exception when connecting to a Database

User gets a Win32 Exception when trying to connect to a database or edit a query
View full article
0 Replies 303 Views 0 likes