04-25-2020 07:51 AM - edited 07-09-2021 11:56 AM
Error: An unknown error occurred during authentication with your Windows credentials.
"‹AlteryxDir›\AlteryxService.exe" emongorestore=‹path to backup location›,‹path to restore to›Might be entered as
"C:\Program Files\Alteryx\bin\AlteryxService.exe" emongorestore= "C:\Alteryx Backups",C:\ProgramData\Alteryx\Service\Persistence\MongoDBThese steps are specifically for Alteryx Server Version 2020.1.5.
"‹AlteryxDir›\AlteryxService.exe" emongorestore=‹path to backup location›,‹path to restore to›
"‹AlteryxDir›\mongod.exe" --dbpath "‹path restored to›"
"‹AlteryxDir›\mongo.exe" AlteryxGallery
db.windowsIdentitys.renameCollection("windowsIdentity")
db.getCollectionNames()
By restoring this, will we lose any workflows published since the upgrade? We've had to temporarily disable windows signon, to keep our team working. It looks like this fix will wipe their work, is there an upcoming workaround that will allow them to keep their work?
Thanks - Chris
We attempted to upgrade to 2020.2 and ran into the same issue
Alteryx Support assisted us with the upgrade of Alteryx Server from 2019.4 over to 2020.1.5 by following the steps mentioned above. Can someone confirm if we are supposed to follow the same steps again before upgrading from 2020.1.5 to 2020.2?
Thanks!
@shnair
In theory, yes, you should be fine. You'll notice I used weasel words. Just in case there are issues,
If any of these looks like it's going to be an issue, you can either try it on your own, and if it doesn't work roll back AND restore the backed up database, or contact Support and explain your concerns. (As always, include descriptions and screen shots liberally, and be sure to indicate what version you have and what version you're upgrading to.)
Less related to an upgrade, however Alteryx support helped resolve this error message so I wanted to share the fix.
Below suggestion requires both admin permissions and MongoDB access. Be cautious and back up your MongoDB before making any major changes. The change mentioned below is not a major change, however be cautious with production applications.
From Alteryx Server (admin permissions needed):
*Note the Alteryx user profile will have both the userName and user.email needed for below commands
If the sid from wmic is different, then right click the current sid to edit document and update with new value from wmic. Validate and save.
If the sid is not different, then there might be another issue where Alteryx support can assist.