topic Re: Qlik Sense - Version Upgrade in Management & Governance

Qlik Sense - Version Upgrade

Nicolae_Alecu — Wed, 20 Mar 2024 10:46:19 GMT

Hello,

Currently I'm using Qlik Sense May 2022, but i want to upgrade to Nov 2023.

Can i upgrade directly to this version, or it could create problems?

Thank you,

Re: Qlik Sense - Version Upgrade

p_verkooijen — Wed, 20 Mar 2024 10:56:53 GMT

Best to uninstall any patch before upgrades.

Probably you have to upgrade PostgreSQL using QPI
The Nov 2023 installer will inform you if you have to upgrade.

As of March 2023, PostgreSQL 9.6 is no longer supported.

https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-postgresql-using-qpi.htm

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

https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repository-Database/ta-p/1934238

Re: Qlik Sense - Version Upgrade

Chetan_MN — Wed, 20 Mar 2024 12:35:01 GMT

Hi @Nicolae_Alecu Yes, you can upgrade but you need to have the Postgres upgraded to 14.8 (suggested) using QPI.

https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Deploy_QSEoW/Installing-postgresql-using-qpi.htm?_ga=2.85325273.1954164248.1710739394-1641685188.1697601982

Note: below steps are required. Failing to remove the old service will lead to upgrade or patching issues.

Open a command prompt and run:

c:\cd ProgramData\Package Cache
From there, do one of the following:
- If you upgraded from 9.6, run:
  
  c:\ProgramData\Package Cache\dir /s PostgreSQL.msi
  
  The folder containing PostgreSQL.msi is displayed.
- If you upgraded from 12.5, run:
  
  c:\ProgramData\Package Cache\dir /s PostgreSQL125.msi
  
  The folder containing PostgreSQL125.msi is displayed.
Right-click the PostgreSQL.msi or PostgreSQL125.msi file and select Uninstall from the menu.

Re: Qlik Sense - Version Upgrade

Nicolae_Alecu — Wed, 20 Mar 2024 14:32:20 GMT

Hello @p_verkooijen, @Chetan_MN,
Thanks for your responses, but i have one more question.

We run a multi-node enviroment, and our repository it's on Azure Postgres Service.
Now, if i check the postgres version in QSR (PostgreSQL Shell) i have this one : "PostgreSQL 11.18, compiled by Visual C++ build 1800, 64-bit" .

But if i'm looking into "C:\Program Files\Qlik\Sense\Repository\PostgreSQL" there is a folder "12.5"

Now i'm a little bit confused, why do i have a version in Qlik folder and another one on postgresql server?

Since i'm not using 9.6, it is a must to upgrade PG version?

Re: Qlik Sense - Version Upgrade

Chetan_MN — Thu, 21 Mar 2024 07:05:24 GMT

Hi @Nicolae_Alecu Currently Postgres 9.6 is not supported. If you are upgrading Qlik Sense to Nov 2023, it supports below Postgres versions.

PostgreSQL:

14.x
13.x
12.x
11.x

I would suggest you to have a proper backup of the environment and then proceed with Qlik Upgrade.

Perhaps if you have test environment, it would be good to try it there before moving it to Prod.

Re: Qlik Sense - Version Upgrade

Nicolae_Alecu — Thu, 21 Mar 2024 11:08:27 GMT

Hi @Chetan_MN ,

As far as i understand, QlikSense - Nov 2023 version should work with PostgreSQL 11.18 as well, right?

Re: Qlik Sense - Version Upgrade

Chetan_MN — Thu, 21 Mar 2024 12:31:16 GMT

Hi @Nicolae_Alecu Yes, 11.x versions are supported, meaning all the sub version under 11 are supported.
example: 11.18