Insights 1.2 to 1.11.2 Single Server Upgrade Guide for Windows

In this guide we'll run you through upgrading qTest Insights 1.2 to Insights 1.11.2 on a Windows Machine

Before you begin

Before you upgrade qTest Insights 1.2, make sure following things are done:

• qTest Manager has been upgraded to 8.4.4 
• qTest Sessions has been upgraded to 3.0.9
• Access to the server where you install qTest Manager's Database, connect to your Manager database and create a schema for Insights as following instructions:

Connect qTest DB using postgres user

C:\Program Files\PostgreSQL\9.5\bin>psql -h [Your_Postgres_server_address] -U postgres -W [Your_qTest_DBName]
Password for user postgres: //enter your password here

Create Insights schema

create schema [Insights_Schema];

 

Upgrade qTest Insights from 1.2 to 1.11.2

 

1. Stop current Insights service, Insights Scheduler service

• Open command prompt and type services.msc to open Services window 
• On Services window, look for the service named qTest Insights Scheduler and qTest Insights. Stop both of them

2. Install qTest Insights 1.11.2

2.1 Click this link to download the installation package

2.2 Extract the package and access the directory "\qtestctl-windows-x64\qtestctl" 

2.3 Open the file \qtestctl\qtest.config and follow instructions below to modify it.  

// list of applications
apps = ['insights']

insights {
 //HTTP Port of qTest Insights 
 httpport = 8081
 //Admin Port of qTest Insights
 adminport = 8007
 
 postgres {
 auth {
 user = 'postgres' 
 //Password of user postgres to qTest Manager DB
 pass = 'root'
 }
 }

 scheduler {
 //Scheduler port, make sure this port is avalable
 port = 56982

 passKey = 'defaultKey'
 //scheduler host (same machine with insights)
 server = 'localhost'
 }

 etl {
 //path to directory where you installed jsvc on Linux, please ignore this if you're installing on Windows
 jsvc = '/usr/bin/jsvc'

 //default period of time etl run to update project module and test cycle, default is 10
 cylcleupdateinterval = 10
 projectmoduleupdateinterval = 10
 }
}

session {
 //IP of Sessions' Postgres Database
 host = '52.192.91.55'
 //Port to Sessions' Postgres Database
 port = 5432

 postgres {
 auth {
 user = 'postgres'
 //Password of user postgres to qTest Sessions DB
 pass = 'root'
 }
 db {
 //Sessions DB
 session = 'sessions'
 }
 }
}

postgres {
 //IP of qTest Manager's Postgres DB
 host = '52.192.91.56'
 //Port to qTest Manager's Postgres DB
 port = 5432
 auth {
 user = 'postgres'
 //Password of user postgres to qTest Manager's Postgres DB
 pass = 'root'
 }
 db {
 //qTest Manager's DB
 qtest = 'qtest'
 }
}

/* DO NOT EDIT ANYTHING BELOW THIS LINE */

insights {
 version = '1.0'
}
insightsscheduler {
 version = '1.0'
}
insightsetl {
 version = '1.0'
}

postgres {
 url {
 qtest = "jdbc:postgresql://${postgres.host}:${postgres.port}/ 
${postgres.db.qtest}"
 }
}

 

2.4 Install & Start qTest Insights 1.11.2

Open the console on your machine, change the current path to qtestctl directory and run following command to let Insights run as service and run following command

 C:\[path_to_qtestctl]>install.bat

Start

 C:\[path_to_qtestctl]>qtestctl.bat start

 

3. Migrate data from Insights 1.2 to Insights 1.11.2

3.1 Stop Insights 1.11.2

 C:\[path_to_qtestctl]>qtestctl.bat stop

 

3.2 Migrate Scheduler data

Copy data from directory \qTest Insights 2\local\insights-scheduler\Schedules of Insights 1.2

to new location of Insights 1.11.2 at 

\qtestctl-windows-x64\qtestctl\insights\build\insightsscheduler\Schedules

 

3.3 Migrate web data

Under Root folder of Insights 1.2 \qTest Insights 2\local\insights\webapps\ROOT

copy following folders 

CustomReports
ExecutedReports
rdDataCache
rdDownload
SavedBookmarks
SavedDashboards

to new location of Insights 1.11.2 at \qtestctl-windows-x64\qtestctl\insights\build\apache-tomcat-8.5.15\webapps\ROOT

 

4. Start Insights 1.11.2

Start Insights 1.11.2

 C:\[path_to_qtestctl]>qtestctl.bat start

 

That's everything and you now have qTest Insights being upgraded to 1.11.2. You want to access to your qTest Insights instance via browser to verify if the upgrade process completes successfully, then you may want to unintall qTest Insights 1.2.