community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Knowledge Base

Definitive answers from Server experts.
Issue   Some users can experience the below error when working with numeric data:   FormatException RequestID: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx    In Alteryx Designer When publishing workflows to a Gallery:     On the Gallery When running a workflow, it will first display the below error message:         We are unable to get the status of your workflow results at this time. You can close this view and check the Workflow Results page later.       Trying to view the Workflow's results will display the below error message:         Error Getting Job Results Unknown error. FormatException RequestID: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx           Environment   Alteryx Server Version ≥ 2018.4 to version 2019.3 Operating System Microsoft Windows Server with European regional Settings    Diagnosis   Open the Control Panel -> Clock and Region -> Region settings on the server:     On the new window, open the Additional Settings:     Under the "Numbers" tab, verify what symbol has been set for "Digit grouping symbol":     If it is left blank or set to a space (" "), refer to the Solution at the end of the article.   Cause   The Alteryx Server expects there is a character present for the Digit Grouping Symbol, this will be fixed in a future release (DE18733).   Solution   If the Decimal Symbol is set to a period (.) : Change the "Digit grouping symbol" from a space to a comma (,) If the Decimal Symbol is set to a comma (,) : Change the "Digit grouping symbol" from a space to a period (.) Save the changes Apply it to the system account through the below: Control Panel -> Clock and Region -> Region settings -> Tab "Administrative" -> Copy settings -> Check “Welcome screen and system accounts” -> Ok Restart the Alteryx Service   As always, don't hesitate to contact us over at Customer Support if you run into any trouble.
View full article
Have you ever needed to see your shared gallery connections and who they are shared with? This week, with the help of @MattH, we put together a simple workflow that queries your MongoDB and matches Connections to Users and Subscriptions they are shared with.   I’ve attached a workflow template to the post. All that you need to do is update the MongoDB input tools to point to your Alteryx Server.   Update the Server, User Name, and Password with the same credentials that you use for the Server Usage Report:     You might notice the secret ingredient here is to use “Include Mongo_id Field” to match the Users and Subscriptions.   The user name can generally be left as user and password comes from you Server System Settings here:     And the final output looks like this!     The workflow output is a Browse Tool, but you can update the workflow to output however you choose.   Hoping this can help some other folks with Server Administration!   Cady
View full article
 "Invalid Username or Password" Error When Setting Up Workflow Credentials   The below error can occur when trying to set up Workflow Credentials. There are two possible root causes.   Invalid username or password   The actual error in Gallery Admin will look as below.         Environment   Product - Alteryx Server System Settings (Workflow Credentials are set up) Diagnosis Check whether the workflow credentials used work as a local login for the user on the server. If no, proceed with cause A. Else go to cause B.   Cause A The workflow credentials are incorrect. This can have various reasons for instance a changed password or a locked account.  Your IT team should be able to double check whether this is the case. Refer to solution A.   Cause B The workflow credentials used are indeed correct. However, the permissions of the user account are not sufficient for impersonation purposes.   Solution A Together with your IT team make sure the correct credentials are being used.   As always if the issue persists feel free to reach out to   Alteryx Customer Support.   Solution B  This case is commonly caused by group policy settings on the server denying the user either to log on locally or to log on as a batch job. To correct this the user account used workflow credentials have been set up for needs to be given the same permissions required for a Run As User. For details of the required permissions refer to the online server help documentation - https://help.alteryx.com/server/current/admin/Configuration/RunasPermissions.htm . Please note that the referenced permissions do not allow logon via remote desktop.    As always if the issue persists feel free to reach out to   Alteryx Customer Support.   Additional Resources   Server KB article on how Workflow Credentials work vis-a-vis other permission settings available on Server - https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-Workflow-Credentials-Work-on-a-Private-Gallery/ta-p/176171 Online server help documentation  on setting up Workflow Credentials -  https://help.alteryx.com/server/current/admin/Administration/WorkflowCredentials.htm Server KB article on Admin Gallery including section on Workflow Credentials - https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Gallery-Series-The-Lay-of-the-Land-101-Gallery-Admin/ta-p/24213 Online server help documentation on required permissions for user used for workflow credentials - https://help.alteryx.com/server/current/admin/Configuration/RunasPermissions.htm .
