Alteryx Designer Knowledge Base

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.

When ruining a workflow, the Designer throws the message: "The workflow contains unlicensed tools"

Users can experience this error message upon opening Alteryx Designer or upon select the File menu option.

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.

Alteryx doesn't read some unicode characters correctly

Procedures on how to configure Designer for input of large, zipped text files for processing.

SAP HANA Field Description

User is getting an error writing an excel file to a shared drive.

Very rarely Designer can crash with a big red X across a window. One such situation has been observed and resolved.

Calgary Loader (2) PagedFile::Add: keys out of order, sort not supported yet.

Troubleshooting the "Unknown Function YEAR()" error, or other related Date expressions.

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.

Troubleshooting: Error creating a Snowflake Table

Error even though the table has a Primary Key

This article explains how to run workflows referencing excel files that are open by another user. This can be a requirement where multiple users are using the same file to update information

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.

Some Salesforce users do not use Salesforce Security Tokens. An accepted IP range can be set up instead in Salesforce Admin. This article will walk you through the steps to modify the Salesforce Output tool to be able to be used without a Salesforce Security Token.

For problems with Windows not launching Designer or displaying an error message, the Program Compatibility Troubleshooter may help.

Data preparation and investigation are a must for successful Predictive Modeling.