Gallery Restore to Development

[epilady]

My company is preparing to test the 2020.2 upgrade.  In order to test our production workflows, we are taking a back-up of the production gallery and want to restore it to our development server. Have any of you done this? I am trying to anticipate configuration issues that may arise.

[Loic]

I would simply do a backup and restore.

backup existing server:

https://help.alteryx.com/current/server/mongodb-backups

Install server on a new machine (dev) then do a restore from the previous backup:

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

You might want to disable / stop all scheduled or they will run twice in dev and prod (except if prod is shut down).

You will have to give the new gallery URL to users being part of the test.

ensure that all databases drivers are installed on the new server as well as DNS for ODBC etc

[epilady]

The development environment already exist. We want to restore the gallery and test in our current version to eliminate any issues, then upgrade the server and retest our workflows in the new version. Our Risk Team has critical monthly processing that is required to be completely vetted including comparing the results to the production version. I don't have a handle on whether the production configuration is included in the backup, like the Mongo password

Kelly Epley
[cid:image001.png@01D21EFF.159166B0]
Masters in Business Intelligence and Analytics
Certified Data Science and Business Analytics
Senior Data Analyst | ETS - Information Engineering |[Description: cid:image001.jpg@01CAC9B7.4CE38DE0] W & R Corporate LLC
* (913) 236-1699 | Fax: (913) 236-1556 | * 6301 Glenwood, Overland Park, KS 66202

This email is intended to be reviewed by only the intended recipient and may contain information that is privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any review, use, dissemination, disclosure or copying of this email and its attachments, if any, is strictly prohibited. If you have received this email in error, please immediately notify the sender by return email and delete this email from your system.

[Loic]

if you follow this:

1- backup existing server:

https://help.alteryx.com/current/server/mongodb-backups

2- Do a restore from the previous backup on another server:

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

In particular you will need the original settings file from the existing server:

RuntimeSettings.xml from the original server found here: %PROGRAMDATA%\Alteryx\RuntimeSettings.xml.

[epilady]

I have completed the restore and the objects look good on the host server.  I am having two issues.  I am unable to save a new workflow to the Gallery, seems to be stuck validating the other when using the gallery URL, chrome spins trying to load the home page

[epilady]

I got chrome working, however the problem of saving a workflow still remains