We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Server Knowledge Base

Definitive answers from Server experts.

How to Run Pre-Upgrade Checks When Gallery Won't Start

EdP
Alteryx
Alteryx
Created

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