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 Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

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

Alekh
9 - Comet

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.

5 REPLIES 5
fmvizcaino
17 - Castor
17 - Castor

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
9 - Comet

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

jimroch
6 - Meteoroid

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

fmvizcaino
17 - Castor
17 - Castor

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
17 - Castor
17 - Castor

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