Migrating Qlik Sense Client-Managed

[Sonja_Bauernfeind]

This Techspert Talks session covers:

• Demo of migration process
• Back-up Best Practices
• Troubleshooting Certificates

Chapters

• 01:40 - Demo Environment Overview
• 03:08 - Installation Requirements
• 04:55 - Backing up Certificates
• 07:43 - Qlik Share drive
• 07:56 - Backing up the Database
• 10:35 - Importing Certificates
• 12:49 – Installation
• 16:08 - Restoring the database
• 19:18 - Troubleshooting start-up issue
• 23:30 - Q&A: How to migrate additional work?
• 24:19 - Q&A: How to export multiple apps?
• 24:57 - Q&A: How to apply a patch?
• 25:56 - Q&A: First upgrade or migrate?
• 26:58 - Q&A: How to migrate to Qlik Cloud?
• 28:29 - Q&A: How to migrate reload tasks?
• 28:53 - Q&A: Can we create an image for testing?
• 30:03 - Q&A: What if monitoring apps fail to reload?
• 31:27 - Q&A: How to migrate to AWS?
• 31:53 - Q&A: How to migrate NPrinting?
• 32:29 - Q&A: How to migrate Web Connectors (QWC)?

Resources

• Backup and restore Qlik Sense Enterprise on Windows
• Planning your migration to Qlik Cloud
• Backing up certificates
• Backingup and restoring NPrinting
• Installing Qlik Web Connectors

• Upgrading and unbundling the Qlik Sense Repository Database using the Qlik PostgreSQL Installer

• Qlik Sense Upgrade Guide

 

Click here to see video transcript

[Narges]

@Sonja_Bauernfeind  Hi Sonja, in the video, when we want to get back up from QlikSite it said that we should stop all services except the repository database. it is also mentioned here Backing up a Qlik Sense site | Qlik Sense for administrators Help , I dont have this service on my QlikSense server and I assume it's due to the DB upgrade from 9.3 to 12.5 via QPI tool, do you see any issue by the stopping all Qlik services and let postgres to run and then take a backup from Qlik site?

[Sonja_Bauernfeind]

Hello @Narges 

You assume correctly. The "Repository Database" is what PostgreSQL is called when it is bundled with Sense. In your case, if you used QPI, then the PostgreSQL database is a standalone DB and will show up with its own name. Treat it just as you would treat the Repository Database Service. If the instructions need the database to run, the database should run.

All the best,
Sonja 

[mikegrattan]

I attempted to do a migration this weekend and got all the way to the bootstrap process, when I got a fatal error about an RSA key.  What is the cause and how do I fix it?

[ERROR] Fatal exception during bootstrap: There is no RSA private key associated with this certificate. at Qlik.Sense.Communication.Security.Certificates.DotNetCert.SetPrivateKeyAccess(IdentityReference identityReference)
at Qlik.Sense.Common.Security.SecuritySetup.SetupCA(String externalRootCertThumbprint, ICipherAlgorithm secretsAlgorithm, Boolean forceNewSetup, Boolean selfSignedRootBasicConstraintsCA)
at Repository.Core.Bootstrap.RepositoryBootstrapper.Install(BootstrapState bootstrapState)
at Repository.Core.Bootstrap.BootstrapHandler.Install(BootstrapState bootstrapState)
at Repository.Core.Bootstrap.BootstrapHandler.Bootstrap(BootstrapState bootstrapState)
at Repository.QRSMain.Bootstrap()
at Repository.QRSMain.Main()
at Repository.QRSMain.Run(String[] args, Action`1 terminate)
Bootstrap mode has terminated. Press ENTER to exit..

[snibrahim1993]

Hi @mikegrattan ,

Maybe the certificates got corrupt, I hope the below link will help you.

Thanks.

[ERROR] Fatal exception during bootstrap: There is... - Qlik Community - 1968442

[mikegrattan]

Hi @snibrahim1993 .  Thanks for the link...I'll look into it.