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.
Additional Resources
