Alteryx Server Knowledge Base

Definitive answers from Server experts.
FAQs about Gallery Data Connections
View full article
This workflow downloads all workflows from a Server to a local machine using the V1 API endpoint /webapi/admin/v1/workflows and the V3 API Pack, then parses through the XML to search for a specified term (such as tools used, database connections, DSNs, queries, versions, etc.).
View full article
Updating to either 2021.4.2.47792 (Patch 5) or 2022.1.1.3.42590 (Patch 3) results in a failed schema migration if customer has any Gallery Data Connections established that contain empty passwords in their connection strings.
View full article
A few tips to help customer optimize db read and write speed. Please note that this is a gray area in terms of Support.
View full article
Driver configuration can impact how the data connection performs on a given machine.
View full article
Identifying bad network routes or firewall issues affecting Server nodes or data source hosts
View full article
How to set up a Bulk Loader Connection in Gallery.
View full article
How to connect to Alteryx Server MongoDB using the command line
View full article
This article details the steps and best practices for users who need to run In-DB workflows on the server
View full article
This KB provides you with steps on connecting to a User-Managed MongoDB using Robo 3T
View full article
Error: "Validation failed. The input value is greater than 9999" when using DCM Data Source > Oracle Quick Connect menu.
View full article
When saving a workflow to the gallery, the following error occurs: Tool ## - Error finding connection "connection_name".
View full article
Snowflake Error in Gallery after running workflow: failed:CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error' osCode=2 osMsg='No such file or directory'
View full article
A FATAL connect error occurs when trying to publish a workflow to the Gallery that connects to a PostgreSQL database with Kerberos authentication.
View full article
Troubleshooting "Unable to translate Alias" with Gallery Data Connections
View full article
Upgrade from Alteryx 2019.4.8 to 2021.2.1 and experiencing intermittent connectivity issues between Designer/Server and Azure SQL databases.
View full article
Running a workflow with a database connection in the Gallery in a multi-node environment gets an error despite the connection working in the controller's instance of Designer. This is caused by not having a matching DSN or driver on the worker nodes.
View full article
When the option "Allow user alias to override the system alias" in Alteryx System Settings is selected the relevant UserAlias.xml file will be used rather than the System Alias. If after a credentials or other data source configuration change only the system connection was changed the user connection will be still used and this can cause the workflow to fail running in Designer or uploading to Gallery.
View full article