Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
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
Error: "Incompatible with the Client software" when connecting to Teradata in Designer
View full article
This error may be resolved with anti-virus settings, reinstallation, or if needed, use of the 1.09 version.
View full article
Error: "Must declare the scalar variable '@var_name'" when running PL/SQL in Pre or Post SQL Statement Section.
View full article
A workflow that includes a Python tool may throw an error of the form "Error: unable to read data (C:\AppData\Alteryx\Engine\Engine_23200_be6a9480b4fc4e038a8668b82debdf74_\aa37b5ac-6323-472b-8f0f-5cb0b95b822e\4460abb7be83bae8f01b9bf1238a923c.yxdb)"
View full article
Error: "Unsupported data type 'bit'", when writing data with a Boolean to Snowflake.
View full article
Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.
View full article
Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"
View full article
Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.
View full article
In some cases a customer using the Publish to Tableau Server macro encounters the error message "Failed to start a new Hyper instance". The only currently working solution for this is to perform a nuclear uninstall and then reinstall of Alteryx Designer.
View full article
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
Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake.
View full article
User gets a Win32 Exception when trying to connect to a database or edit a query
View full article
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
This error is usually caused by two things: The file you selected is of a differentformat than what is selected in the File Format drop down in the Configuration window. A .yxdb file you are using as an input has become corrupt. Other causes can be found here:https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Error-FileID-does-not-match-in-the-FileHeader/ta-p/19870 Although extremely rare, if a .yxdb file becoming corrupt is the culprit (one cause is a network connection dropping in the middle of writing the file), you may have a quick and simple way to resolve this potentially stomach-dropping issue: Open up Windows Explorer and navigate to the file. Right-click on the file and choose Properties. Click on the Previous Versions tab. If you're lucky, there isat least one option of the file that you can revert back to you, hopefully allowing you to avert disaster. Obviously, this doesn't just work with Alteryx files, so perhaps this knowledge will come in handy with other files. Thanks for reading!
View full article
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
When ruining a workflow, the Designer throws the message: "The workflow contains unlicensed tools"
View full article
Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata.
View full article
The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.
View full article
Robocopy is a robust Windows Command Prompt utility for copying files from one location to another. Unfortunately, it uses exit code 1 to indicate success which Alteryx interprets as an error.
View full article