Alteryx Server Knowledge Base

Definitive answers from Server experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
Error: "failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK'" when running a workflow.
View full article
After uploading a workflow to Gallery, you can make changes and manage multiple versions.
View full article
Running a workflow on Alteryx Server or Gallery never finishes and no errors are thrown.
View full article
How to determine which User deleted a Gallery application
View full article
How To: Shrink the size of Alteryx Server Embedded MongoDB It is common to see cases where the customer says that they are running out of space on their database. The customer goes into his Alteryx System Settings > Controller > Persistence > Persistence Options, decreases the number of days he wants to hold on to workflow results, completed schedules, or uploaded files in their database, they then notice that the workflow results, completed schedules, or uploaded files have less records, however the size of his database remains the same. When you change the persistence options by changing the number of days you want to deleteworkflow results, completed schedules, or uploaded files from the database, you are indeed getting rid of those files, however the space where those files were, are now empty spaces in the database. In order to get rid of those empty spaces you need to perform a database backup and restore, which will then eliminate all of those empty spaces and shrink the size of the database. This is explained in the MongoDB documentation, here, scrolling down to the section named "How do I reclaim disk space in WiredTiger?". Prerequisites Product - Alteryx Server Product - Embedded MongoDB Example Keep in mind that this procedure below is based on an existing sample I created and the description is based on the sample. 1. Verification Verify Size of Embedded MongoDB by navigating to the database folder in a File Explorer > right click > select properties > verify size. - Notice on the screenshot below thatin my case the MongoDB has a size of 913 MB. - To find out where your database folder open Alteryx System Settings > Controller > Persistence > Data Folder Open Alteryx Designer in the server and go to Options > View Schedules > Make sure that the Controller field is set to "My Computer" > go into the Results tab > verify the number of results in the bottom left of the View Schedules screen - Notice on the screenshot bellow that my scheduler contains 174 results 2. Implementation Open Alteryx System Settings > Controller > Persistence > Persistence Options If you do not have any of the Persistence Options Enabled then enable them by selecting the checkboxes and set it to the desired number of days. The Persistence options are: - Delete queue and results after (days) - Delete completed schedules after (days) - Delete uploaded files after (days) When you enable Persistence Options, which are pretty much self explanatory, queue and results, completed schedules, and uploaded files will be deleted after the number of days set by the user. In my example the Alteryx System Settings had the Persistence Options "Delete queue and results after (days)" and "Delete completed schedules after (days)" set to delete my results that are over 120 days old.I changed those settings to 30 days and then I kept clicking next through all the screens until it finished and the service automatically restarted. 3- After Implementation Back into my scheduler you can see that the total number of results went down from 174 (previously checked in the verification section above) to only 71 workflows. Also notice that the size of my database did not change. It is still 913 MB. The procedure above did delete multiple documents from the database, however (as mentioned on the introduction of this article above) those documents are now empty spaces and the size occupied by the database remains the same. Procedure In order to get rid of the empty spaces in the database it is necessary to do a database backup and restore. 1. Backup Create an empty folder to store the backup in. I named it MongoDB_backup. Open command prompt as administrator Navigate to path “Program Files\Alteryx\bin” Stop the service by using command "AlteryxService.exe stop" Then enter the emongodump command as seen below ( AlteryxService.exe emongodump=Z:\Path\MongoDB_backup) : After the backup finishes it is time to do a restore. 5. Restore As you can see on my screenshot below, first I checked if the service was still stopped. Rename the current database folder (i.e. MongoDB_4_0.old). I then created a new empty folder with the exact same name as what my Mongo database had: MongoDB_4_0 Then I ran the emongorestore command - ( alteryxservice emongorestore=,) Once the restore finished I started the service. ( AlteryxService.exe start) Then I verified the status of service to make sure it is running. 6- Verify if the size of the database has decreased In Windows File Explorer right-click over the MongoDB_4_0 folder and select Properties Notice that the size is now 693 MB, rather then 913 MB as it initially had. Additional Resources Alteryx Server Backup %26 Recovery Part 1: Best Practices Alteryx Server Backup %26 Recovery Part 2: Procedures
View full article
One of the three database options when setting up the Alteryx Server is to connect into a User-Managed MongoDB instance.  Why would you want to set up your own implementation of MongoDB?  The main benefits are to take advantage of the features of MongoDB that are not included with our embedded instance.
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
This KB gives you fundamental understanding on how to extract a list of users and their permissions on the Gallery. Only relevant for versions 2020.1+ with Windows Authentication.
View full article
As Alteryx analysts, we’re whipping up insight at blazing fast speeds. Workflow after workflow, tool after tool, we’re gleaming functional understanding from inert webs of data that empower us to make better decisions. Good insight is only as good as it is shareable, however, and to enable better sharing any Alteryx analyst can take advantage of their Workflow Dependencies to simplify input or output path dependencies in shared workflows.
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
Error: "[SQLState 08S01] fe_sendauth: no password supplied" when using Amazon Redshift and publishing to the Gallery.
View full article
This KB provides you with steps on connecting to a User-Managed MongoDB using Robo 3T
View full article
After upgrading to 20.1, viewers are not able to execute workflows shared with them via Collections.
View full article
How to setup a SQL Server Bulk Loader Connection in Gallery.
View full article
Error: "SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031" when connecting to DB2 z/OS
View full article
Error: "This workflow requires a higher version of Alteryx" when saving a workflow to the Gallery. Is it possible to publish workflows from a newer version of Designer to an older version of Server?
View full article
When migrating a MongoDB to a new machine all the relevant steps in https://help.alteryx.com/20201/server/server-host-recovery-guide (use document for your Server version) should be followed. Skipping steps can cause issue occurring later.
View full article
The UI for User Management has changed fundamentally in Alteryx Server 2020.1. As such the Permissions tab disappeared and User Management takes place via the Users tab only.
View full article
Error resolving python plugin for various Connectors when running on the Server/Gallery.
View full article
Overview and suggestions on how allow multiple AD account to run specific workflows using specific credentials.
View full article