When to use this article

If the Mongo DB schema fails to migrate to the proper version during a Server Upgrade, the Mongo database is stuck in an in-between state and the Gallery won't start. The most likely issues that block the schema from updating can be identified by the Pre-Upgrade Checks workflow.

The procedures below allow you to run the Pre-Upgrade Checks workflow without the Gallery functioning by manually start the Mongo database.

Procedures

1) Open a Command Prompt As Administrator

2) Start Mongo directly in the Command Prompt with the single-line command below.  Adjust paths to mongod.exe and to the persistence folder set by Alteryx System Settings > Controller > Persistence > Data Folder

"C:\Program Files\Alteryx\bin\mongod.exe" --dbpath "C:\ProgramData\Alteryx\Service\Persistence\MongoDB" --port 27018 --bind_ip_all --auth

When mongo starts successfully you will be left inside Mongo's command-line interface and the last line displayed will be:

2022-03-26T19:59:12.762+0000 I NETWORK  [initandlisten] waiting for connections on port 27018

3) Run Pre-Check workflow in Designer

Alteryx Server Pre-Upgrade Checks (795237)

4) Fix any issues identified in the Pre-Upgrade checks in Robo-3T

https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/How-to-Login-to-Robo-3T/ta-p/601025

5) Run Pre-Check workflow again to ensure all issues are resolved

6) Stop Mongo in Command Prompt

ctrl-c
close the Command Prompt

7) Start Alteryx Service

8) Confirm that the Mongo DB Schema migration completed and the Gallery is accessible.