Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

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

Andre_Sostizzo
Digital Support
Digital Support

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

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

For specific April 2018 instructions, see Migrating Qlik Sense April 2018 to a new server.
 

Resolution:

 

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)


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

Labels (1)
Version history
Revision #:
4 of 4
Last update:
‎2021-02-11 04:50 AM
Updated by:
 
Contributors