Alteryx Designer Desktop Knowledge Base

After upgrading the Alteryx License Server to 2021.4, any commands entered using the flexnetlsadmin.bat batch script fail with the License Server asking for a valid Server Base URL.

A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.

Designer crashes after closing the first workflow with a Connect In-DB tool and Browse In-DB tool and then creating a 2nd workflow with the same tools.

Unable to open the Designer instance on the server once DCM was enabled

Error: "The following fields are not updatable members of the target table" received when performing an update to a record with the Salesforce Output Tool. The column is locked for editing by your Salesforce Administrator or is the incorrect primary key to reference for updating the record.

When using Amazon Redshift Bulk Connection, Output Data tool option "Size of Bulk Load Chunks (1 MB to 102400 MB)" is set to default when the Bulk Size value is higher than 4K

When running a workflow that outputs to a file, the following is added to the filename. Note that this doesn't affect the actual filename: 'AlteryxBasePluginsGui.DbFileOutput.DbFileOutput'

The Assisted Modeling tool crashes when starting the configuration.

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.

A video walkthrough for the setup and configuration of the Microsoft Dataverse connector, which has succeeded the Microsoft Dynamics CRM connector.

When Alteryx creates a query determined by an In-DB workflow, if the workflow includes a Join In-DB tool, Alteryx aliases the tables to be joined as "Left" and "Right". These are reserved words for some databases.

Image Input tool fails with the "unable to open " error if the length of the path (including filename) exceeds 260 characters in Windows 10 and Server 2019. However, there is no issue in Server 2016. All have long path enabled.

Designer installed in double-byte characters (Japanese) named folder fails to load the tool palette when the Japanese language is used in Designer. Tools palette loads fine in other languages though.

Exporting data from the Browse tool to a CSV file cannot display/convert the double-byte characters correctly.

Installing a package from the Python tool is an important task. In this article, we will review all the possible functionality included with the Python method Alteryx.installPackages().

When trying to license Alteryx Server on a Windows 8 based computer , the user receives the error "An internet connection is required for activation. Please connect to the internet and try again, or contact customer support. Contact your license administrator for help with licensing. Defect TCPE-196

Alteryx.read() returns "attempt to seek past the end of the file" on an empty incoming data source