Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
Error: "ORA-21500: internal error code, arguments: [%s], [%s], [%s]" when pulling Spatial data from Oracle using Input data tool.
View full article
Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.
View full article
There is a comprehensive list of Data Sources Alteryx Designer / Server can connect to. While only these are supported you still might be able to build your own connector. Additionally a product feature can be requested.
View full article
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
Where do you start when you see "An Unhandled Exception occurred"?
View full article
This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.
View full article
Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake.
View full article
The Run Command tool can be used to connect to SQL Server and run complex SQL statements as well as multiple stored procedures.
View full article
Connecting to an Oracle APPS schema causes Designer to get stuck in "Not Responding".
View full article
This is a workaround for connecting to an Oracle database that uses LDAP authentication.
View full article
Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake.
View full article
This error occurs when importing a Gallery Data Connection, but there is an issue with the Gallery Data Connection.
View full article
Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.
View full article
Alteryx has the ability to connect with MIT Kerberos and Active Directory (Kerberos SSPI) based Hadoop implementations. With this feature came the need to tell the driver that you are using Windows Kerberos/Kerberos SSPI and not MIT's version.
View full article
Alteryx can connect to databases using different methods. This guide will focus on setting up an OleDB connection to SQL server, however, the same general process can be followed to connect to any database via OleDB.
View full article
All the In-DB connections in Alteryx Designer are lost. Where are these settings stored?
View full article
Error: "Oracle driver: You are not licensed to use this DataDirect Technologies product" when connecting to Oracle in Designer.
View full article
This article details different methods for connecting to an Oracle database from Alteryx.
View full article
Not able to clear the In-DB connection string history. There is no option or button to clear it.
View full article
Cannot update passwords in the Input Data or the Output Data tool.
View full article