You are attempting to upgrade from an unsupported version" when upgrading to 2019.3

[SophiaF]

Issue: Error '"You are attempting to upgrade from an unsupported version" when upgrading to 2019.3'

During the upgrade of Alteryx Server to 2019.3, you may encounter the following error once you attempt the migration of the Mongo database:

You are attempting to upgrade from an unsupported version. Upgrade to Alteryx Server version 2018.1 or later to attempt to upgrade to your desired version, or contact Alteryx Customer Support for assistance.

Environment

• Alteryx Server 2018.1+
  • Embedded MongoDB

Diagnosis

If you are running a version pre 2018.1, please upgrade to version 2018.1+ before attempting to upgrade to 2019.3. Do not continue further in this article.

If you are in fact running version 2018.1 or newer, confirm that your database is version 3.4.10 with the following steps:

Check which storage engine you are running:

The first step is to identify which storage engine you are using. You can easily identify which storage engine is being used by reviewing the file system:

1. Open the Alteryx System Settings
2. Navigate to the Controller> Persistence page
3. Copy the Data Folderpath.
4. Open Windows Explorer (File Browser)
5. Paste the Data Folderpath copied in Step 3 in the Address Bar of Windows Explorer
6. If you see a series of "NS File" and "0 File" file types, as shown below, MongoDB is running using the MMAP storage engine.
7. If you see a series of "WT File" file types and a file named "WiredTiger", as shown below, MongoDB is running using the wiredTiger storage engine.

MMAP wiredTiger

Start the Mongo daemon:

1. Open command prompt as an Administrator

2. Change directories to the location of the Alteryxbin folder. The default location is "C:\Program Files\Alteryx\bin"

cd "C:\Program Files\Alteryx\bin\"

3. If you are using the wiredTiger storage engine, run the following command, replacing the dbpath location with your Data Folder path:

mongod3_4.exe --dbpath "C:\ProgramData\Alteryx\Service\Persistence\MongoDB_34" --port 27018

3b. If you are using the MMAP storage engine, run the following command, replacing the dbpath location with your Data Folder path:

mongod3_4.exe --dbpath "C:\ProgramData\Alteryx\Service\Persistence\MongoDB_34" --port 27018 --storageEngine mmapv1

4. You should see a message that says 'waiting for connections on port 27018'. Leave this window open and proceed with the next steps.

Connect to the Mongo shell:

1. Open another command prompt as an Administrator

2. Change directories to the location of the Alteryxbin folder.

cd "C:\Program Files\Alteryx\bin\"

3. Get the MongoDB password by running the following:

alteryxservice getemongopassword

Copy the Non-Admin password.

4. Run the following to connect to the Mongo shell:

-Enter the password from above after-p

mongo3_4 -u user -p YOUR_PASSWORD --host localhost:27018 AlteryxService

5. Run the following command to retrieve the version:

db.version()

If your version says3.4.10, see Solution below.

Cause

The ASMongoDBVersions.bin file contains the wrong version.

Solution

1. Confirm the AlteryxService is stopped

2. Navigate to the Data Folder path in Windows File Explorer. Locate the ASMongoDBVersions.bin file

3. Replace the content of the file with just the following, and Save:

3.4.10

Example of a corrected ASMongoDBVersions.bin file

3. Re-run theMongoDBUpgradeTo30.exe found in the Alteryx bin folder in the installation directory

4. You should now be presented with the following screen. Continue through the prompts to migrate the database.

5. If you run into issues with the migration, please see the article under Additional Resources below, or contact Alteryx Support

Additional Resources

• Troubleshooting a failed MongoDB migration - Server 2019.3