Issue

If an owner of a collection has been deleted from MongoDB, the Collections page in the Admin views shows a blank page and will not load.

Environment Details

• Alteryx Server 
  • Version 2023.1.1.123

Cause

The user who owns a collection was deleted or removed from MongoDB. It is also possible that the user's name was NULL when the profile was created or has become invalid.
 

Searching for the problematic collection

1. Press F12 to open Web development tools (In Chrome, it's called just Developer tools).
2. In the Web Developer tools, go to the Network tab.
3. Open Gallery Admin, then go to Collections. The Gallery UI will become blank.
4. Back in the Web Developer tools, you will see a list of API calls. Look for the GET request that opens the collections (/gallery/api/curator/collections/?v=1xxxxxxxxxxxxx)
5. Click Response (or Preview for Chrome)
6. Expand each of the Objects and look for the Owner field where the value is NULL.
7. Copy the value of the ID. See the screenshot below for further details.

Resolution

1. Locate the collection of the user who was deleted. By running the db.getCollection('collections').find({"CollectionId" : "CollectionID"}). The collection ID is the ID you found via Web Developer tools. For this example, we have db.getCollection('collections').find({"CollectionId" : "0d12fbfe6cd444a48e308fd7b905e0b3"}) 
2. Look for an active / valid user from the Users view on the Gallery Admin page and copy the ID as shown in the below screenshot
3. Go back to Robo3T, Right-click > Edit, and then replace the OwnerID with the ID above. See the below screenshot for reference.
4. Try refreshing the Collections page in the Gallery Admin view and it should now be able to load. Repeat the same procedure for other problematic collections with NULL owner.

Additional Resources

• Collections Admin pages stuck in loading status
• MongoDB Backups