This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How to Identify and Fix Null/Incorrect values in Users collection
When upgrading to an Alteryx Server version 2020.1 or later, users can run into issues during or after upgrade if they have specific items in MongoDB (AlteryxGallery.users) that contain nulls. This article explains how to correct these null values.
If you have already run the Pre-Upgrade Check application (found here) and have the PDF report, go straight to the "Update Users" section for steps on how to correct the identified users. Please refer to the article above if you would like to run an Alteryx application to check these values, rather than the MongoDB queries below.
You can paste these into the grey box and press the green Play button to execute them:
If no results are returned, no nulls were found and no updates need to be made.
If results are returned, you will see all the users that need to be updated. See the section below.
If you need to identify how many users are found, add .count() to the end of the query:
Update Users via Gallery
As much as possible, you should make edits from the Users page in Gallery > Admin > Users.If you run into issues making the changes via the Gallery, advanced users can make the edits directly in the database by following the steps below. If you would like assistance with the manual database edits, please contact Alteryx Support.
To locate the users in the Gallery so you can make the necessary edits:
Copy the alphanumeric ID value returned from the query. The id is the highlighted part below:
If you have the PDF output of the Pre-Check application, you can copy the Mongo ID from the "MongoID Query" field. It will also look like the example above.
Navigate to the Gallery Admin section > Users in a browser.
Paste the value into the search box.
Click on the user and make the necessary updates.
Repeat for all users returned by the report/query.
Update Users directly in the database (Advanced)
PLEASE NOTE: Making direct edits to the database is only for advanced usage. You must have adatabase backupin place prior to making any changes.
Right-click each document (identified from above) and click Edit Document...
If you have the output of the Pre-Check workflow, you can copy the Mongo ID query from the PDF. You can paste these into the grey box and press the green Play button to execute them:
Enter the appropriate values
***Please note***: these are key-value pairs. The Key is case-sensitive, and values must be entered as their corresponding types. If you would like assistance with the manual database edits, please contact Alteryx Support .