Using Mongo DB Backup

My organization is setting up a UAT server so we can test for our upcoming upgrade from 21.2 to 21.3. I've run emongodump on our production gallery and moved it to our UAT environment. When I navigate to my emongodump folder in step 3 I get the "Settings Validation Error" posted below. Has anyone experienced this before? Should I select my mongodb_bkp_20220505 folder or do I need to browse to one of the sub folders?

MongoDB Backups | Alteryx Help

Use a MongoDB Backup

Open System Settings.
Go to Controller > Persistence.
In the Data Folder field, browse to the folder for the backup.
Select Next to continue through the System Settings windows and restart the service. When the service starts it will run off the restored folder.

Error

mongodb_bkp_20220505 is the backup from emongodumo

Settings

Server

MongoDB

Upgrades

Accepted answers

fmvizcaino

Hey @MattBenj ,

You cannot use the backup directly. You will need to restore that backup with the following command:

"C:\Program Files\Alteryx\bin\AlteryxService.exe" emongorestore=Z:\Path\MongoBackup,C:\ProgramData\Alteryx\Service\Persistence\MongoDB

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-and-Recovery-Part-2-Procedures/ta-p/22642

Best,

Fernando Vizcaino

All comments

fmvizcaino

Hey @MattBenj ,

You cannot use the backup directly. You will need to restore that backup with the following command:

"C:\Program Files\Alteryx\bin\AlteryxService.exe" emongorestore=Z:\Path\MongoBackup,C:\ProgramData\Alteryx\Service\Persistence\MongoDB

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Alteryx-Server-Backup-and-Recovery-Part-2-Procedures/ta-p/22642

Best,

Fernando Vizcaino

patrickmckenna88

hi @fmvizcaino

Thanks for your response, I experienced the same issue.

However, I'm getting an error when trying to run the emongorestore command. It says "Access is Denied"

I'm an admin of the server and of the Alteryx Server so not sure what the issue could be.

Thank you!

Patrick

Capture.PNG

fmvizcaino

Hi @patrickmckenna88 ,

My best bet is that you are not opening CMD as an admin. You have to always do that even when you are a server admin.

Best,

Fernando Vizcaino

patrickmckenna88

hi @fmvizcaino I just tried that again and got the same error, also got this pop up if that helps?

I'm trying to import a backup of a prod server into a new sandbox that I just set up if that helps too.

Thanks!

Capture2.PNG

fmvizcaino

My second best bet is that your AlteryxService is still running. 😅

I`m glad you mentioned that. You are doing a process called host recovery and you have to perform some other steps, especially the one to remove the MongoDB locks.

https://help.alteryx.com/20231/server/server-host-recovery-guide

Best,

Fernando Vizcaino

patrickmckenna88

hi @fmvizcaino Thanks so much for that! I'm attempting to perform those steps now but have hit a snag at step 7. For reference, I'm trying to duplicate our production 2021.3 Server in the sandbox so that I can test our performing an upgrade to 2022.3. https://help.alteryx.com/20213/server/server-host-recovery-guide

I checked that the AlteryxService is stopped and am running the command prompts as an admin. This is the message:

C:\Users\AdminPM>"D:\Alteryx Sandbox\bin\AlteryxService.exe"setserversecret={...}
'"D:\Alteryx Sandbox\bin\AlteryxService.exe"setserversecret' is not recognized as an internal or external command,
operable program or batch file.

Instructions state:

Set the Controller token to the value from the original Server.
Note: Running this command will update the <StorageKeysEncrypted> value in the RuntimeSettings.xml file on the target machine.
Command: AlteryxService.exe setserversecret={ControllerTokenValue}

Not sure if it's an issue I should address now or once all the steps are complete, but I wasn't able to start the AlteryxService up again when I was trying to repeat the process.

Thanks in advance for any guidance!

Patrick

fmvizcaino

Hey @patrickmckenna88 ,

I believe you are missing a whitespace in the middle.

"D:\Alteryx Sandbox\bin\AlteryxService.exe" setserversecret={...}

Best,

Fernando Vizcaino

patrickmckenna88

@fmvizcaino Ah thanks! Do you know if I'm supposed to receive some sort of confirmation message after hitting enter? This time it just started a new command line with no message.

fmvizcaino

Good question, I don`t remember. But if you haven`t got an error message, you are good.

patrickmckenna88

@fmvizcaino thanks again for your help! Unfortunately, I hit another snag with the mongo restore but figured it warranted a separate post if you have a couple spare minutes and wouldn't mind taking a peek Emongorestore function not working/responding when... - Alteryx Community

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703