Alteryx Server Knowledge Base

Alteryx_KB · ‎08-09-2021

How to Fix Users with Duplicate Email Addresses

Alteryx Server enforces that users must have unique email addresses. In rare circumstances, if duplicate email values are created, Alteryx Server will fail to upgrade to version 2021.2+. This article provides steps on how to identify the duplicates and correct these values prior to upgrade.

Environment

Alteryx Server
- All versions, but these checks are specifically impactful for checking prior to upgrading to 2021.2+
- Windows Authentication
Robo 3T (optional)

Identifying Duplicate Email Addresses

Option A - Identify via Alteryx Application

Read the instructions on this article to run an Alteryx Application that will check users' email address and other values in your Server's MongoDB database.
This application will also attempt to identify which of the users is the duplicate user, in the event that your Gallery Administrator is not able to determine which user is the duplicate.
Once you have identified the users with duplicate emails, see the "Fix Duplicate Email Addresses" section below.

Options B - Identify via Mongo Query (Advanced)

Connect to the AlteryxGallery database using Robo 3T (instructions found here )
Run the following query:

db.getCollection("users").aggregate([{ "$group" : { "_id" : "$Email","count" : {"$sum" : 1.0}}},{ "$match" : { "count" : { "$gt" : 1.0}}}],{"allowDiskUse" : false})

Fix Duplicate Email Addresses

Once you have identified the users that have duplicate email addresses (if any) your Gallery Administrator must complete the following steps:

Log into the Gallery > Admin section.
Navigate to the Users page, and locate the user with the duplicate email address.
On that user's profile, update the email address to a unique email.
Click Save.

If you have already attempted the upgrade and it did not complete successfully due to these duplicate users, please contact Alteryx Support.