Issues to upgrade Alteryx Server version 2019 to 2020

hbustavino30

Hello,

A few weeks ago we tried to update our version of alteryx server 2019.3 to 2020.2 but we had several issues:

1. Some workflows were published successfully but did not appear in the private studio.
2. Most of the collections were corrupt and could not be accessed.
3. Users with permissions to share collections could not see the option.
4. Users with viewer role lost access to the gallery and we couldn't change them to member because they disappeared from users.
5. Authentication error when trying to enter the gallery. We use Windows authentication.
6. In the private studio the images of the workflows were not seen.

We contacted support but we could only resolve point 1 by indexing mongo.

Then we follow a step by step that we found in the community renaming the UserIdentitys table (removing the S) but it did not work either, in the end we did rollback

Please let me know if anyone had these issues and was able to resolve them.

Thank you very much in advance.

Best Regards.

joshuaburkhow

My guess from the looks of it is that you had a bad upgrade where the mongo didn't get fully upgraded. Did you look at the versions table to make sure that the schema version was updated to 28 per this: https://help.alteryx.com/current/server/mongodb-schema-reference