Qlik Sense Upgrade Fails On Environment With Manually Migrated PostgreSQL database

Andrew_Delaney — Mon, 24 Jul 2023 09:01:59 GMT

The Qlik Sense installer expects either the included database to be present, or a separately hosted database to be present when upgrading. If both are present, the installer stops progressing during the database upgrade step.

A review of the logs will show that the installer is correctly connecting to the separately hosted database but for some reason just ceases to progress. No error is displayed to the user, but Qlik Sense will never successfully upgrade.

Resolution

The simplest workaround for this issue is:

Uninstall the existing version of Qlik Sense (retaining the certificate). This will remove the remaining traces of the bundled PostgreSQL
Rename the C:\ProgramData\Qlik\Sense folder
Reinstall the same version of Qlik Sense which was previously uninstalled
Verify functionality and that Qlik Sense connects to the standalone database
Upgrade

Cause

This happens when the manual migration did not fully clean up and remove the old bundled database, it can occur even if you have removed the Qlik Sense Repository Database service and removed the files that the database uses.

article Qlik Sense Upgrade Fails On Environment With Manually Migrated PostgreSQL database in Official Support Articles

Qlik Sense Upgrade Fails On Environment With Manually Migrated PostgreSQL database

Resolution

Cause

Environment