Upgrade from 2020.2

Version:
Current
Last modified: January 05, 2021

This article walks you through the steps to upgrade Analytics Hub from 2020.2. Steps to upgrade from 2020.2.1 are in the Upgrade from 2020.2.1 article. Only follow these steps if you are upgrading. For the initial installation, see the Install and Configure article.

Before You Upgrade
  • Make sure that there are no users currently using the platform or schedules running. 
  • Make sure you know the username and password for the Platform Admin that was created during the initial installation.
  • Make sure you know the username and password for your database. This is the same username and password that was created for the Postgres admin during the initial installation of Analytics Hub.
  • LDAPS:// is not checking for certificates in 2020.2. If you're using LDAPS://, make sure to have a local (non-LDAP) Platform Admin account set up before you upgrade in case LDAP authentication fails after upgrade due to the cert issue. 
  • (Optional) Do a full backup. See the Back Up and Restore article. 
  • In 2020.2, Port is an optional parameter when creating a data source. In 2020.4. it’s a mandatory parameter (default port is set if field is left blank). To prevent a Data Catalog error after upgrade, check all data sources used for sync operation on each site for a Port value. To do so, go to Data Sources and select a data source to open the details page. If any of your data sources are missing the port information (or was missing during the time of sync operation), we recommend you delete all Data Catalog assets loaded by that data source. Adding the port now does not prevent the error. If an error displays after upgrade (Request failed with status code 400), contact support@alteryx.com for an SQL script to run on your Postgres database.Screenshot showing Data Source details page with Port highlighted

Analytics Hub 2020.4+ no longer supports saving Analytics Hub files in a Postgres database. All AAH files are now saved to your machine’s file system. Before you upgrade to 2020.4, back up your Postgres data folder (default location: INSTALL_LOCATION\Alteryx Analytics Hub\Postgres\data). To do so, follow steps 4, 5, and 6 or your own method. 

AAH will migrate your Postgres files to the machine's file system during the first run after upgrading. This can take a while depending on your database size. For a successful migration, have 3 times as much free space on your hard drive as the size of your Postgres folder.

Troubleshooting

If the system runs out of free space, it will restart. Check the logs located in INSTALL_LOCATION\Alteryx Analytics Hub\Backend\analytics-hub-server.log. If you see the message “info: performing migration 0004_db,” stop the AAHBackend service and increase free hard drive space. Then, restart the AAHBackend service. Migration should resume automatically.

 

Download the Installer

Download the Analytics Hub installer from the Alteryx Downloads and Licenses portal. Follow these steps:

  1. Go to the Alteryx Downloads and Licenses portal at licenses.alteryx.com.
  2. Sign in or select Don’t have an account? Create one now. If you’re creating a new account, register with the email address associated with your Alteryx License.
  3. Under Product Downloads, select Alteryx Analytics Hub.
  4. On the Download Products page, select the version of the product you want to download. The latest version is available on the New Versions tab. Access previous versions on the Previous Versions tab.
  5. To download the file, select the link for Analytics Hub in the File Name column.
Before You Install

