Migrating Qlik Sense September 2017 / November 2017 / February 2018 / April 2018 / June 2018 / September 2018 / November 2018 to a new server

[Andre_Sostizzo]

Migrating Qlik Sense September 2017 / November 2017 / February 2018 / April 2018 / June 2018 / September 2018 / November 2018 to a new server.
 

Information on server migration has also be posted to Qlik Community: Qlik Sense Migration Part1: Migrating your Entire Qlik Sense Environment. If assistance is needed, Qlik Consulting would need to be engaged. Qlik Support cannot provide walk-through assistance with server migrations outside of a post-installation and migration completion break/fix scenario.

(From https://www.youtube.com/watch?v=TLgJmT7RDsw)

Note: If you are migrating and upgrading to Qlik Sense May 2021 or later, the Postgre database version installed on the new machine with the new version will be 12.5. We do not anticipate issues in the restore process.

If you migrate to an old version with 9.6 still installed, and then upgrade to Qlik Sense May 2021 or later, the 9.6 version remains. We recommend to manually upgrading it afterwards, see:  Qlik Sense May 2021 - Upgrade bundled PostgreSQL to 12.5 version.

On the original server

1. In QMC, go to Certificates section and export new certificates using the FQDN of the new server.
   • Be sure to include the Private key
   • We need the certificates to be in the Windows format
2. Record the UNC root path specified in the Service Cluster section in the QMC
3. Stop all services except for the Qlik Sense Repository Database
4. Create a new folder for the backup, e.g. C:\backup
5. Open MMC and Export the Trusted Root Certificate used by Qlik Sense from the Local Computer / Computer Account snap-in. And place it into the backup folder
   • Be sure to include the Private key
6. Take a backup of the database (relevant help link)
   • Sample command: "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\pg_dump.exe" -h localhost -p 4432 -U postgres -b -F t -f "c:\backup\QSR_backup.tar" QSR
7. Copy all subfolders in the UNC root specified in the Service Cluster Section in the QMC to the backup folder
8. Copy the Server certificate from the Exported Certificates folder to the backup folder (default: C:\ProgramData\Qlik\Sense\Repository\Exported Certificates)
9. Optional:
   • Zip the Backup folder for ease of transfer

On the new Server

1. Install all Windows Updates
2. Update to the latest .NET Framework version
3. Verify that the C++ Redistributable is installed and patched
4. Visit help.qlik.com, click on your Sense software version, and verify that all pre-req's are met
5. Once all is complete, now you can install Qlik Sense on the new server (it has to be of the exact same version)
6. During the installation process uncheck the check box to start services after installation. We will want to do extra configuration before Qlik Sense initializes
7. Transfer the backup from the old server to local disk on the new server
8. While the installer is working:
   • Import the Trusted Root and Server certificate into the Local Computer / Computer Account snap-in section in their appropriate areas:
     • Server > Personal
     • Trusted Root > Trusted Root Certification Authorities
       • Note:? Ensure that you mark the certificates as exportable
       • Note: If there are certificates which have already been generated (e.g. issued to newserver.company.com issued by newserver.company.com), then delete those
9. Once the installation has finished, start the Qlik Sense Repository Database
10. Restore the backed up copy of the database
    • Sample command: "C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin\pg_restore.exe" -h localhost -p 4432 -U postgres -d QSR "c:\backup\QSR_backup.tar"
11. If using a different share path for the Qlik Sense content
    • Copy all subfolders from the UNC root specified in the Service Cluster Section in the QMC on the old server into a newly configured UNC path for the new server
    • Open QlikSenseUtil
      • Default path C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe
    • Click Connect to database
    • Enter superuser credentials
    • Click OK
    • Go to the Service cluster section
    • Click OK to get the current values
    • Make the appropriate edits
    • Click Save
    • To validate that the changes have been recorded:
      • Click Clear
      • Click OK
12. To launch Qlik Sense with the new hostname:
    • Open cmd.exe with administrative rights
    • Change the directory to the Repository install path
      • Default path C:\"Program Files"\Qlik\Sense\Repository
    • Execute the following command: Repository.exe  -bootstrap -standalone -restorehostname
13. Allow the Repository.exe to run for a while
    • Key log elements in C:\ProgramData\Qlik\Sense\Log\Repository\Trace\ > System_Repository
      • Since no other services are running, a successful result from this restore command is the Repository to fully initialize but be unable to connect to the other services
14. End the Repository.exe process in Task Manager
15. Start all Qlik Sense services
16. Access the QMC and/or Hub to confirm that all previous working functionality is present

The hostname might need to be manually updated if QMC and Hub do not display. See Qlik Sense Hub and QMC display "This webpage is not available" after a migration

Note: If you are migrating to a different domain, see Qlik Sense and changing the Active Directory Domain name  .