Document toolboxDocument toolbox

Upgrading Qualitia Server and Client

Owned by ravi.chandran (Unlicensed)
Last updated: Feb 19, 2021
6 min read

Applying product updates will give you an enhanced experience of working with Qualitia Automation Studio.

Prerequisites

    • Qualitia WebDriver 5.x or above

    • It is strongly recommended to backup Qualitia server databases (Master, Project, and Result Databases).

    • If MySQL database server is installed on Linux machine, ensure that the values of column ProjectName and ProjectDBName names are in the lowercase under Master Project database in the table tblprojects. Entering project names in uppercase may cause failing upgrade process.

    • Ensure port 8887 and 8889 are open and accessible from the machine where you are installing Qualitia Server.

    • If the number of projects to be upgraded is more than 50, increase the max_connections limit from MySQL database configuration settings. For more information about increasing the limit, refer to Qualitia Troubleshooting section.

    • Close all the instances of Qualitia Automation Studio and Internet Explorer before starting the upgrade process.

    • If Qualitia Automation Studio is open, the upgrade process closes all the active Qualitia instances. If you have multiple Qualitia instances open, ensure to save the changes and close all the Qualitia instances before starting the upgrade process. For a detailed list of prerequisites, refer to the Prerequisites and Configurations section.

Upgrade Qualitia Server

Automatic Process

If you have installed Qualitia client on the same machine where Qualitia Server is installed, Qualitia intelligently picks up the upgrade packages, when available. Qualitia administrator has to log in to Qualitia client to initiate the automatic upgrade process.

From Qualitia v8.1.0, if some project fails to upgrade, you need to restore the backup of the projects that failed to upgrade.

To update Qualitia Server:

  1. /wiki/spaces/TEST1/pages/1718944196
  2. Open the Qualitia Update Location defined when Installing Qualitia Server.
  3. Replace the content with Qualitia Product Update.
    (info) Once the Qualitia Update Package is placed on the designated location, Qualitia intelligently picks it up when logging on as an administrator user.
  4. Log on to the machine where you have installed Qualitia Server.

  5. Perform the step only if your database is MySQL  8.0. Trigger a command as "GRANT ALL PRIVILEGES ON `database_name`.* TO 'user_name'@'%';" to all the following databases:
    1. Qualitia Master  Database
    2. Dashboard Database
    3. Each Project Database
    4. Each Project Result Db

      Note: database_name refers to databasename and user_name refers to your user Id.
      After executing the command, FLUSH PRIVILEGES to refresh access.
  6. Log on to Qualitia Client as Qualitia Administrator user.
  7. Once you enter user credentials and click Log On, Qualitia informs the user that the next update is available.



  8. Do one of the following:
    • If you want to update Qualitia Server, click Yes.
    • If you want to ignore the update and continue working on the previous version, click No.
  9. It is recommended to use the updated product versions applying available product updates for seamless user experience.
  10. Once you click Yes, Welcome to the Qualitia Setup Wizard screen appears.



  11. Click Next.
    All the database server details appear.
  12. All these fields are displayed in non-editable mode, click Next.



  13. Click Next and you will see the master database name.

  14. Select the Enable Dashboard option, if you want to enable Dashboard functionality.
    For more information about the dashboards functionality, click here.

    Enabling this option, Qualitia consumes an additional database (except master and project databases) for managing data related to the dashboard functionality. Kindly make a note of it. 

  15. Enter the desired Dashboard Database name and click Next.


    If you are upgrading from a previous QAS version to v8.1.x where some projects are integrated with TFS/Azure DevOps and their Test Case template file in the latest version of Qualitia have changed, the linked test cases metadata files are automatically upgraded to their latest versions. You can view the TFS/Azure DevOps integrated projects that are upgraded, and click Next.

  16. The Project Details screen appears. You can view the projects selected for upgrade. Click Next.



  17. Specify the Result Path to store results of the test cases executed outside Qualitia and click Next.

    Qualitia uses this folder to store results of test cases executed through CI Tools (Jenkins, TeamCity, Bamboo), Build / Release Cycles from TFS/Azure DevOps, and offline package.
    All the Qualitia clients should have read access to this directory.



  18. Enter the Qualitia License Server IP address and click Next.
  19. Click  Upgrade as shown in the following figure:
  20. If some projects fail to upgrade, then you need to restore the backup of the projects that failed to upgrade and perform the steps from the beginning. 
  21. Click Next.
    The Confirm Installation screen appears.



  22. Click Install.
    The following screen appears:
  23. You can do the following actions:
    1. Click View Report to view the upgrade status of every project.
    2. Click View Log to view the logs.
      Note: If any project fails to upgrade, you need to perform the upgrade process from the beginning for the projects that failed to upgrade only.
  24. If some projects fail to upgrade, you need to restore their backup and perform the upgrade process again for them.
  25. Once installed successfully, click Finish to exit the setup.
  26. Install / Upgrade Qualitia Client on this machine.  

