QMetry Upgrade Document (to the Latest Version)

This document provides step-by-step instructions to upgrade QMetry to the latest version. It includes prerequisites, backup guidelines, and detailed steps to ensure a smooth and successful upgrade process with minimal downtime.

System Requirements and Pre-requisites

Before upgrading, ensure the following:

  • MySQL version of QMetry Reports and QMetry Application is 8.0.40.

  • Internet connectivity is enabled on the server.

Upgrading the Existing QMetry Installation

To upgrade QMetry to the latest version, perform the following steps:

Step 1: Important: Backing up the Existing QMetry Database

  1. Create a backup of the "qmetry" database. By default, the backup is saved in the /opt directory.

  2. Run the following command to update the username, password, and location of the backup file:

    docker exec qmetryapp_db sh -c 'exec mysqldump -uroot -p<password> --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_<date>.sql
    Example 9. 
    docker exec qmetryapp_db sh -c 'exec mysqldump -uroot -pqmetry --triggers --routines --hex-blob --single-transaction --lock-tables --no-create-db qmetry' > /opt/qmetry_backup_2021-01-01.sql


  3. Verify that the database is backed up and is available.

Downloading the Upgrade Files

Download the required files by following these steps:

  1. Get the latest version of QMetry Upgrade Installer from the Support Portal.

  2. Download QMetry82411.zip to the QMetry Application Server on the host machine.

Step 3: Running the QMetryUpgrade

To run QMetry Upgrade, perform the following steps:

  1. List the running containers with the following command:

    docker ps

    If Docker is not running, use the following command to start it:

    docker start qmetryapp_db
    docker start qmetry_app_1

    Note

    Replace the container names with the correct application names as specified in the previous command.

  2. Go to the directory where the QMetry 82411.zip file is downloaded. Copy the file inside the Docker container using the following command:

    docker cp QMetry82411.zip qmetry_app_1:/opt

    Note

    Your current Tomcat installed path in Docker container is /home/qmetry/QMetry.

  3. Log in to the Docker container using the following command:

    docker exec -it qmetry_app_1 bash
  4. Go to /opt directory where the QMetry 82411.zip file is copied using the following command:

    cd /opt
  5. Unzip the file under the /opt directory, separate from your current installation path - /home/qmetry/QMetry

    unzip QMetry82411.zip
  6. Go to the QMetry directory:

    cd QMetry82411
  7. Run the following command to grant execution permissions to the upgrade script.

    chmod +x upgrade_qmetry.sh
  8. Run the following command.

    Note

    The process may take some time to complete. Kindly be patient and allow it to finish properly.

    sh upgrade_qmetry.sh

Step 4: Verify Upgrade Completion

The upgrade utility will prompt you to confirm whether you want to proceed with the upgrade.

Options

Type

Default Value

Comments/ Example

Do you want to proceed with the QMetry upgrade (Y/N)?

Mandatory

-

type - Y/N

Exit from the Docker container once the process is completed, use the following command:

exit

Step 5: Restart QMetry and MySQL Docker Container

  1. List the running containers:

    docker ps
  2. Restart both Docker containers:

    docker stop qmetry_app_1 qmetryapp_db
    docker start qmetryapp_db
    docker start qmetry_app_1

Step 6: Install or Upgrade QMetry Jira Add-on

Download the correct Jira add-on version that matches your QMetry version. Refer to the table below to find the compatible Jira add-on version based on your QMetry version.

Table 16. Install or Upgrade QMetry Jira Add-on

QMetry Version

Jira-addon version required

8.24.x

2.3.9_jira9 (Jira Version 9x), 2.3.9 (Jira Version 10x)

8.23.0

2.3.7_jira9 (Jira Version 9x), 2.3.7 (Jira Version 10x)

8.22.1

2.3.5

8.21.0

2.3.3



In case you have not installed the QMetry Jira Integration app for integration, follow the Steps to Install and Configure the QMetry Jira Integration app, if it is not installed.Install & Configure QMetry's Jira Integration App

If you are facing any issues during the upgrade process, generate a support ticket on Support Portal for assistance.

Publication date: