Windows Authentication error after upgrade from 2019.3 to 2020.1 version

Hi,

I need urgent support in fixing authentication error in alteryx gallery. I upgraded alteryx server from 2019.3 to 2020.1. After upgrade, when I try to log in to gallery, I received following error. I selected windows integrated authentication in configuration. Can someone please help us to fix this error?

Gallery

Upgrades

Accepted answers

joeGade

The same thing for me, I am not sure how Alteryx Released without Testing this Basic Feature . We Had to Rollback to 2019.4 version.

We spent a lot of Time Debugging thinking it's our AD issue.

@Community_Admin Please Take a look at this issue.

All comments

robert_derubeis

I did the same upgrade and I am getting the exact same error! Can someone please help ASAP?

RoelEsselink

How did you fix this?

prashantkunjir

Were anyone able to fix this issue? Alteryx support - Do you have solution to this please?

prashantkunjir

There is a bug in product and Alteryx is planning to fix this this month but there is no workaround. We just have to wait for fix to be released.

joeGade

Same issue . We upgraded from 2019.1 to 2020.1 ad with AD Authentication .

JamesHa

@BharathVJ, @joeGade and all,

Apologies that you are experiencing this issue. Please roll back to your previous version you upgraded from and restore the db. If you need help with downgrading and restoring the database, please email us at support@alteryx.com. Development has isolated the issue and we have a workaround that requires robo3t or equivalent software. Please reach out to support@alteryx.com and we can assist if you would still like to complete the upgrade to 2020.1 after downgrading.

Thank you

joeGade

@JamesHa Also When we upgrade from 2019.1 or 2019.* to 2020.1 The icons on the Gallery for every workflow is missing.

When we roll back it's working okay .so its upgrade issue.

When Changing the Authentication from AD to SAML some time it works some times it won't. (On POC to switch Authentication)

prashantkunjir

Hi James,

We are still getting the same issue even after this workaround. Alteryx support contacted us, made the change, upgraded to 2020.1.5 and still the login issue is as is.

For other users who are facing this issue, as per Alteryx "WindowsIdentitys" collection name is used as "WindowsIdentity" in 2020.1 which is why it is giving this error.

Thanks,

Prashant

rej

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:

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703