Alteryx Server Knowledge Base

A FATAL connect error occurs when trying to publish a workflow to the Gallery that connects to a PostgreSQL database with Kerberos authentication.

21.3 defect impacting workflows with a Gallery Data Connection

Troubleshooting "Unable to translate Alias" with Gallery Data Connections

Error while publishing workflow to the Gallery

Upgrade from Alteryx 2019.4.8 to 2021.2.1 and experiencing intermittent connectivity issues between Designer/Server and Azure SQL databases.

This article details the steps and best practices for users who need to run In-DB workflows on the server

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.

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.

How to connect to Alteryx Server MongoDB using the command line

Gallery Data Connections for Greenplum throws LDAP authentication failure message

This KB provides you with steps on connecting to a User-Managed MongoDB using Robo 3T

In developing workflows our users need to push workflows to server or scheduler that contain database connections.  This is a common source of errors if not configured properly.

User is running workflow on gallery and getting a GSSAPI error

Error: "You have found a bug" when saving a workflow to Gallery that involves a MySQL connection

How to set up a Bulk Loader Connection in Gallery.

We hope that you are as excited about this new feature as we are! The new Database Connection Share is a feature that will allow ease of access for your Alteryx users to your databases. The feature also allows the Alteryx Gallery and Database Administrators more governance over what connections are being made as well as who are making the connections. The Admin of the Gallery can create and manage their users' data connections.

FAQs about Gallery Data Connections

When saving a workflow to the gallery, the following error occurs: Tool ## - Error finding connection "connection_name".

Error: "failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK'" when running a workflow.

Error: "[SQLState 08S01] fe_sendauth: no password supplied" when using Amazon Redshift and publishing to the Gallery.

Error: "SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031" when connecting to DB2 z/OS