Upgrade to May 2025 failed

[Lauri]

I just tried upgrading to May 2025 from Feb 2024 and it failed. This happened when I tried to upgrade from Feb 2024 to May 2024 a year ago. I updated to Postgres 12.5 over a year ago using the Qlik updater software. Here's a screenshot of today's log files from the upgrade attempt. 

It's concerning that there's a log for Postgres 125 AND for 14... and then there's a rollback log for 14.

Any suggestions?

[Lauri]

Also, the Qlik rollback failed, so Qlik is completely corrupted. I'm rolling back the entire server OS. This happened to me a year ago too. 

[Lauri]

I see this in Qlik Help: "The Qlik Sense installer cannot use SSL encryption for establishing a connection to PostgreSQL. When SSL encryption is enabled, the installer does not recognize any already installed PostgreSQL databases, as a result, the installation cannot be completed. You should temporarily disable SSL during installation or upgrade."

Can anyone advise me on how to temporarily disable SSL?

[Lauri]

Update: According to this KB article, systems in which Postgres was upgraded with QPI, and systems with standalone Postgres, the Qlik update software must be run with the database service running. Qlik's Help web page doesn't mention this. My next step is to try again with this change to my process.

[1000qlik]

Hi Lauri,

Did you manage to solve your issue?

[Lech_Miszkiewicz]

 Hi @1000qlik 

There are very clear instructions on what needs to happen when you upgrade postgres using external postgres installer and how it will impact future upgrades if those are not done according to required steps. 

https://community.qlik.com/t5/Official-Support-Articles/Upgrading-and-unbundling-the-Qlik-Sense-Repo...

EVERY step on that document IS IMPORTANT! and if missed it results in future upgrade failures.

cheers

[Lauri]

@1000qlik  - I haven't yet tried again. If it fails again, even with the db running, I think the solution is to do a clean install (of the version of Sense I'm currently on) and restore from backup. And then I'll try to upgrade.

[Lauri]

Update on my attempts: I stopped all Qlik services except for Repository Database service, then ran the update for May 2025. It failed while upgrading the Service Dispatcher with this error in the log:

CAQuietExec: + throw "Error executing database comman ...
CAQuietExec: + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CAQuietExec: + CategoryInfo : OperationStopped: (:) , Exception
CAQuietExec: + FullyQualifiedErrorId : Error executing database command "CREATE SCHEMA qlik_notifier_service AUTHORIZATION "qli
CAQuietExec: ksenserepository"": ERROR: permission denied for database SenseServices

I restored the server to the previous backup. I opened PGadmin and granted permissions (I ran the SQL command in this post). The update failed again at the Service Dispatcher with this error:

CAQuietExec: Error executing database command "CREATE SCHEMA "dataprep_service" AUTHORIZATION "qliksenserepository"": ERROR:
CAQuietExec: schema "dataprep_service" already exists

I now wonder if the problem is due to Qlik thinking that we have both postgres 12.5 and postgres 14 installed, if that's possible. There are log files for both versions, in the logs from the update attempt. I upgraded postgres from 9.6 to 12.5 with QPI over a year ago and then later to 14 as part of a Sense update. The server has only the v14 folder (C:\Program Files\Qlik\Sense\Repository\PostgreSQL\14). Yet the "PostgreSQL125.log" contains this towards the end:

MSI (s) (F8:40) [11:44:59:955]: Product: PostgreSQL125 -- Installation completed successfully.

And same for "PostgreSQL14.log:"

MSI (s) (F8:74) [11:47:40:354]: Product: PostgreSQL14 -- Installation completed successfully.

Any ideas? Many thanks.

[Lech_Miszkiewicz]

HI @Lauri  - Absolutely - you probably missed below step when you upgraded in the past: 

I keep repeating that you must make sure that all steps were taken care of when your postgres DB was updated. If in the past you missed a step (like removing old services etc) that will cause issues as per link I have provided month ago (below).

Once you restore your server first make sure you check this 16th point and in fact check all other points as well. There are some points where there are certain paths you should have updated if you upgraded your postgres in the past. Missing those steps was usually issue in my case in the past.

cheers and good luck

[howdash]

I wrote an article on this topic a while ago. It demos the issues I've been having after using the QPI tool and how to avoid them. Here's the link to the article:

https://www.linkedin.com/pulse/how-crash-your-qlik-sense-server-during-upgrade-qpi-patches-u9dke

The short version is that the QPI tool is...I don't know...let's say inflexible, for the lack of better word. QPI Tool:

• Can only be ran on an Initial Release version of Qlik Sense.
• The original Qlik Sense Repository Database service must be uninstalled after QPI tool is ran.
• PostgreSQL binaries must be reinstalled.

These three points are non-negotiable steps that must be completed. If any of them are skipped, like @Lech_Miszkiewicz mentioned, you will have issues down the road when upgrading Qlik Sense.

I'm thinking of creating a more detailed guide with screenshots showing how to use the QPI tool to upgrade bundled PostgreSQL server. If you'd like me to create a guide, give me a like or just reply and let me know that you'd like to see one and I'll get it created.