Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Windows Authentication error after upgrade from 2019.3 to 2020.1 version

Highlighted
7 - Meteor

2020.2 Major released , is this issue fixed in latest version?

Highlighted
Moderator
Moderator

Hi @Yongcan!

 

This was fixed in our stable release of 2020.1, which is 2020.1.6, as well as in 2020.2.

Highlighted
7 - Meteor

I upgraded over the weekend, and also experienced this problem.  We were able to resolve.  The problem is the WindowsIdentity collection on a user's profile is somehow getting removed on initial login after the upgrade.  We found that restoring the WindowsIdentity collection values directly in the MongoDb corrects the issue.  Here are the steps:

 

  1. Open a command prompt on a server that can connect to your Mongo Db
  2. Execute command: cd C:\Program Files\Alteryx\bin
  3. Execute command: mongo <Mongo Db server name>:<Mongo Db port number>/AlteryxGallery -u <username> -p <password>
  4. Execute command: db.users.find({"Email":"<email address of affected user>"}).pretty() - Use this result to confirm the WindowsIdentity collection is NULL
  5. Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.Sid":"<Sid of affected user>"}})
  6. Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.DisplayName":"<display name of affected user>"}})
  7. Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.Name":"<name of affected user; this comes from windowsIdentitys.Name field>"}})
  8. Execute command: db.users.update({"Email":"<email address of affected user>"}, {$set: {"WindowsIdentity.SamAccountName":"<SamAccountName of affected user>"}})
  9. Execute command: db.users.find({"Email":"<email address of affected user>"}).pretty() - Use this to confirm the WindowsIdentity collection is populated.

I would recommend contacting Alteryx Support to confirm where to get these values.