View full article
We receive quite a few questions on how to properly chain workflows together. We have a few options that depend on what Alteryx type you are using.   If you have Designer only, your options are to use the Crew Macros which are found on the Community. No link provided as the tools get updated. Please use the Community search for the latest Crew Macros.   In the Crew Macros set, the tools that you will be looking to use are the Runner Tools. You can find a description of the tools here Runner Tools.     Note: You will have to create another workflow using these macros to execute the workflows.   If you have Designer with Scheduler, you can use the Crew Macros on the Scheduler, but they are not recommended or supported in this configuration. Using Runner Macros on an Alteryx Server or Gallery can risk over-utilization of resources and cause instability in an Alteryx Server or Gallery environment and thus Runner Macros are not supported on Alteryx Server. There are other options that will allow you to use the workflow on the Gallery or Scheduler.   When you have Scheduler or Server you have access to the Alteryx Engine Command. This will allow Alteryx to run workflows through the command line to execute additional workflows or programs. In most cases, the AlteryxEngineCmd.exe will be located in C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe.   Great, so what do I do with it?   In your Workflow Configuration window, you have a tab called Events. In that tab you can add a Run Command event. You can choose to run the command as:       In the Command: you can either browse to your AlteryxEngineCmd.exe or type in the location like so - C:\Program Files\Alteryx\bin\AlteryxEngineCmd.exe   In the Command Arguments [Optional]: You will add the location of the 2nd workflow along with the name of the workflow and file type. example: "C:\temp\NHL2.YXMD"   VERY IMPORTANT: Notice in the example above that we have quotations around the string. The reason for this is that the command has difficulty with spaces in the directory paths. By putting quotes around the string, this tells the command to essentially ignore the spaces. However, best practice is to not have spaces in your directory paths when using this command.   Sample:     Note: This method is a great method, but can be finicky. if you are running other command process or do not have admin access to the folders it can cause issues.    You have another option as well! You can turn your workflows into apps for either Gallery or Scheduler use and have them run consecutively.   When you drag an Interface Tool onto the canvas your workflow will automatically change to an App. If you don't want to use an Interface tool you can still change the workflow to an app to use the chained app option. Once you change the workflow to an app, you can use the Interface Designer window to chain the apps together.     Note: When creating chained workflows to use in the Scheduler and Gallery, the workflows and Assets for the workflow must be placed on the Server. Also, the Server will need to have access to any database connections, file directories, and input files.    Want to know more about the Interface Designer? Interface-Designer-Part-1    Want to schedule workflows to run consecutively? Check out this article - Scheduling-Workflows-Using-Event-Run-Command
View full article
Connection string password encryption FAQ   How are connection string passwords encrypted?    The passwords in Designer connection strings are encrypted with the Windows Crypto API libraries. The actual passwords are not stored. Encryption of the password is specific to the computer where the password was created; an encrypted password cannot be copied to other machines.   For the Gallery, the machine specific connection strings have hashed and salted passwords that are stored in the Mongo database. The connection string can be retrieved from an API call, except for the password.   Data source credentials are stored in the workflow XML and are encrypted using the Microsoft Data Protection API with a 25-character salt. For more information see: Windows Data Protection.   Please reference disaster recovery documentation regarding recovering server encryption keys for Gallery data connections   For In-DB File type connections, the hide option hashes the password, but it can be unhashed by other Designers. There are also options to Encrypt for Machine or Encrypt for User.
View full article
Restricting Gallery SSL protocols and cipher suites FAQ   How do I restrict SSL protocols and cipher suites used to access the Gallery?   Alteryx does not put restrictions on the SSL cipher suites that can be utilized to access the Gallery. With proper SSL configuration, you can restrict the protocols the Gallery server will accept via Schannel settings on the server. This is possible because Alteryx uses HTTP.sys on the Windows server to run the Gallery.   You can check the SSL protocols and cipher suites that are currently enabled on your web browser is by going to: https://www.ssllabs.com/ssltest/viewMyClient.html. This website also has sections to check other browser versions, vulnerabilities and Mixed Content Handling.   There is a free tool for administration of protocols, ciphers, hashes and key exchange algorithms on Windows. You can also reorder SSL protocols and cipher suites. The download is available at: https://www.nartac.com/Products/IISCrypto/. It includes a Best Practice button that is a good place to start, and further restrictions can be selected if needed.   To configure SSL and TLS settings directly in the registry keys, see Microsoft’s article: https://docs.microsoft.com/en-us/windows-server/security/tls/tls-registry-settings.   What if I just want to disable SSL 2.0/3.0?     If you are just interested in disabling SSL 2.0/3.0, Microsoft has an article on it as a security bulletin: https://docs.microsoft.com/en-us/security-updates/SecurityAdvisories/2015/3009008. Look for the Disable SSL 3.0 in Windows section.
View full article
Unknown error. SerializationException RequestID when adding workflow to a Collection   When trying to add a workflow to a Collection, or create a new Collection, the following error is observed:   Unknown error. SerializationException RequestID: xxxxxxx     This prevents the workflow from being added to a collection. Additionally, you may notice that when you click on a Collection you see a 'Page Not Found' error.   Environment   Alteryx Server 2019.2   Diagnosis   Confirm you have recently upgraded your Server from version 2019.1 or lower to version 2019.2.     Cause   In 2019.2, a new interface for Collections, as well as some additional functionality for Collections, was added to the Gallery. A hard refresh is needed for this to render properly and your Collections to appear.     Solution   On the home page of your Gallery, perform a hard refresh by clicking Shift + F5 Confirm you now see the new grid interface for collections:     Additional Resources   How To: Manage a Collection
View full article
The Alteryx Analytic Gallery   What is an Analytic Application? Pre-packaged data and analytic integration published to the Alteryx Analytics Gallery by Data Artisans to answer specific strategic analytics questions.   What is the Analytics Gallery? The Analytics Gallery is a publicly hosted web service where applications can be published, securely shared, and run in the cloud.   What is a Viewer? A Viewer is a free user of the Analytics Gallery. A Viewer can run all applications published in the Public Gallery.   What is a Member? A Member is a user who can run applications that are shared privately through Collections. A Membership is granted by a Data Artisan. A Member also shares the privileges of a Viewer to run all applications published in the Public Gallery.   What is a Data Artisan? A Data Artisan is a user who creates analytic applications using the Alteryx Designer Desktop and then shares them publicly and/or privately in the Analytics Gallery. A Data Artisan also shares the privileges of a Member.   What is required to run applications in the Public Gallery? Anyone can sign up and become a Viewer, with the ability to run all applications in the Public Gallery, for free. As soon as you confirm your email, you will have access to the Public Gallery.   What is required to run an application in a private Collection? You must be a Member to run applications shared in private Collections. Memberships are granted by Data Artisans, who create and share applications.   What is required to build applications? Applications are built with Alteryx Designer Desktop. Download the Designer Desktop Free Trial.   What is required to publish applications in the Analytics Gallery?  Applications are published from the Alteryx Designer Desktop into a private Studio.   A Studio is automatically created for license holders of the Designer Desktop.   Trial users of the Designer Desktop can set up a Studio with a 30-Day Studio Free Trial    A user with the Designer Desktop and a private Studio is known as a Data Artisan.   How do I run an application?   Click on the title of an application to view application details and click the Run button; or simply click the icon. Configure the application to suit your needs. Depending upon the application, you might be prompted to enter an address for geocoding, to input a customer file for demographic analysis, or to select data from a range of choices that apply to your business. Click the Run button at the bottom of the application.   What are the results of running an application? Applications can be authored to create a variety of different reports and data outputs. When the application processing finishes, the results will appear in the same window as the questions you answered before running the application.   Reports can be previewed after an application has completed by clicking on the Preview link.   Additionally, results for applications that have been run can be found in the application detail view and the "App Results" tab on the left of the screen.   What kinds of reports can an application create? Depending upon how the application was built, it may produce Word, Excel, HTML, and/ or PDF files, containing a variety of text, tables, charts, and maps.   What kinds of tabular and spatial data output can an application create? Depending upon how the application was built, it may produce CSV, MDB/ ACCDB, DBF, FlatFile, MID/ MIF, SHP, TAB, YXDB, and/or KML files.   I ran an application but I closed the window before it finished running. How can I view the results?  Application results are stored with your account and can be accessed at any time. As long as you are signed in, the results of any applications that have finished running can be found in two places:   Under the application details page for an application. Under "App Results" (visible on the left side of the screen when you are signed in).     How can I view more details about an application? Click on the name of an application to view details, such as the upload date, description, author, studio, copyright, and number of times run. The application details page also includes buttons enabling you to Run, Share, and (if enabled) Download the application.   What browsers are supported by the Analytics Gallery? We always test and support the latest versions of the most popular web browsers.  For more detail about specific browser versions see ‘System Requirements’ of the Technical Specifications page.      How can I find the applications I need?  Each section of the Analytics Gallery features a context-sensitive Search field you can use to find applications.   Searching in the Public Gallery returns applications in the Public Gallery. Searching in the Studio tab returns applications in your Studio. Searching in a Collection returns applications in the Collection. Additionally, a Collection created by you will offer a second search window, which allows you to find applications in your Studio and add them to your Collection   Publishing and Sharing Applications   What is a Studio? A Studio contains all of the applications published by the Data Artisans within an organization.   Who has access to the applications published in a Studio? All of the Data Artisans within an organization, and only those Data Artisans, can view and run any applications in their Studio.   How can I rename my Studio?   Click on your User Name to go to your Settings. Select the Studio Tab. Enter a new name in the Studio Name field. Click the save button.   How can an application be shared?   When an application is published in a Studio, all Data Artisans belonging to that Studio can access it. An application in a Studio can also be shared to the Public Gallery, where anyone can access it. An application in a Studio can also be shared in a Collection. Any users added to the Collection can access it.   As a Data Artisan, how can I share an application privately with someone?   Publish an application from the Designer Desktop to your private Studio. Add the application to a Collection. Add the User to the Collection. In order to run the application, the user must be a Member.   As a Data Artisan, how do I grant a Membership to someone?   Click on your User Name to go to your Settings. Select the Studio Tab. In the Members section, enter an Email address or User Name. As a Data Artisan, how can I tell how many Memberships I have to distribute?   Click on your User Name to go to your Settings. Select the Studio Tab. Find "Memberships available to distribute" in the Members section.   How can I purchase additional Memberships? Please contact Sales@Alteryx.com.   What applications can be added to a Collection? Only applications published in the Data Artisan's Studio may be added to a Collection. Applications in the Data Artisan's Studio may also (at their discretion) be shared in the Public Gallery. However, applications in the Public Gallery that were published from other Studios cannot be added to a Collection.   Can an application be added to more than one Collection? Yes.   As a Data Artisan, do I also need a Membership? No, Data Artisans are also Members.   I am a Data Artisan or Member. I want to run an application shared with me from a different organization. Do I need a Membership from that organization? No. A single Analytics Gallery Membership entitles you to run private applications shared from any Collection.   As a Data Artisan, how can I add another Data Artisan to my Studio? Please contact support@alteryx.com for assistance.   My organization has more than one Data Artisan. Who controls the distribution of Memberships? At present, all Data Artisans have equal access to Membership distribution under Studio Settings.   What types of users can be added to a Collection? Data Artisans, Members, and Viewers can all be added to a Collection. You can even enter the email address of someone who has not yet visited the Analytics Gallery.   Can a Viewer who is added to a Collection run the applications in the Collection? Only those applications in the Collection that have also been shared in the Public Gallery by the Data Artisan can be run by the Viewer.   What types of users can run private applications in a Collection? If an application in a Collection has not been shared in the Public Gallery, Viewers (who have been invited to join the Collection) can view the application, but cannot run it. Only Data Artisans and Members can run the application.   How can I find users to add to a Collection?  Select the Collection and use the Search Users field on the right. Any registered users of the Analytics Gallery that match your search terms will be returned.   Additionally, you can add someone who has not registered with the Alteryx Analytics Gallery by entering a valid email address. An invitation will be sent.   Is there a limit to the number of applications or users I can add to a Collection? No.   When I add a new application to a Collection, are the users in that Collection notified? Yes.   Can I allow users within my Collection to share it with others? Each Collection includes a checkbox on the upper right that states "Other users may share this collection." When this box is checked, anyone in the Collection will have the ability to add other users to the Collection.   The Data Artisan who created the Collection will see the names of any additional users who are added to the Collection, and can remove them.   I published an application and shared it in a Collection (or in the Public Gallery). Since then, I have made changes to the application in the Designer Desktop. Can I update it? First, select the original version and delete it. Next, re-publish the application and add it to your Collection (or to the Public Gallery)   How can I share an application in the Public Gallery?  Click on the name of an application to view the application details page. Click the Sharing button and choose "Place in Public Gallery."   How can I remove an application from the Public Gallery?  Click on the name of an application to view the application details page. Click the Sharing button and choose "Remove from Public Gallery."   How can I share an application through email or social media?  (Public Gallery applications only) Click on the name of an application to view the application details page. Click the Sharing button to share via email, Twitter, Facebook, and Google+.   Publishing Restrictions What is "private data?" A license of the Alteryx Designer Desktop may include a variety of private data sets, including demographic data, psychographic data, business list and consumer list.   Can I publish applications using private data? Yes, applications using private data can be published in your private Studio and can be shared in Collections. They cannot be shared in the Public Gallery.   What data is allowed in the Public Gallery? Please see Alteryx Analytics Gallery Data Inventory   What capabilities in the Designer Desktop cannot be used in the Analytics Gallery?  The following tools are prohibited in applications published in the Analytics Gallery.   Run Command tool Run Command event R tool (Macros included in the Designer Desktop that use the R tool are permitted.) Email tool Send Email event Download tool   I built an application that uses a prohibited tool in a safe manner. How can I apply for an exemption?   Email curator@alteryx.com and explain how and why each prohibited tool is used, along with the general purpose of the application. Publish the application in your Private Studio and check the box "Others may download this application." Add the application to a Collection and share it with curator@alteryx.com.   Your application will be reviewed and an exemption may be made to allow it to be run.   What tool configurations or question types cannot be used in the Analytics Gallery?   Input and output files referenced by Tools must be in the same directory as the application. The application Question type "Folder Browse" cannot be used in applications published to the web. In the application Question type "File Browse," the "Save As Dialog" configuration cannot be checked. Application results (under analytic application properties) cannot include Browse tools.   Are there limits to the file size of applications and/or data published in the Analytics Gallery? Yes, applications and data are limited to 100MB.   What are my options if I want to publish an application and data that exceed 100MB? Please use the Cloud Connector tools within the Designer Desktop to host your data on the cloud.   Are chained applications supported in the Analytics Gallery? At present, chained applications are not supported.   General Assistance I forgot my password. How can I reset it? Click Sign In and click the Forgot Password link. Enter the email address associated with your account and a new password will be emailed to you.   Can I download an application? Yes, many applications can be downloaded. View application details and click the Download button. Use the Alteryx Designer Desktop to open the *.YXZP files that are downloaded. Go to Designer Desktop Free Trial to get started if you're not already an Alteryx customer.   I need help with my account. Who should I contact? Please log a case at www.alteryx.com/community.   I want to change the email address associated with my account. Who should I contact?   First, go to gallery.alteryx.com and sign in with your current email. Confirm that you have accepted the licensing terms and conditons. Then log a case with www.alteryx.com/community and we will help you reassign your account.   I found a bug on the Analytics Gallery or in an application. Who should I contact? Please log a case at www.alteryx.com/community.   How can I purchase additional Memberships, Data Artisan accounts, or extend my subscription? Please contact Sales@alteryx.com.   How can I recommend a feature for the Analytics Gallery? Please send your feedback to GalleryFeedback@alteryx.com.   Where can I connect with other Alteryx users to ask questions and learn about best practices? www.alteryx.com/community   Who is the better captain, Kirk or Picard? Malcolm Reynolds
View full article
Schedules Disabled - Logon Failure the User has not been Granted the Requested Logon Type at this Computer   A change in Run As credentials or workflow credentials needed can lead to the user(s) loosing access to his workflows. When clicking on a workflow the below error appears.   Error: Logon failure: the user has not been granted the requested logon type at this computer. (1385)   Apps appear in state 'disabled'  When trying to access apps the above error message appears   Environment   Product - Alteryx Server with set up gallery environment   Cause   This error occurs when the Run As User credentials or the workflow credentials do not have sufficient permissions on the server. More specifically,   'Allow log on locally' or 'Log on as a batch job' group policy permission are required for the user to log onto the server. If neither is granted to user the above error appears.   Solution   Check that that Run As credentials are set correctly. Refer to Help doc page https://help.alteryx.com/server/current/admin/index.htm#Configuration/RunasPermissions.htm. Specifically,  'Allow log on locally' or 'Log on as a batch job' group policy permission are required.
View full article
How To: Modify Gallery Session Timeout   This article shows how to modify the session timeout for the Gallery.  A session timeout specifies the number of minutes that a Gallery session can remain idle (inactive) before the session will be terminated.  The default session timeout value is 60 minutes.  When the session timeout occurs the user will be returned to the Sign In page:       Note: This setting applies to Built-in or SAML authentication only.  When using Integrated Windows authentication Alteryx does not enforce a session timeout as the user has a valid Windows session.       Prerequisites   Alteryx Server Authentication Type:  Built-in or SAML   Procedure   If you have a multi-machine Server environment, the following steps should be performed on the Gallery node(s) only.   Open Windows File Explorer and navigate to %PROGRAMDATA%\Alteryx\. Create a backup of the RuntimeSettings.xml file.  Open the RuntimeSettings.xml file in an editor and add the following line in the Gallery section: <SessionTimeout>20</SessionTimeout> Example RuntimeSettings.xml file with a 20 minute session timeout. Save the file and restart the AlteryxService.      Additional Resources   Gallery System Settings
View full article
  With the 2019.2 release of Server, Collections functionality has been expanded to overcome some of their previous limitations. This article covers Collections functionality and permissioning.
