Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Migrate Test server setup to Prod Server

jensroy
9 - Comet

Hello,

 

I am looking for insights on the most effective way to take ALL content and structures that are set up in our TEST server over to our PROD server.

Meaning:

All workflows

All analytical apps

All macros

All schedules

All districts

All collections

 

As well as everything that is custimized in the admin section.

 

This should all be stored in the mongoDB instance i suppose. Can I backup the server and restore it to prod?

If not, can I run any scripts to do this job?

If not, can I copy all Alteryx folders from TEST and replace the ones in PROD?

Or any other way to do this in bulk?

13 REPLIES 13
kamanivk
8 - Asteroid

@lepome 

Server Version: 2018.4.6

I took a backup and trying to restore to the same server.

I am able to complete all steps until step # 3.

 

3. Connect to the MongoDB database using the command and connection string below.

 

Command: mongo mongodb://{server}:{port}/{galleryDatabase} -u user -p {Non-Admin Password}
Example: mongo mongodb://localhost:27018/AlteryxGallery -u user -p CCEC********************************33C0

 

I get the following error when I execute the  command.

 

MongoDB shell version v3.4.10-62-g960c883
connecting to: mongodb://localhost:27018/AlteryxGallery
2020-11-08T07:27:25.269-0800 W NETWORK [thread1] Failed to connect to 127.0.0.1:27018, in(checking socket for error after poll), reason: No connection could be made because the target machine actively refused it.
2020-11-08T07:27:25.273-0800 E QUERY [thread1] Error: couldn't connect to server localhost:27018, connection attempt failed :
connect@src/mongo/shell/mongo.js:240:13
@(connect):1:6
exception: connect failed

 

How to resolve this?

 

Thank you.

raychase
11 - Bolide

Have you tried adding the parameter --bind_ip_all to the MongoDB startup command?

kamanivk
8 - Asteroid

@raychase 

I tried the steps in https://help.alteryx.com/current/server/server-host-recovery-guide#restore-mongodb-database.

At step # 5, I get the following error.

In the second command prompt, connect to the MongoDB database using the command and connection string below. 
Commandmongo mongodb://{server}:{port}/{galleryDatabase} -u user -p {Non-Admin Password}

 

C:\Program Files\Alteryx\bin>mongo mongodb://localhost:27018/AlteryxGallery -u user -p 4E8...............................14
MongoDB shell version v3.4.10-62-g960c883
connecting to: mongodb://localhost:27018/AlteryxGallery
MongoDB server version: 3.4.10-62-g960c883
2020-11-10T16:11:27.034-0800 E QUERY [thread1] Error: Authentication failed. :
DB.prototype._authOrThrow@src/mongo/shell/db.js:1461:20
@(auth):6:1
@(auth):1:2
exception: login failed

 

How to resolve this?

 

Thank you.

raychase
11 - Bolide

Try adding the bind_ip_all to the startup command from step 3, such as:

 

mongod –dbpath ”D:\ProgramData\Alteryx\Service\Persistence\MongoDB_Restore” –auth –port 27018 –bind_ip_all

 

Then try connecting using step 5.