Manual Process

If Qualitia client is not installed on the machine where Qualitia server is installed, you must run Setup.exe manually to upgrade server.  

To update Qualitia Server:

  1. Ensure you have the valid product license activated for Qualitia.
  2. Open the Qualitia Update Location defined when Installing Qualitia Server.
  3. Replace the content with Qualitia Product Update.
  4. Log on to the machine where Qualitia Server is installed and navigate to the Qualitia Update Location where you have kept the product update.
  5. Perform the step only if your database is MySQL  8.0. Trigger a command as "GRANT ALL PRIVILEGES ON `database_name`.* TO 'user_name'@'%';" to all the following databases:
    1. Qualitia Master  Database
    2. Dashboard Database
    3. Each Project Database
    4. Each Project Result Db

      Note: database_name refers to database name and user_name refers to your user Id.
      After executing the command, FLUSH PRIVILEGES to refresh access.
  6. Open Server folder.
  7. Right-click Setup.exe and select Run as administrator.
    The Welcome to the Qualitia Setup Wizard screen appears.



  8. Click Next.
    All the database server details appear.
  9. All these fields are displayed in non-editable mode, click Next.



  10. Click Next and you will see the master database name.

  11. Select the Enable Dashboard option, if you want to enable Dashboard functionality.
    For more information about Web Dashboards, click here.

    Enabling this option, Qualitia consumes an additional database (except master and project databases) for managing data related to the dashboard functionality.

    You may choose to enable dashboard after the upgrade process is completed. For more information about enabling dashboard functionality later, click here. 

  12. Enter the desired Dashboard Database name and click Next.



    The Project Details screen appears.


  13. Specify the Result Path to store results of the test cases executed outside Qualitia and click Next.

    Qualitia uses this folder to store results of test cases executed through CI Tools (Jenkins, TeamCity, Bamboo), Build / Release Cycles from TFS/Azure DevOps, and offline package.
    All the Qualitia clients should have read access to this directory.



  14. Enter the Qualitia License Server IP address and click Next.
  15. Click Next.
    The Confirm Installation screen appears.



  16. Click Install.
    The following screen appears:
  17. You can do the following actions:
    1. Click View Report to view the upgrade status of every project.
    2. Click View Log to view the logs.
      Note: If any project fails to upgrade, you need to perform the upgrade process from the beginning for the projects that failed to upgrade only.
  18. Once installed successfully, click Finish to exit the setup.
  19. Install / Upgrade Qualitia Client on this machine.  

Upgrading Qualitia Client

Once the administrator has updated Qualitia Server, other Qualitia users can update respective clients.

To update Qualitia Client:

  1. Log on to the machine where you want to upgrade Qualitia client. 
  2. Close all the instances of Internet Explorer and do not open it during the installation process.
  3. Double-click the Qualitia icon.
    If the server is updated, Qualitia users (other than the Qualitia administrator) will get a notification about updating Qualitia Client.
    (warning)     Qualitia users will not get this notification if Qualitia Server is not updated.



  4. Once the installation process is completed, click Finish.