View full article
Workflows have moved to a different Private Studio   This is a hidden feature designed to allow workflows to be moved between studios. It's a holdover from our Public Gallery which is the original base for Alteryx Server.   What happened Workflows disappeared from a Private Studio and are now in another one    Environment   Product - Alteryx Gallery All Versions     Cause The following conditions being met will result in the workflow moving.   Source studio = free Target studio = paid User is last one in source studio User is moved to target studio via access key (admin or user invoked) All workflows move with the user regardless of ownership   Defensive Measures There is no way to reverse the move of these workflows. The best defensive measure is to take regular backups of MongoDB, as restoring the database is the only way to revert the change.   Additional Resources   Alteryx Server Backup and Recovery: Part 1
View full article
How To Deactivate Users on Gallery (An Alternative to Deleting Users)   If Gallery Admins would like to rescind access for specific Users on a Gallery, two methods are recommended. Deleting Users from Gallery is not supported and there is no Admin option available to delete Users entirely. The options outlined below will deactivate or revoke access.   Prerequisites   Product - Alteryx Server   Procedure A: Built-In Gallery   1. Navigate to the Subscription page under the Gallery Admin portal -> Subscriptions. Add a new subscription, specific for Deactivated Users.     2.  Add the User to the subscription by click either the Add Artisan or Add Member button.   3. Navigate to the Users page under Gallery Admin portal -> Users. Change the role of the User to No Access. **To see the 2018.4 version layout, select the Profile Button on the User. To revoke access, switch the Active button to No.   Procedure B: Windows Authentication Gallery   1. Navigate to the Subscription page under the Gallery Admin portal -> Subscriptions. Add a new subscription, specific for Deactivated Users.   2. Add the User to the subscription by click either the Add Artisan or Add Member button.   3. Navigate to the Permissions page under Gallery Admin portal -> Permissions. Search for the User and choose No Access.
View full article
SAML (Security Assertion Markup Language) is a standardized way for exchanging authentication and authorization credentials between different parties. The most common use for SAML is in web browser single sign ons. Starting in 2018.2, Alteryx Server supports SAML. So far, SAML in Alteryx Server has been specifically validated on two providers; Ping One and Okta. In this article we will review how to configure SAML on your Alteryx Server for   PingOne.
View full article
Issue   The Alteryx Service is unable to start, and/or the Gallery fails to load in the browser.   The message Gallery Service failed to start in a timely fashion can be found in the Server's Service logs.   AlteryxService_LogStartupError: There was an error starting the Alteryx Service <Gallery Service failed to start in a timely fashion, exiting.>   Symptoms   Alteryx Service cannot start. Alteryx Gallery fails to load. Alteryx Service starts and then stops after a short time. The Service logs will have an error message of Gallery Service failed to start in a timely fashion. Alteryx Gallery starts and then disconnects after a short time. The Service logs will have an error message of Gallery Service failed to start in a timely fashion.   Causes   The Service is unable to ping the Gallery endpoint. This can happen for a variety of reasons.   The gallery URL is misconfigured. A proxy is intercepting communication between the Service and Gallery. Traffic is not being properly routed back to Gallery (e.g. machine is being a load balancer and traffic is not coming back to Gallery).   Diagnosis   Isolating a misconfigured gallery URL   The following base URL for Gallery can be configured as:   1. Basic   If this not working, please go to Solution C   2. Machine Name with Fully Qualified Domain Name (FQDN)   If (1) works and (2) does not, please go to Solution A   3. Domain Name System (DNS)   If (1) and (2) works and (3) does not, please go to Solution A   4. SSL Enabled (Compatible with all previous setups)   If (2) and (3) work, but (4) does not work, please go to Solution A   To identify which component is causing the issue, a general recommendation is to downgrade to setup (1) and move up in complication until the issue replicates.   Additionally, a common practice to isolate if the gallery is properly resolving to the correct IP address is to use “nslookup” and “ipconfig /all”. 1. Open a command prompt as administrator 2. Type "nslookup gallerywebsite.com"   C:\windows\system32>nslookup gallerywebsite.com **Do not include http:// or https:// The Domain Name Server and its IP address of the address that is provided (the gallery URL) will be listed 3. Type "ipconfig /all"   C:\windows\system32>ipconfig /all The Domain Server Name information and the IP address of the current machine will be listed.   If these do not match up, then this can be a source to begin troubleshooting.   Isolating a proxy   Generally, IT or the Server Admin will know if a proxy is being used on the Server. Check cURL environment variables are configured properly. Go to Solution B if a proxy is affecting your Gallery   Traffic is being properly routed back to Gallery ­Generally, IT or the Server Admin will know of any certain setups, such as load balancers, that can affect reroutes. Wireshark traces may be obtained to get more information. Please go to Solution A if your Gallery URL is being redirected   Solution A   Check with your IT to ensure that the Server can be recognized on the company’s network or that any third party entities are properly set up (DNS, SSL, etc.) *SSL Users* While we do not support or recommend any specific SSL cert software, please reference the Community article Configuring Alteryx Server for SSL: Obtaining and Installing for details on how to properly sign and bind a certificate to the Alteryx Server.   Solution B   Ensure that cURL environment variables are configured properly. Common variables to check that can be the source if the traffic goes to the proxy and does not come back are: http_proxy, https_proxy, all_proxy localhost can be affected if it is not set as a no_proxy exclusion To set environment variables please see this article.   Solution C   If any additional assistance is required, please open a ticket with Alteryx Support through the Case Portal.
View full article
SAML (Security Assertion Markup Language) is a standardized way for exchanging authentication and authorization credentials between different parties. The most common use for SAML is in web browser single sign ons. Starting in 2018.2, Alteryx Server supports SAML. So far, SAML in Alteryx Server has been specifically validated on two providers; Ping One and Okta. In this article we will review how to configure SAML on your Alteryx Server for  Okta.
View full article
Scheduling a workflow, application, or package on your company's Gallery allows you to automate a process at a given frequency, date, and/or time. Because your asset is running on a server machine, it will not matter if your computer is connected to a network, or even turned on. In this article, we will describe how to schedule a workflow on a private Gallery. 
View full article
The Alteryx Gallery can support custom reports in .rptx format.  If a workflow or app is uploaded to the gallery without taking the following steps, there will be an error stating that it can not find the .rptx file. The key is to make sure to save a copy of the .rptx file in the same location as the App so that the allocate report configuration is not lost. Then make sure to add the RPTX file as an asset attached to the Allocate Report tool before publishing to the gallery. To do this, first make sure that the Display Asset Management in Properties Window option is checked in Designer User Settings:     Now click on the Assets icon on the left side of the Allocate Report configuration window, and add RPTX file:   It is important to know that Custom VVFs are not supported in the Gallery. If there is a custom variable that you would like to include, it must be calculated inside the .RPTX file itself. Calculating a Variable inside an RPTX: Opening an RPTX in the Composer will display the code that drives the custom report by adding code similar to the following, a new variable can be calculated within the RPTX itself. <td align="Left" width="17%">My Variable </td>           <td align="Right" width="8%">             <all:app class="__format2" formula="(XCYFEM + XCYMALE)" />           </td>
View full article
Steps for troubleshooting the "unable to translate alias" error when uploading or running an app/workflow on Server.
View full article
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.
View full article