topic Re: QlikSenseUtil Version Mismatch in Management & Governance

QlikSenseUtil Version Mismatch

pauljohansson — Mon, 24 Oct 2022 11:57:37 GMT

I get version mismatch when restoring my backup with the QlikSenseUtil.exe. I have trippled-check that Ive have the same version on my Backup as the Qlik_Sense_setup.exe, which is May 2022.

I still get: version mismatch: Backup and restore is only supported on the same Qlik Sense version, code=-2146233088

Re: QlikSenseUtil Version Mismatch

Eugene_Sleator — Mon, 24 Oct 2022 12:48:14 GMT

Hi @pauljohansson is the patch level of the back up installation and where you are trying to restore the same? You will receive an error is the patch levels do not match also.

Re: QlikSenseUtil Version Mismatch

pauljohansson — Mon, 24 Oct 2022 13:09:00 GMT

@Eugene_Sleator

I want to restore my backup on a Clean machine. My backup is done for QlikSense May 2022 SR4.

Im placing the installation-file for QlikSense May 2022 in designated path when running the QlikSense Utility.

Do you mean that I need to add the Patch file as well and specify the destination for the patch-file while doing the restore?

Paul

Re: QlikSenseUtil Version Mismatch

Eugene_Sleator — Mon, 24 Oct 2022 13:34:48 GMT

Hi @pauljohansson I mean if you back up from QlikSense May 2022 SR4. Then you must restore to QlikSense May 2022 SR4.

Re: QlikSenseUtil Version Mismatch

pauljohansson — Mon, 24 Oct 2022 13:55:57 GMT

I must be missing something here. The installation file does not include the patch, this is a seperate file.

I have:

a clean machine with no QlikSense installation
a complete backup done with the QlikSenseUtility from a QlikSense May 2022 SR4
the installation-file for QlikSense May 2022

Im a missing something to be able to do use the QlikSenseUtility and restore the environment?

Paul

Re: QlikSenseUtil Version Mismatch

Eugene_Sleator — Mon, 24 Oct 2022 14:10:46 GMT

Hi @pauljohansson in this situation you should remove the patch from the installation before backing up the DB.

Then on the clean server restore the DB.

Re: QlikSenseUtil Version Mismatch

pauljohansson — Tue, 25 Oct 2022 08:02:32 GMT

Hej @Eugene_Sleator

We have sheduled backup running weekly using the QlikSenseUtility. So every time we run the backup we should remove the patch on our environment?

Or do you mean that in practice the QlikSenseUtility restore functionality isnt useful unless you always run the inital release?

Paul

Re: QlikSenseUtil Version Mismatch

Eugene_Sleator — Tue, 25 Oct 2022 08:35:56 GMT

Hi @pauljohansson you mentioned "The installation file does not include the patch, this is a seperate file".
If you are intending to install to a clean server. You can install Qlik Sense then install the required patch. At that point you can then restore the database from the backup you made.

Re: QlikSenseUtil Version Mismatch

pauljohansson — Fri, 28 Oct 2022 09:19:33 GMT

Hej @Eugene_Sleator

Thanks for answering!

Can I still use the QlikSenseUtility if I want to restore on a Clean server? That is,

1) Install Qlik and patch to match with backup taken with QlikSenseUtility

2) Use QlikSenseUtility to restore

Or do you mean that if I want to restore on a Clean server and im running a patched Qlik I should not use the QlikSenseUtility as a restore tool?

Paul

Re: QlikSenseUtil Version Mismatch

Eugene_Sleator — Fri, 28 Oct 2022 13:38:02 GMT

Hi @pauljohansson the QlikSenseUtility can be used to restore a DB. If you refer to this article. Download the "Qlik Sense Util Readme.txt" the instructions are contained in that file.

Re: QlikSenseUtil Version Mismatch

pauljohansson — Fri, 28 Oct 2022 14:19:09 GMT

Hej @Eugene_Sleator

I got a answer from your Colleague 😀. Wish you a great weekend!

Paul

"Apparently that possible but we dont have any article on the process. Just the info in the read me file

Personally i don't use that tool, i do it manually.

If you are going to use the same name on the server
- you will have to backup the certificate - https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backing-up-certificates.htm
- backup Sense DB - https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Backing-up-a-site.htm
- then restore the certificate - https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-certificates.htm
- and the the DB - https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-a-site.htm

If you are restoring on a server with a different name, you dont need to backup and restore the certificate.
https://help.qlik.com/en-US/sense-admin/May2021/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Restoring-a-site.htm#Restorin

to respond to the other question.
- you need to install May 2022 on the new server
- you test Sense to make sure it is working
- you patch it to the right version
- then you can start the restore process

Because on are on PostgreSQL 9.6 and the new version will be on 12.5 you will get some error but they can be ignore as explain in that article.
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-May-2021-Upgrade-bundled-PostgreSQL-to-12-5-version/ta-p/1820358

Best Regards,

Boris Iwan
Qlik Support"