Can't view profile or change role of user in Alteryx Gallery

[Alekh]

I am running Alteryx Server 2020.4. I changed the Run As user in Alteryx System Settings to a new account. We are currently using Windows Authentication as Authentication Type. When I'm in Alteryx Gallery, I can't view the profile of this new account, it just shows up as loading or blank. I also can't change the role of this user, it will just say 'Failed to change role'. Any ideas on how to fix this? I want to remove the old run as user as the curator and change to the new one. It has a valid windows account so not sure why it's not working.

[fmvizcaino · Accepted solution]

Hi @Alekh ,

Something similar happened to me once and it was related to the AD user. 

The IT department created an user without the last name and Alteryx has that as an obrigatory field.

We needed to go inside the mongoDB to update the user registration. Another suggestion was to update the user's last name.

Best,

Fernando Vizcaino 

[Alekh]

Perfect! Updated the Mongo DB and it worked as expected. Thank you

[jimroch]

Having a similar issue.  Would it be possible to post the steps needed to update MongoDB?  Not very familiar with Mongodb.

[fmvizcaino]

Hey @jimroch ,

The whole process was done by Alteryx support, but the idea is for you to go to the users collection and find the user with problem. Here is the mongoDB schema, you can see the user table and the variable you need to update.

https://help.alteryx.com/20211/server/alteryxgallery-mongodb-schema

You can access the mongodb and also update it with the mongoDB connectors. Take a look specifically on the update option in the output tool.

https://help.alteryx.com/20213/designer/mongodb-input-tool

https://help.alteryx.com/20213/designer/mongodb-output-tool

I would suggest you backing up your mongoDB prior to that change, just in case.

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-and-Recovery-Pa...

Best,

Fernando Vizcaino

I would suggest you backing up your mongoDB prior to that change, just in case.

Best,

[fmvizcaino]

Hey @jimroch ,

Here is a tutorial for that specific problem.

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-to-Identify-and-Fix-Null-Incorrec...

Best,

Fernando Vizcaino