Alteryx Designer Desktop Knowledge Base

How do I identify the column(s) responsible for the SQL Server error, “String or binary data would be truncated”.

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

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

This KB outlines the workaround for DE18888 where Cyrillic characters from DB2 are not displaying in Designer

Error: "Unsupported data type 'bit'", when writing data with a Boolean to Snowflake.

Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.

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

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

Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata.

The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.

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

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.

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

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.

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

Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.

Connecting to an Oracle APPS schema causes Designer to get stuck in "Not Responding".

Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.

All the In-DB connections in Alteryx Designer are lost. Where are these settings stored?

Error: "Oracle driver: You are not licensed to use this DataDirect Technologies product" when connecting to Oracle in Designer.

Cannot update passwords in the Input Data or the Output Data tool.