Follow these steps to back up some of your files. If you’d like to do a full backup, see the Back Up and Restore article. 

  1. Open File Explorer.
  2. Copy the following files to a safe location:
    1. SslCertificates folder (Default Location: C:\Program Files\Alteryx)
    2. CutlassSettings.yml (Default Location: C:\Program Files\Alteryx\Alteryx Analytics Hub)
    3. Settings.yml (Default Location: C:\Program Files\Alteryx\Alteryx Analytics Hub)
  3. Move vfs folder (Default Location: C:\Program Files\Alteryx) to a safe location.
  4. Open Windows Command Prompt and select Run as administrator.
  5. Use this xcopy command to back up your Postgres folder:
    xcopy "<InstallLocation>\Alteryx Analytics Hub\Postgres\data" "C:\moved\data" /O /X /E /H /K
  6. When prompted Does C:\moved\data specify a file name or directory name on the target (F = file, D = directory), select D on your keyboard to create a directory.
  7. Open regedit (Windows Registry Editor).
  8. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Alteryx Inc.\Alteryx Analytics Hub\HubInstallKey.
  9. Double-click InstallKey and copy the key in the Value Data field. Save the key as a text file in a safe location.
  10. Uninstall Analytics Hub:
    1. In Windows, go to Settings > Apps & features
    2. Find Alteryx Analytics Hub and select Uninstall
    3. When the Alteryx Analytics Hub window opens, select Uninstall.
    4. Select Finish. 
  11. Some files remain after uninstalling. Open File Explorer. 
  12. Go to <InstallLocation>
  13. Delete everything in the <InstallLocation> folder except for the Alteryx Analytics Hub folder (Default Location: C:\Program Files\Alteryx). Delete everything inside the Alteryx Analytics Hub folder. Note that this removes Alteryx Intelligence Suite, YXI tools, and Predictive and R tools.
  14. Return the files you copied to the original locations:
    1. SslCertificates folder (Default Location: C:\Program Files\Alteryx)
    2. CutlassSettings.yml (Default Location: C:\Program Files\Alteryx\Alteryx Analytics Hub)
    3. Settings.yml (Default Location: C:\Program Files\Alteryx\Alteryx Analytics Hub)
Install
  1. Run the Analytics Hub installer as an administrator. 
  2. Enter the installation path where Analytics Hub was previously installed (Default Location: C:\Program Files\Alteryx).
  3. Select Next.
  4. Enter the Username and Password for your database. This is the same username and password that you created for the Postgres admin during the initial installation of Analytics Hub.
  5. Select Next.
  6. Enter the same credentials that you used for your original Platform Admin.
  7. Select Next.
  8. Select Finish.
After Installation
  1. Open Services and stop these services:
    1.  AAHBackend 
    2. AAHFrontend 
    3. Alteryx Engine Worker
    4. Alteryx License Service
    5. AlteryxPostgreSql
  2. Open regedit (Windows Registry Editor).
  3. Go to HKEY_LOCAL_MACHINE\SOFTWARE\Alteryx Inc.\Alteryx Analytics Hub\HubInstallKey and replace the value of InstallKey with the key you saved.
  4. Return the vfs folder you moved before uninstalling to the Alteryx folder (Default Location: C:\Program Files\Alteryx).
  5. Open Windows Command Prompt and select Run as administrator.
  6. Use this xcopy command to copy your Postgres data folder back:
    xcopy "C:\moved\data" "<InstallLocation>\Alteryx Analytics Hub\Postgres\data" /O /X /E /H /K
  7. Copy pg_hba.conf from <InstallLocation>\Alteryx Analytics Hub\pg_hba.conf to INSTALL_LOCATION\Alteryx Analytics Hub\Postgres\data\pg_hba.conf.
  8. Open Services and restart these services:
    1.  AAHBackend 
    2. AAHFrontend 
    3. Alteryx Engine Worker
    4. Alteryx License Service
    5. AlteryxPostgreSql
  9. Wait 5 minutes to allow the upgrade to complete.
  10. Sign into Analytics Hub and check your user licenses. The upgrade process sets all users to the Analytics Hub User license type. You might see an "Invalid license" error and a negative number in the Available column. To resolve the error, reassign the correct license types.
  11. Check the Data Catalog on all sites. If an error displays (Request failed with status code 400), contact support@alteryx.com for an SQL script to run on your Postgres database.
  12. If previously installed, reinstall Alteryx Intelligence Suite, YXI tools, and Predictive and R tools.
  13. After upgrade, Site Admins should check previous setting values on the Site Admin > Settings page. They should also check the new site settings for Run PriorityData Preview for Data Catalog, and File Upload Restrictions.

Next, upgrade your Analytics Hub Engine Workers.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.