Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
Error SQLExecute: Internal Query Processor Error: The query processor could not produce a query plan. For more information contact Customer Support Services.
View full article
When connected to an Oracle database, the Visual Query Builder will freeze, or Designer occasionally crashes, when trying to select a method of aggregation for a selected column
View full article
If there is already a selected stored procedure in the SQL Editor tab, clicking on the Stored Procedures tab in the “Configure Pre/Post SQL statements and Stored Procedure” window will throw out “Unable to find stored procedure ” where the name of the procedure is incorrect.
View full article
When upgrading to 2022.3 the previous way of formatting in the SQL Editor Parser no longer yields a successful query. You have to move the lines up one so that one of the entries (if multiple entries are listed) are next to the Select field and also the same for the From field.
View full article
Publishing workflow to Alteryx Server fails with "Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.\42000=18452
View full article
Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.
View full article
A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.
View full article
When attempting to output to SQL table with only one column, the "No value column to update" error is thrown.
View full article
DCM connection fails if the query has lines commented out using – When using a connection set up through DCM you get various syntax errors on queries that has lines commented out using -- . The queries work just fine when using a normal ODBC connection.
View full article
Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement, such as dropping/creating tables
View full article
"Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$variable name$$. Variable is marked as required but not set in the query" when querying SAP Hana object
View full article
Error "An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB'" when converting an ODBC DSN-less connection to OLEDB
View full article
The guide covers SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, CROSS JOIN, WHERE BETWEEN, WHEREIN, DISTINCT and we hope you find it helpful.
View full article
Error opening "SHOW VARIABLES LIKE 'aurora_version'" when connecting to MariaDB via ODBC.
View full article
Using SQL Server connections, "date" datatype fields are changed to "V_WString"
View full article
Outputting to SQL Server by the Output Tool option "Create New Table" resulted in CREATE TABLE Permission Denied.
View full article
Alteryx provides GUI tools that offer similar functionality to many SQL commands. Although minimal SQL scripting may be necessary in order to properly configure tools, the amount required to complete analysis is significantly reduced.
View full article