Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Knowledge Base

Definitive answers from Server experts.

Users added to Server's Gallery not showing up in user list for the Administrator

d_vansell
Alteryx
Alteryx
Created

Users added to Server's Gallery not showing up in user list for the Administrator

 

There are a couple of potential causes for users not to show up for the administrator in the Gallery.   The first is, depending on the authentication type, it could be as simple as the user has not logged in.   The second, and more complex, is that there is information in MongoDB that is not aligning correctly, and the DB needs to be reindexed.  This article will take you through what you can quickly test for the first option and, if that proves false, then help you gather what you need before contacting Alteryx Support.
 

Prerequisites

 
  • Alteryx Server
    • Any Version
  • Alteryx Designer
    • Any Version
  • Must be done from your Controller
 

Procedure

 
  1. Open System Settings from Designer. Click on Options > Advanced Options > System Settings.

image.pngimage.png

  1. We next want to check our Gallery's Authentication.
    1. Click on Next until 'Authentication' is highlighted on the left column.

image.pngimage.png

  1. Check what option is selected for the Authentication Type:

              image.pngimage.png

  • If it is one of the Integrated Windows authentications, then more than likely, the user has never logged into the Gallery. Check back and have the user log into the Gallery.
  • If Built-in or SAML, or the user has logged in but is still not showing up, a Re-indexing of the MongoDB needs to be done.  For this, you will need Alteryx Support to walk you through the reindexing process.   But you can have some information for the technician before contacting them.
 

Prepping for your support ticket

 

Support will need some information, and you will need to do some prep before contacting them.  We will need to see the locks showing in the database.

  1. From your Server machine, support will need you to download and run the following workflow attached at the bottom of the article called: Check_MongoDB_Locks
  2. Copy the non-admin password for MongoDB, as seen in the screenshot below.  Paste that password into each MongoDB Input tool in the Password field.  Do this for all three tools MongoDB Input Tools, then run the workflow.  This can be done by:
    1. Open System Settings from Designer. Click on Options > Advanced Options > System Settings.
    2. Click on Next until 'Persistence' under Controller is highlighted.
    3. You will need to click on the eye next to the 'Password' and copy the password.

image.pngimage.png

  1. Once you have the password, go back to the workflow. You will need to add the password to all three of the 'MongoDB Input' tools on the workflow:
    1. Left Click on the MongoDB Input tool

image.pngimage.png

  1. In the tool's configuration window, paste the password from 'Step 3' into the window and leave the rest of the settings alone.
image.pngimage.png 
  1. Repeat this step for the rest of the 'MongoDB Input' tools
  1. Run the workflow - The red '!' points should disappear, and the workflow should go through - If it errors, then go back and check and make sure you copied and pasted the correct password.  Also, remember this workflow needs to be run from the Designer on the Server machine - Do not run it through the scheduler.   It will not work correctly.
  2. At the bottom, you will see the results for the workflow - It may create three files depending on what the workflow finds.
  3. If it says, '0 records were written to…' then a file was not created. If it says, '# records were written to…' then files were created. Go to the folder and save them for your ticket.

image.pngimage.png

Once you have completed these steps, then you are ready to create your support ticket. You will also want to read Backing up your MongoDB is necessary before the reindexing process can be done.  Support will walk you through the process of reindexing.

If you need to contact Alteryx Support, you can go to our Support page.  Scroll down and click on the 'Submit a Case' box to start the process under' Contact Us.'



Additional Resources

 
Attachments