1 Steps to upgrade QMetry to the latest version

If you are upgrading the QTM app to version 8.18.1, it is essential to update the Automation API to the latest version. Refer to Install Automation API Feature (RHEL8 & Podman).

Steps to upgrade QMetry to the latest version

Pre-requisites

MySql version of QMetry Reports and QMetry Application should be 8.0.40.
Ensure internet connectivity is enabled on the server for this upgrade.

Steps to upgrade existing QMetry installation:

Step 1: IMPORTANT: Backup existing QMetry Database

Take the backup of your existing “qmetry” database. You can replace the username, password, and location of the backup file (currently default /opt).

podman 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

For example:

podman 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

Verify that your database has been backed up properly and is available for later use in case of any emergency.

Step 2: Download Required Files

You can generate a request on the QMetry Support Portal, to get the latest version of QMetry Upgrade Installer.
Download the QMetry8181.zip to your QMetry Application Server once you receive it.

Step 3: Run the QMetry Upgrade

1. Check the running containers using the following command. The containers must be running to ensure a successful upgrade.

podman ps

If the containers are not running, start them using the below commands (replace container names according to the application container name seen in the command above)

podman start qmetryapp_db
podman start qmetry_app_1

2. Go to the directory where the QMetry8181.zip file is downloaded.

3. Copy QMetry8181.zip file inside the app container using the following command.

podman cp QMetry8181.zip qmetry_app_1:/opt

Your current tomcat installed path in the container would be /home/qmetry/QMetry.

4. Log in to the container, using the following command:

podman exec -it qmetry_app_1 bash

5. Go to /opt directory where the QMetry8181.zip file is copied using the command:

cd /opt

6. Unzip the file under the /opt directory separate from your current installation path: /home/qmetry/QMetry

unzip QMetry8181.zip

7. Go to QMetry directory:

cd QMetry8181

8. Give permission to upgrade_qmetry.sh file through the following command.

chmod +x upgrade_qmetry.sh

9. Enter the following command and then pass the parameters mentioned.

./upgrade_qmetry.sh

10. Utility will confirm if you want to upgrade, type Yes, and then specify the path of the existing QMetry installation.

Options	Type	Default Value	Comments/ Example

Options	Type	Default Value	Comments/ Example
Do you want to proceed with QMetry upgrade (Y/N)?	Mandatory	-	type - Y/N

Wait for the process to complete.

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

exit

Step 4: Restart QMetry and MySQL Containers

Check the running containers using the following command:

podman ps

Restart both containers using the following commands:

systemctl stop qmetryapp
systemctl stop qmetrydb
systemctl start qmetrydb

Wait for around 10 seconds, then execute the following command.

systemctl start qmetryapp

Step 5: Installing / Upgrading the Jira add-on for the Integration of QMetry and Jira.

It is important to have the correct version of the Jira add-on installed in Jira based on your upgraded and current QMetry version. Refer to the below table for the right version of "QMetry Jira Integration".

QMetry Version	Jira-addon version required

QMetry Version	Jira-addon version required
8.18.1 & above	2.2.9, 2.3.0_jira9 (Jira Version 9x), 2.3.0 (Jira Version 10x)
8.17.1	2.2.8
8.17.0	2.2.7

Upgrade your Jira add-on as per the above compatibility matrix. 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.

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